Did you try reducing _log_io_size to less than one-third log_buffers size to make LGWR more active and less busy .. We have had some success with it..
Thanks, Ravi. --- Thomas Jeff <[EMAIL PROTECTED]> wrote: > Jonathan, > > > > WILLING > IMMEDIATE > IMMEDIATE IMMEDIATE > NAME GETS MISSES TO WAIT % > GETS > MISSES REQUEST % SLEEPS > =============== =========== ========= =========== > =========== > =========== =========== ========= > redo copy 11448 0 0 > 599170378 > 405208 .0676281764 0 > redo allocation 6809468 247548 3.635350074 > 597056922 > 17812410 2.983368812 11018 > > Thanks. > > > > > -----Original Message----- > Jonathan Lewis > Sent: Friday, January 09, 2004 3:35 PM > To: Multiple recipients of list ORACLE-L > > > > > One interpretation of increased red latch contention > and log buffer space waits is that more work is > being > done more quickly - so the log writer can't keep up. > > This could mean: > a) the log writer has slowed down > > b) the database writer(s) have speeded up, so > there > is less time lost on write complete > waits, free space > waits, and (side effect) buffer busy > waits. > > So the symptoms could be positive or negative, and > we don't have enough relevant information to say > which. Depending on the nature of the application, > and the number and duration of sync waits, you could > address the log buffer space waits by increasing the > size of the log buffer. > > Are the redo latch waits allocation latch or copy > latch ? > > > > Regards > > Jonathan Lewis > http://www.jlcomp.demon.co.uk > > The educated person is not the person > who can answer the questions, but the > person who can question the answers -- T. Schick > Jr > > > Next public appearance2: > March 2004 Hotsos Symposium - Keynote > March 2004 Charlotte NC - OUG Tutorial > April 2004 Iceland > > > One-day tutorials: > http://www.jlcomp.demon.co.uk/tutorial.html > > > Three-day seminar: > see http://www.jlcomp.demon.co.uk/seminar.html > ____UK___February > > > The Co-operative Oracle Users' FAQ > http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > > ----- Original Message ----- > > Now, the Sr DBA here is screaming about the > performance since I made the > change, in particular, he says he's seeing high redo > latch contention > and redo log buffer waits which he says validates > his contention that we > need to get back to > using DBWR_IO_SLAVES. > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Jonathan Lewis > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in the > message BODY, include a line containing: UNSUB > ORACLE-L (or the name of > mailing list you want to be removed from). You may > also send the HELP > command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Thomas Jeff > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __________________________________ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ravi Kulkarni INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
