Re: log_buffer sizing

From: <sjaffarhussain_at_gmail.com>
Date: 27 May 2006 02:39:33 -0700
Message-ID: <1148722773.256526.176590@38g2000cwa.googlegroups.com>

I generally like to keep the log_bufers size between 3 - 5M. If you have a big log buffer, you will have log file sync issues as well.
Start with the optimal value and if you see any waits on redo buffer request, you may want to increase the size.

Jaffar

sushil wrote:
> Is there any calculation as such for sizing a log buffer
> parameter?Howdo i know the optimal value of log_buffer parameter for my
> database.I am getting average redo log write times very high wil log
> file sync waits.
Received on Sat May 27 2006 - 04:39:33 CDT