Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: LOG_BUFFER tuning

Re: LOG_BUFFER tuning

From: Ricky Sanchez <rsanchez_at_more.net>
Date: Mon, 12 Nov 2001 21:41:50 GMT
Message-ID: <3BF04264.7FF44B6D@more.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US