<script type="text/javascript">
</script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
TtitleOff
prompt++++++++++++++++++++++++++++++++++Item++++++++++++++++++++++++++++++++++
prompt+3.0LogSwitchIntheLastDay +
prompt++++++++++++++++++++++++++++++++++Item++++++++++++++++++++++++++++++++++
prompt
TTitleleft"***Database:"xdbname",HowOffentheLogSwitch(Asof:"xdate")***"skip1
columnarchive_nameformatA40
column"Time"formatA25
selectto_char(TO_DATE(Time,'MM/DD/RRHH24:MI:SS'),'DD-MON-RRRRHH24:MI:SS')"Time",
ARCHIVE_NAME
fromv$log_history
whereTO_DATE(Time,'MM/DD/RRHH24:MI:SS')>sysdate-1
orderbyTO_DATE(Time,'MM/DD/RRHH24:MI:SS')desc;
prompt
prompt<<<<<<<<<<<<<<<<<<<NOTE:>>>>>>>>>>>>>>>>>>>>>>
prompt3.0Invesigation
promptStandard:
promptDuringperiodsofhighactivity,logswitchesareoccurringevery20minutes
prompt<<<<<<<<<<<<<<<<<<<NOTE:>>>>>>>>>>>>>>>>>>>>>>
prompt
ttitleoff
prompt
prompt++++++++++++++++++++++++++++++++++Item++++++++++++++++++++++++++++++++++
prompt+3.1LogBuffer -redologspacerequests:TheValue +
prompt+shouldberelativesmallpromptServeriswaitingfor +
prompt+diskspacetobeallocateforredologentries +
prompt+Spaceiscreatedbyperformingalogswitch +
prompt++++++++++++++++++++++++++++++++++Item++++++++++++++++++++++++++++++++++
prompt
ttitleleft"***LogBuffers-redologspacerequests***"Skip1
selectsubstr(name,1,25)"LogBuffers",
substr(value,1,15)"VALUE(Near0?)"
fromv$sysstat
wherename='redologspacerequests'
/
prompt
prompt<<<<<<<<<<<<<<<<<<<NOTE:>>>>>>>>>>>>>>>>>>>>>>
prompt3.1Investigation
promptIfthevalueisnotnear0,increaseLOGBUFFER.
prompt<<<<<<<<<<<<<<<<<<<NOTE:>>>>>>>>>>>>>>>>>>>>>>
prompt
ttitleoff 1 <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
TtitleOff
prompt++++++++++++++++++++++++++++++++++Item++++++++++++++++++++++++++++++++++
prompt+3.0LogSwitchIntheLastDay +
prompt++++++++++++++++++++++++++++++++++Item++++++++++++++++++++++++++++++++++
prompt
TTitleleft"***Database:"xdbname",HowOffentheLogSwitch(Asof:"xdate")***"skip1
columnarchive_nameformatA40
column"Time"formatA25
selectto_char(TO_DATE(Time,'MM/DD/RRHH24:MI:SS'),'DD-MON-RRRRHH24:MI:SS')"Time",
ARCHIVE_NAME
fromv$log_history
whereTO_DATE(Time,'MM/DD/RRHH24:MI:SS')>sysdate-1
orderbyTO_DATE(Time,'MM/DD/RRHH24:MI:SS')desc;
prompt
prompt<<<<<<<<<<<<<<<<<<<NOTE:>>>>>>>>>>>>>>>>>>>>>>
prompt3.0Invesigation
promptStandard:
promptDuringperiodsofhighactivity,logswitchesareoccurringevery20minutes
prompt<<<<<<<<<<<<<<<<<<<NOTE:>>>>>>>>>>>>>>>>>>>>>>
prompt
ttitleoff
prompt
prompt++++++++++++++++++++++++++++++++++Item++++++++++++++++++++++++++++++++++
prompt+3.1LogBuffer -redologspacerequests:TheValue +
prompt+shouldberelativesmallpromptServeriswaitingfor +
prompt+diskspacetobeallocateforredologentries +
prompt+Spaceiscreatedbyperformingalogswitch +
prompt++++++++++++++++++++++++++++++++++Item++++++++++++++++++++++++++++++++++
prompt
ttitleleft"***LogBuffers-redologspacerequests***"Skip1
selectsubstr(name,1,25)"LogBuffers",
substr(value,1,15)"VALUE(Near0?)"
fromv$sysstat
wherename='redologspacerequests'
/
prompt
prompt<<<<<<<<<<<<<<<<<<<NOTE:>>>>>>>>>>>>>>>>>>>>>>
prompt3.1Investigation
promptIfthevalueisnotnear0,increaseLOGBUFFER.
prompt<<<<<<<<<<<<<<<<<<<NOTE:>>>>>>>>>>>>>>>>>>>>>>
prompt
ttitleoff 1 <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>