实用的检查程序(2)

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></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

ttitleoff1<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>