Dec 19, 2007

log_buffer

Consider increasing the log_buffer database parameter if the following two system statistics are noticably abover zero.

SELECT name, value from SYS.v_$sysstat
WHERE NAME in
('redo buffer allocation retries','redo log space wait time');

These statistics are cumulative since database startup.