Re: log buffer space

[Arup Nanda]

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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