Search Discussions

159 discussions - 686 posts

  • Hello DBA's, Good Morning!! Hoep everyone is doing a great job. I am stuck in middle of database refresh activity. I just got to know that the target Production database which I was refreshing was of ...
    Nilesh kumarNilesh kumar
    Nov 9, 2009 at 2:01 pm
    Nov 12, 2009 at 1:33 pm
  • Hi, After the upgrade over the weekend, are people finding that searching for patches is turning up nothing? I looked for the patchset for RDBMS Server on Linux x86-64 and nothing turns up ...
    Thomas RoachThomas Roach
    Nov 9, 2009 at 2:07 am
    Nov 17, 2009 at 8:24 pm
  • Hello All, I am troubleshooting cache buffer chain latch issues in running on SPARC CMT cpu. I have AWR report, and I've determined which query is responsible for the bulk of the waits. For ...
    Christo KutrovskyChristo Kutrovsky
    Nov 19, 2009 at 10:56 pm
    Dec 16, 2009 at 7:42 pm
  • Here's the situation: Database is 10gR2 (This is for a friend, so I don't have any more specifics than what he described) I need to update millions of records in an address table, specifically 2 ...
    Chet justiceChet justice
    Nov 19, 2009 at 10:02 pm
    Nov 30, 2009 at 1:46 pm
  • Just a quick thought... One thing you can try is to take a 10053 trace, and check for the values of the various underscore (optimizer features), as well as bugfixes listed in the tracefile, for both ...
    Stefan KnechtStefan Knecht
    Nov 23, 2009 at 11:55 pm
    Nov 30, 2009 at 9:17 pm
  • Hi list, When I tried to search something in the metalink a while ago, it throws me following ORA error: ORA-00372: file 102 cannot be modified at this time ORA-01110: data file 102 ...
    Syed Jaffar HussainSyed Jaffar Hussain
    Nov 7, 2009 at 12:13 pm
    Nov 9, 2009 at 2:09 pm
  • We have several large warehouse databases in the 12T to 15T range. The normal run time for our RMAN backup scripts more than doubled after upgrading to 11g. The scripts do use compression which seems ...
    Peter BarnettPeter Barnett
    Nov 2, 2009 at 2:50 pm
    Nov 3, 2009 at 4:35 pm
  • You might want to try some of these suggestions from Jonathan Lewis: http://www.freelists.org/post/oracle-l/oraclel-Digest-V3-207 Regards, Brandon Privileged/Confidential Information may be contained ...
    Allen, BrandonAllen, Brandon
    Nov 17, 2009 at 10:15 pm
    Dec 11, 2009 at 4:14 pm
  • I am sorry Chris but what exactly is wrong with the mail. I think if you take each sentence you will find it factually correct. I suspect that the benefits from MOS have been exaggerated but are ...
    John HallasJohn Hallas
    Nov 13, 2009 at 9:57 am
    Nov 13, 2009 at 7:14 pm
  • Hi, When investigating a performance problem using sql trace for a client, I came across a (huge) select statement, for which the elap value in the exec call was more then 4 seconds. EXEC ...
    D'Hooge FreekD'Hooge Freek
    Nov 3, 2009 at 4:36 pm
    Nov 6, 2009 at 3:53 pm
  • Hi John, For table scan on the small table that only 1 extent, there are 2 read on segment header, 1 for extent count(guess), 1 for hwm. The rest reads for the data blocks under hwm. Here is an ...
    Nov 18, 2009 at 7:25 am
    Nov 20, 2009 at 4:00 am
  • Is there a way to modify the collection interval for a metric in Grid Control? I have a Database Target and I goto "ALL METRICS". Under this menu I see "TABLESPACE ALLOCATION" that has both ...
    Taylor, Chris DavidTaylor, Chris David
    Nov 4, 2009 at 1:58 pm
    Nov 4, 2009 at 4:03 pm
  • Is there a quick way to drop all objects in a schema without dropping the user itself? This is with Oracle 10. -- http://www.freelists.org/webpage/oracle-l
    John DunnJohn Dunn
    Nov 19, 2009 at 9:25 am
    Nov 20, 2009 at 12:47 am
  • Is anyone aware of any open source, free, or inexpensive software that performs functionality similar to Database Replay (part of Oracle's 11g Real Application Testing)? I found iReplay (here ...
    Allen, BrandonAllen, Brandon
    Nov 6, 2009 at 9:08 pm
    Nov 7, 2009 at 9:12 am
  • Folks, I'm looking for recommendations on bonded NIC pairs used for RAC private interconnects, in terms of their configuration - active-active vs. active-backup. Take the switch out of the equation ...
    Herring Dave - dherriHerring Dave - dherri
    Nov 30, 2009 at 11:53 pm
    Dec 1, 2009 at 2:02 pm
  • This sounds to me like first of all you need to define what exactly you want to tune, before looking for performance tools. As depending on what your problem is, many tools are simply worthless. I ...
    Stefan KnechtStefan Knecht
    Nov 25, 2009 at 2:48 pm
    Dec 25, 2009 at 6:17 am
  • Hi Does anyone know if opt_param hint works with optimizer_features_enable in I am testing it and it seems that it gets ignored enable event 10132 SELECT /*+ ...
    LS ChengLS Cheng
    Nov 24, 2009 at 7:14 am
    Nov 25, 2009 at 12:41 pm
  • Hi Do you have scenarios or cases where you have Multiple ASM instances running on the same box . I have 3 databases and 3 ASM instances for each database on the same box. This is working on ...
    Kumar MadduriKumar Madduri
    Nov 20, 2009 at 3:52 am
    Nov 20, 2009 at 9:40 pm
  • Does someone here know the date that 10gR2 goes into Extended Support? In particular, 10gR2 on 32 Bit RH Linux (ES 4) I've tried MOS, but I consistently get 404 errors trying to access the documents ...
    Jared StillJared Still
    Nov 18, 2009 at 6:57 pm
    Nov 19, 2009 at 9:41 pm
  • Solaris 10 update 4 on SPARC All, I have a CTAS that involves a CLOB. The expected duration of this process is 180 minutes. Recently it started taking 5 hours. The data and rowcounts are ...
    Josh CollierJosh Collier
    Nov 2, 2009 at 7:30 pm
    Nov 3, 2009 at 10:28 pm
  • I am testing out the new filewatcher functionality in 11gR2. However, I cannot seem to get it to work and the dba_scheduler* views are reporting that it is succeeding, but nothing is being written to ...
    Daniel FinkDaniel Fink
    Nov 20, 2009 at 4:52 pm
    Dec 7, 2009 at 4:55 am
  • Toons and Richard gave you some very nice ones. To those I would add the ability, in the event that your application includes access over a wide area, to encode (and document of course) your ...
    Mark W. FarnhamMark W. Farnham
    Nov 23, 2009 at 9:49 pm
    Nov 30, 2009 at 8:02 pm
  • Hi all, This one just drives me nuts.. I have a shell script that works OK while I am running it manually. It runs OK via cron up to the point where sql script should be executed: << ...
    Masha GurenichMasha Gurenich
    Nov 19, 2009 at 10:11 pm
    Nov 21, 2009 at 7:23 am
  • Anyone know what the value "boot time" is suppose to measure? -- http://www.freelists.org/webpage/oracle-l
    Ethan PostEthan Post
    Nov 13, 2009 at 3:57 pm
    Nov 14, 2009 at 5:11 pm
  • I have inherited a cluster that has the ASM home and db home in the same oracle home. I plan to move ASM to a new home and upgrade to from, on linux 64. I think the process is just ...
    John SmithJohn Smith
    Nov 28, 2009 at 4:08 pm
    Dec 9, 2009 at 3:46 pm
  • Our backups run for a 200 G database at about 2 hours with about 15 min. per backup piece. When we clone a database, we copy the backup files to the target database server and run the duplicate ...
    Jeffrey BeckstromJeffrey Beckstrom
    Nov 30, 2009 at 6:13 pm
    Dec 1, 2009 at 2:01 pm
  • I've found this to be rather handy: Logon to the MOS HTML Site: http://supporthtml.oracle.com/ Use the following URL in a new tab/window to go directly to Note ...
    Jared StillJared Still
    Nov 19, 2009 at 12:09 am
    Dec 1, 2009 at 12:27 am
  • we have ORACLE 10GR2 on Linux server. More of account on our database will sudden change to "lock". I check DB parameter "resource_limit" and it set to "false". any ideal? Thanks. -- ...
    Dba1 mccDba1 mcc
    Nov 21, 2009 at 3:48 pm
    Nov 23, 2009 at 1:17 am
  • I want to use datapump export and import as simple method of backing up schemas in our development environments. i.e. to restore the schema to a previous state, I would import back into the same ...
    John DunnJohn Dunn
    Nov 19, 2009 at 12:52 pm
    Nov 20, 2009 at 3:22 pm
  • Does anybody has any best practices followed for Database stats in 9i /10g ? Any suggestion or point that can be used like storing stats or adding monitoring clause or so that it can help in ...
    Sanjay MishraSanjay Mishra
    Nov 19, 2009 at 3:37 am
    Nov 19, 2009 at 10:15 pm
  • Hi List members Would like your help/inputs in a problem I am facing here. I want to clear out records from a huge bunch of selected tables (1000+) which have interdependencies established using FK ...
    Steven RebelloSteven Rebello
    Nov 18, 2009 at 7:30 am
    Nov 18, 2009 at 6:39 pm
  • Is it possible to create a view with the same name as a table in the same schema without harming an application? Hotmail: Trusted email with powerful SPAM protection ...
    J. DexJ. Dex
    Nov 16, 2009 at 7:45 pm
    Nov 16, 2009 at 9:33 pm
  • Sorry, I mean, other than the alter system commands, Why and when would a log switch on one instance of a RAC trigger cause log switches to happen across one or more of the other instances? From ...
    Rajesh RaoRajesh Rao
    Nov 10, 2009 at 6:33 pm
    Nov 13, 2009 at 8:55 pm
  • I didn't have any problems the past few days, but my luck seems to have run out. No access the knowledge base on MOS at all today. It works in supporthtml, though. Regards Ingrid Original-Nachricht ...
    Ingrid VoigtIngrid Voigt
    Nov 11, 2009 at 11:15 am
    Nov 12, 2009 at 4:35 pm
  • Hi list, I've got several Oracle database instances running on the same Oracle Linux 5.2 box and from the documentation and everything else I could find, it looks like ...
    Allen, BrandonAllen, Brandon
    Nov 5, 2009 at 5:57 pm
    Nov 9, 2009 at 4:56 pm
  • I have no experience with changing cpu_count, but I do have a little experience with running the Oracle database on T-series and I can sum it up in two words: “Run away!” While adjusting the ...
    Allen, BrandonAllen, Brandon
    Nov 6, 2009 at 4:31 pm
    Nov 6, 2009 at 10:01 pm
  • Forwarding due bounce on bad email address. -----Original Message----- From: Bobak, Mark Sent: Wednesday, November 04, 2009 11:11 AM To: 'Martin.Klier_at_klug-is.de'; oracle-l@ Subject: RE: No bind ...
    Bobak, MarkBobak, Mark
    Nov 4, 2009 at 4:12 pm
    Nov 6, 2009 at 3:06 am
  • All, I'm trying to tune a pagination query that uses Full Join but so far i had no luck in making it run faster. Anyone had come across similar query and got it run reasonably faster. The problem ...
    Nov 2, 2009 at 6:05 pm
    Nov 4, 2009 at 12:18 am
  • Does anyone know offhand if nodes like "n1:submit" is valid in xml. All of our xml is changing that we parse to run reports on and our tests are saying SQL select ...
    Michael McMullenMichael McMullen
    Nov 2, 2009 at 4:57 pm
    Nov 3, 2009 at 3:21 pm
  • esteemed list members I wonder if you could direct your attention away from MOS just for a few seconds. I see that Golden Gate software is now available for download from Oracle in apparently 64bit ...
    Niall LitchfieldNiall Litchfield
    Nov 17, 2009 at 9:04 am
    Nov 26, 2009 at 1:22 pm
  • Would dynamic sampling generates different stats each time if the underlying table stays static ( no ddl or dml change, no new indexes, ... nothing changes ) ? Thanks, Lei From: Kellyn Pedersen ...
    Lei ZengLei Zeng
    Nov 17, 2009 at 5:45 am
    Nov 23, 2009 at 12:54 pm
  • While troubleshooting an ORA-04030 issue, Oracle Support also took notice that we had shmmax a bit out of whack. Whether or not this would contribute to the 04030, I'll not get into right now. This ...
    Don SeilerDon Seiler
    Nov 18, 2009 at 2:56 pm
    Nov 19, 2009 at 6:39 pm
  • indeterminate. MS W2K8 Server R1 is available in both 32 and 64 bit editions. If you were to install MS W2K8 Server R1 32 bit Enterprise Edition, 8 GB would be recognized. btw, 8 GB of physical ...
    Paul DrakePaul Drake
    Nov 13, 2009 at 2:57 pm
    Nov 15, 2009 at 1:40 am
  • Hey all, I just tried the HTML MOS -- not bad, but I think I actually prefer [gulp] the Flashy version for now, if only because I couldn't get *any* information to be returned via the HTML ...
    Rich JesseRich Jesse
    Nov 12, 2009 at 4:22 pm
    Nov 12, 2009 at 7:40 pm
  • Hi Listers, We recently upgraded from to on HP-UX 11.31. We now have about 1.8 million log files generated in $ORACLE_HOME/rdbms/audit that have stuff like this in them: Audit file ...
    Nov 4, 2009 at 2:37 pm
    Nov 10, 2009 at 6:37 pm
  • All, Has anyone set up an environment where they run RMAN (hot) backups to disk and then move the backups to tape using a standard filesystem backup, then remove the older backups from disk. Does ...
    Fred TillyFred Tilly
    Nov 5, 2009 at 6:55 pm
    Nov 6, 2009 at 4:03 pm
  • http://www.oracle.com/us/corporate/press/036911 I'm just now getting where I feel good about what I can do with the current oem!! Chris Taylor Sr. Oracle DBA Ingram Barge Company Nashville, TN 37205 ...
    Taylor, Chris DavidTaylor, Chris David
    Nov 5, 2009 at 3:08 pm
    Nov 6, 2009 at 2:33 pm
  • Hi List, I've got a database that is constantly reporting sreadtim and mreadtim values under 1 millisecond according to gather_system_stats due to caching at the OS level. I've searched Metalink, the ...
    Allen, BrandonAllen, Brandon
    Nov 3, 2009 at 5:09 pm
    Nov 4, 2009 at 7:10 pm
  • Does anybody has doc or link that point to creating external resource for application which can be managed with Oracle RAC. TIA Sanjay -- http://www.freelists.org/webpage/oracle-l
    Sanjay MishraSanjay Mishra
    Nov 30, 2009 at 7:11 pm
    Nov 30, 2009 at 10:22 pm
  • Carlos Sierra's next version, SQLTXPLAIN, is even better. IMO. On Tue, Nov 24, 2009 at 14:51, Taylor, Chris David < ChrisDavid.Taylor_at_ingrambarge.com wrote: -- Charles Schultz -- ...
    Charles SchultzCharles Schultz
    Nov 24, 2009 at 8:57 pm
    Nov 27, 2009 at 11:37 am
Group Navigation
period‹ prev | Nov 2009 | next ›
Group Overview
grouporacle-l @

210 users for November 2009

Allen, Brandon: 38 posts Mark W. Farnham: 21 posts Greg Rahn: 19 posts Jared Still: 17 posts LS Cheng: 15 posts Bobak, Mark: 14 posts Niall Litchfield: 13 posts Rich Jesse: 13 posts Robert Freeman: 12 posts Sanjay Mishra: 12 posts Daniel Fink: 11 posts Howard Latham: 11 posts Kellyn Pedersen: 11 posts Yong Huang: 11 posts D'Hooge Freek: 10 posts : 9 posts Neil Kodner: 9 posts Bill Ferguson: 8 posts Guillermo Alan Bort: 8 posts Michael McMullen: 8 posts
show more