|
Ttitle Off
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt + 3.0 Log Switch In the Last Day +
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt
TTitle left "*** Database: "xdbname", How Offen the Log Switch(As of : "xdate" ) ***" skip 1
column archive_name format A40
column "Time" format A25
select to_char(TO_DATE(Time,'MM/DD/RR HH24:MI:SS'),'DD-MON-RRRR HH24:MI:SS') "Time",
ARCHIVE_NAME
from v$log_history
where TO_DATE(Time,'MM/DD/RR HH24:MI:SS') > sysdate - 1
order by TO_DATE(Time,'MM/DD/RR HH24:MI:SS') desc ;
prompt
prompt <<<<<<<<<<<<<<<<<<< NOTE: >>>>>>>>>>>>>>>>>>>>>>
prompt 3.0 Invesigation
prompt Standard:
prompt During periods of high activity , log switches are occurring every 20 minutes
prompt <<<<<<<<<<<<<<<<<<< NOTE: >>>>>>>>>>>>>>>>>>>>>>
prompt
ttitle off
prompt
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt + 3.1 Log Buffer - redo log space requests : The Value +
prompt + should be relative small prompt Server is waiting for +
prompt + disk space to be allocate for redo log entries +
prompt + Space is created by performing a log switch +
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt
ttitle left "*** Log Buffers - redo log space requests ***" Skip 1
select substr(name,1,25) "Log Buffers",
substr(value,1,15) "VALUE (Near 0?)"
from v$sysstat
where name = 'redo log space requests'
/
prompt
prompt <<<<<<<<<<<<<<<<<<< NOTE: >>>>>>>>>>>>>>>>>>>>>>
prompt 3.1 Investigation
prompt If the value is not near 0 , increase LOG BUFFER.
prompt <<<<<<<<<<<<<<<<<<< NOTE: >>>>>>>>>>>>>>>>>>>>>>
prompt
ttitle off
prompt
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt + 3.2 Log Buffer - log buffer space +
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt
ttitle left "*** Log Buffers - Log Buffer Space Waits***" Skip 1
select sid , event , seconds_in_wait , state
from v$session_wait
where event = 'log buffer space'
/
prompt
prompt <<<<<<<<<<<<<<<<<<< NOTE: >>>>>>>>>>>>>>>>>>>>>> [1] [2] [3] [4] 下一页 | 
