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).
