Oracle log_buffer parameter

Oracle performance consideration(10g) b14211.pdf
-

Log Buffer Statistics
SELECT NAME, VALUE
FROM V$SYSSTAT
WHERE NAME = 'redo buffer allocation retries';
應該接近0 ，太大表示正在checkpoint or log buffer 太小。
initialization parameter LOG_BUFFER.

system event waited
select event  , time_waited from v$system_event  where rownum < 11 order by time_waited desc ;