|
prompt 3.2 Invesigation
prompt There should be no log buffer space waits
prompt Making the log buffer bigger if it is small
prompt Moving the log files to faster disks such as striped disks
prompt <<<<<<<<<<<<<<<<<<< NOTE: >>>>>>>>>>>>>>>>>>>>>>
prompt
ttitle off
prompt
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt + 3.3 Log Buffer - Redo Buffer Allocation Retries +
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt
ttitle left "*** Log Buffers - Redo Buffer Allocation Retries ***" Skip 1
column name print
select name , value
from v$sysstat
where name in ('redo buffer allocation retries','redo entries')
/
prompt
prompt <<<<<<<<<<<<<<<<<<< NOTE: >>>>>>>>>>>>>>>>>>>>>>
prompt 3.3 Investigation
prompt Redo Buffer Allocation Retries should be near 0
prompt the number should be less than 1% of Redo Entries
prompt Increase the size of the redo log buffer (LOG BUFFER)
prompt improve the checkpointing or archiving process
prompt <<<<<<<<<<<<<<<<<<< NOTE: >>>>>>>>>>>>>>>>>>>>>>
prompt
ttitle off
prompt
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt + 3.4 Log Buffer - Log File Switch Completion +
prompt + Identify the log file switch waits because of log switches +
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt
ttitle left "*** Log Buffers - Log File Swith Completion***" Skip 1
select event , total_waits,time_waited,average_wait
from v$system_event
where event like 'log file switch completion%'
/
prompt
prompt <<<<<<<<<<<<<<<<<<< NOTE: >>>>>>>>>>>>>>>>>>>>>>
prompt 3.4 Investigation
prompt Increase the size of the redo log files
prompt <<<<<<<<<<<<<<<<<<< NOTE: >>>>>>>>>>>>>>>>>>>>>>
prompt
ttitle off
prompt
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt + 3.5 Log Buffer - CHECKPOINT Incomplete +
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt
ttitle left "*** Log Buffers - CheckPoint Incompletion***" Skip 1
select event , total_waits,time_waited,average_wait
from v$system_event
where event like 'log file switch (check%'
or event like 'log file switch (arch%'
/
prompt
prompt <<<<<<<<<<<<<<<<<<< NOTE: >>>>>>>>>>>>>>>>>>>>>>
prompt 3.5 Investigation
prompt check the frequence of check points and set the a 上一页 [1] [2] [3] [4] 下一页
没有相关教程
| 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
