I remember seeing documentation on it for 8i as well.
--- Pete Sharman <[EMAIL PROTECTED]> wrote: > Really? I thought that condition was there pre-9i as well. Maybe > I'm > mistaken. > > Pete > "Controlling developers is like herding cats." > Kevin Loney, Oracle DBA Handbook > "Oh no, it's not. It's much harder than that!" > Bruce Pihlamae, long-term Oracle DBA > > > > -----Original Message----- > WILLIAMS > Sent: Friday, March 14, 2003 8:19 AM > To: Multiple recipients of list ORACLE-L > > > Add one more condition: > New in Oracle 9i, it will write when 1 meg is reached, so the 1/3 > criteria is never reached if you use a big buffer. > > Dennis Williams > DBA, 40%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Friday, March 14, 2003 8:59 AM > To: Multiple recipients of list ORACLE-L > > > KG, > > Thanks for the response. Just for my curiosity, is it documented > somewhere that the log buffer if flushed when 2/3rd full? From the > Manual /server.920/a96524/c09procs.htm#3158 (please check the URL in > OTN, the first part is not complete), here is an excerpt > > <MANUAL> > LGWR writes one contiguous portion of the buffer to disk. LGWR > writes: > a.. A commit record when a user process commits a transaction > b.. Redo log buffers > a.. Every three seconds > b.. When the redo log buffer is one-third full > c.. When a DBWn process writes modified buffers to disk, if > necessary > > </MANUAL> > > At least this was the behavior I tested in 8.1.7; although I have not > tested in 9i. This has also been stated by several Oracle Support > Analysts. > > Thanks. > > Arup Nanda > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, March 14, 2003 7:32 AM > > > > Arup: > > > > <NO FLAMES> > > The second condition is not quite true. It is 2/3 full in the > current > > versions. </NO FLAMES> > > > > It is very easy to test with the event 10046^8. > > > > KG > > > > > > --- Arup Nanda <[EMAIL PROTECTED]> wrote: > > > AK, > > > > > > If the log buffer is at least 4MB, then increasing it will not > help, > > > > rather it may hurt. The log buffer is flushed when any of the the > > > > follwoing occur > > > (i) 1 MB is filled up > > > (2) 1/3rd is filled up > > > (3) every 3 seconds > > > (4) when a checkpoint occurs > > > (5) when a commit occurs. > > > > > > Therefore, see if any of these could be the problem. It's easy to > > > > check #s 4 and 3. > > > > > > As Kirti suggested, the problem could be due to the redo logs > being > > > on a busy disk, or even a slow one. > > > > > > HTH. > > > > > > Arup > > > ----- Original Message ----- > > > From: Deshpande, Kirti > > > To: Multiple recipients of list ORACLE-L > > > Sent: Thursday, March 13, 2003 8:13 PM > > > Subject: RE: log buffer space > > > > > > > > > Increasing log_buffer size is an option, if it is really small. > > > I would also check if the redo logs are on a busy disk. If so, > try > > > > moving those (or other busy data files on the same disk) to other > > > > not-so-busy disks. > > > > > > - Kirti > > > > > > ===== > > Have a nice day !! > > ------------------------------------------------------------ > > Best Regards, > > K Gopalakrishnan, > > Bangalore, INDIA. > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: K Gopalakrishnan > > 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: Arup Nanda > 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: DENNIS WILLIAMS > 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: Pete Sharman > 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! Web Hosting - establish your business online http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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).
