系統(tǒng)健康檢查服務(wù)方案

系統(tǒng)健康檢查服務(wù)方案系統(tǒng)健康檢查服務(wù)方案#/18fromv$latchl,v$latchnameInwherein('cachebuffersIruchain')and#=#;6、排序命中率：select"Sort(Disk)","Sort(Memory)”,round(100*decode(+,0,1,+)),2)"%Ratio(STAYUNDER5%)”fromv$sysstata,v$sysstatbwhere='sorts(disk)'and='sorts(memory)';7、數(shù)據(jù)緩沖區(qū)命中率：selectround((1-+))*100,1)ll'%'ratiofromv$sysstatphy,v$sysstatcur,v$sysstatconwhere='physicalreads'and='dbblockgets'and='consistentgets';8、v$session_wait：selectsid,seq#,event,WAIT_TIME,SECONDS_IN_WAITfromv$session_waitwhereeventnotlike'SQL%'andeventnotlike'rdbms%';9、回滾段的爭用狀況：selectname,waits,gets,waits/gets"Ratio"fromv$rollstata,v$rollnamebwhere=;10、無效對象狀況：colOBJECT_NAMEfora36SELECTobject_name,object_type,statusFROMdba_objectsWHEREstatuslike'INVALID';客戶署名:工程師署名:日期： 檢查項(xiàng)目使用的命令及有關(guān)目錄內(nèi)容及其說明alert文件alertXXX在sqlplus命令行狀態(tài)下，檢查日記文件，此中XXX是只alert文件名數(shù)據(jù)庫名SQL>showparameterdb_name顯示數(shù)據(jù)庫名實(shí)例名SQL>showparameterinstance_name顯示數(shù)據(jù)庫實(shí)例名版本SQL>select*fromv$version;顯示數(shù)據(jù)庫版本歸檔設(shè)置SQL>archiveloglist顯示歸檔設(shè)置，狀況安裝組件SQL>select*fromv$option;顯示已安裝的組件初始化參數(shù)SQL>showparameters顯示初始化參數(shù)SGASQL>showsga顯示SGA的設(shè)置，狀態(tài)用戶SQL>selectusername,account_status,default_tablespace,temporary_tablespace,createdfromdba_users用戶檢查權(quán)限SQL>select*fromdba_role_privs;檢查用戶的權(quán)限設(shè)置無效對象SQL>selectowner，object_name,object_typefromdba_objectswherestatus=‘INVALID檢查能否有無效對象控制文件SQL>select*fromv$controlfile檢查控制文件連機(jī)日志SQL>select*fromv$logfile;檢查數(shù)據(jù)庫的連結(jié)日記數(shù)據(jù)文件SQL>select*fromv$datafile;檢查數(shù)據(jù)文件回滾段SQL>SELECTSEGMENT_NAME,OWNER,TABLES查3E_NAME,SEGMENT_ID,FILE_ID,STATUSFROMDBA_ROLLBACK_SE(>PAC察現(xiàn)有回滾段及其狀態(tài)GS;SessionselectSESSIONS_CURRENT,SESSIONS_HIGHWATERfrom系統(tǒng)Session使用狀態(tài)字符集v$license;selectuserenv('language')fromdual;select字符集共享池命中率數(shù)據(jù)字典命中率round((sum(gets)-sum(reloads))/sum(gets)*100,1)"libiarycachehitratio%"fromv$librarycachewherenamespacein('SQLAREA','TABLE/PROCEDURE','BODY','TRIGGER');selectround((1-sum(getmisses)/sum(gets))*100,1)"datadictionaryhitratio%"fromv$rowcache;select數(shù)據(jù)緩沖區(qū)命中率round((1-+))*100,1)||'%'ratiofromv$sysstatphy,v$sysstatcur,v$sysstatconwhere='physicalreadsand='dbblockgets'and='consistentgets';SELECTlpad('',DECODE(request,0,0,1))||sidsess,id1,id2,lmode,request,typeFROMV$LOCKWHEREid1IN(SELECTid1FROMV$LOCKWHERElmode=0)ORDERBYid1,request;selectwaitssid,seq#,event,WAIT_TIME,SECONDS_IN_WAITfromv$session_waitwhereeventnotlike'SQL%'andeventnotlike'rdbms%';播出部數(shù)據(jù)庫系統(tǒng)配置信息硬件配置機(jī)器名DBM01DBS02廠商及型號SUNv480SUNv480’操作系統(tǒng)SunOSSunOS操作系統(tǒng)版本Solaris9Solaris9內(nèi)存4GB4GBCPU數(shù)目22磁盤容量當(dāng)?shù)乇P陣73GB219GB73GB219GB能否使用了裸設(shè)施（Yes/No）是是RAID方式RAID5+1RAID5+1Oracle實(shí)例數(shù)11［RAC］節(jié)點(diǎn)數(shù)22[RAC]每節(jié)點(diǎn)CPU22數(shù)據(jù)庫配置實(shí)例名GDTV1GDTV2服務(wù)器名DBSERVER1DBSERVER2用途（oltp,dss，b