数据库巡检模板.xls

项目名称:中国人寿项目山东分公司巡检日期:2009-09-09操作人员:类别oracle10gSQL数据库版本select*fromv$version;ALERT文件(alertSID.log)是否出现错误信息查看alert文件位置
conn/assysdba
SQL>showparameterbackground_dump_dest
找到文件后，查看最近一周是否出现错误信息。文件系统利用率系统用户登陆：df-k归档方式及备份情况SQL>archiveloglist;
并说明该数据库备份情况，是否有备份策略。top10等待事件selectt2.event,round(100*t2.time_waited/(t1.w1+t3.cpu),2)event_wait_percentfrom(
SELECTSUM(time_waited)w1FROMv$system_eventWHEREeventNOTIN
('smontimer','pmontimer','rdbmsipcmessage','Nullevent','parallelquerydequeue','pipeget','clientmessage','SQL*Netmessagetoclient','SQL*Netmessagefromclient','SQL*Netmoredatafromclient','dispatchertimer','virtualcircuitstatus','lockmanagerwaitforremotemessage','PXIdleWait','PXDeq:ExecutionMsg','PXDeq:TableQNormal','wakeuptimemanager','slavewait',
'i/oslavewait','jobqslavewait','nullevent','gcsremotemessage','gcsforaction','gesremotemessage','queuemessages','waitforunreadmessageonbroadcastchannel','PXDeqCredit:sendblkd','PXDeq:ExecuteReply','PXDeq:SignalACK','PXDequewait','PXDeqCredit:needbuffer','STREAMSapplycoordwaitingforslavemessage',
'STREAMSapplyslavewaitingforcoordmessage','QueueMonitorWait','QueueMonitorSlaveWait','wakeupeventforbuilder','wakeupeventforpreparer','wakeupeventforreader',
'waitforactivatemessage','PXDeq:ParRecovExecute','PXDeq:TableQSample','STREAMSapplyslaveidlewait','STREAcaptureprocessfiltercallbackwaitforruleset','STREAMSfetchslavewaitingfortxns',
'STREAMSwaitingforsubscriberstocatchup','QueueMonitorShutdownWait','AQProxyCleanupWait','knlqdeq','classslavewait','masterwait','DIAGidlewait',
'ASMbackgroundtimer','KSVmasterwait','EMONidlewait','StreamsAQ:RACqmncoordinatoridlewait','StreamsAQ:qmncoordinatoridlewait','StreamsAQ:qmnslaveidlewait',
'StreamsAQ:waitingfortimemanagementorcleanuptasks','StreamsAQ:waitingformessagesinthequeue','Streamsfetchslave:waitingfortxns','StreamsAQ:deallocatemessagesfromStreamsPool',
'StreamsAQ:deleteacknowledgedmessages','LNSASYNCarchivelog','LNSASYNCdestactivation','LNSASYNCendoflog','LogMiner:clientwaitingfortransac