Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> LOG_BUFFER tuning
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