Re: log buffer space

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

  -----Original Message-----
  From: oramagic_at_hotmail.com [mailto:oramagic_at_hotmail.com]   Sent: Thursday, March 13, 2003 4:49 PM   To: Multiple recipients of list ORACLE-L   Subject: log buffer space

    I am finding tons of "log buffer space" waits in 10046 output . Does it necessarily means I should look for resizing log_buffer ? What else can be done or looked at to reduce these waits .

    Thanks,
    ak

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: orarup_at_hotmail.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).