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 -> LOG_BUFFER tuning

LOG_BUFFER tuning

From: Charles J. Fisher <cfisher_at_rhadmin.org>
Date: Mon, 12 Nov 2001 17:53:13 GMT
Message-ID: <Pine.LNX.4.33.0111121147100.14832-100000@galt.rhadmin.org>


In a paper on dbatoolbox.com, Susan Georgson says that the following SQL call should always return zero, and to increase LOG_BUFFER if it isn't zero:

SELECT name, value FROM v$sysstat WHERE name='redo buffer allocation retries';

On an Oracle 7 server suffering performance problems, I've increased LOG_BUFFER to the point that I'm getting approx. 30 of these retries a day.

Is this close enough, or does the value need to be ABSOLUTELY zero?


   / Charles J. Fisher                   |"Dig within. There lies the spring /
  /  cfisher_at_rhadmin.org                 | of good: ever dig, and it will   /
 /   http://rhadmin.org:81               | ever flow."  -Marcus Aurelius   /
---------------------------------------------------------------------------
Received on Mon Nov 12 2001 - 11:53:13 CST

Original text of this message

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