星期四, 12月 01, 2011

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 ;

沒有留言:

LinkWithin-相關文件

Related Posts Plugin for WordPress, Blogger...