Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: LOG_BUFFER tuning
Well put. In addition, since lgwr gets posted at the earlier of 1) log
buffer is 1/3 full or 2) log buffer has 1 meg to write, then there is no
real point to having a log buffer greater than 3 meg under any
circumstances.
Andrew Mobbs wrote:
>
>
> Run a utlbstat/utlestat report and see if, "redo buffer allocation
> retries" are a significant proportion of the total wait. Ask yourself
> how much faster the database would be if they never happened. You'll
> probably find that the answer is "not very", and you can get to work on
> the top wait events instead.
>
> --
> Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/
Received on Mon Nov 12 2001 - 15:41:50 CST