项目名称:中国人寿项目山东分公司巡检日期:2009-09-09操作人员:类别oracle10gSQL数据库版本select*fromv$version;ALERT文件(alertSID.log)是否出现错误信息查看alert文件位置conn/assysdbaSQL>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