Re: log buffer space

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Fri, 14 Mar 2003 04:32:09 -0800
Message-ID: <F001.0056A045.20030314043209@fatcity.com>

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 <orarup_at_hotmail.com> 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: kaygopal_at_yahoo.com

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: ListGuru_at_fatcity.com (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).

Received on Fri Mar 14 2003 - 06:32:09 CST