oracle性能巡检.docVIP

--êy?Y?a?2?ì?òD??üó??ˉ·?·¨?÷òì￡?μ?ê×òaμ?ê?òa·￠??êy?Y?aD??ü???±￡??μí3×?′?μ?statspack,?òawrì?o?ê±￡? --ò???ê?±?è?3￡ó?μ?·?·¨￡?12?í?? --1?￠2é?ˉêy?Y?aμè′yê??ttop10,1?×￠?°?°????μè′yê??t￡?1?×￠?°èy??μè′yê??tê?·?óDòò1??ò1?áa1??μ --oracle 9i select t2.event,round(100*t2.time_waited/(t1.w1+t3.cpu),2) event_wait_percent from ( SELECT SUM(time_waited) w1 FROM v$system_event WHERE event NOT IN (smon timer,pmon timer,rdbms ipc message,Null event,parallel query dequeue,pipe get, client message,SQL*Net message to client,SQL*Net message from client,SQL*Net more data from client, dispatcher timer,virtual circuit status,lock manager wait for remote message,PX Idle Wait, PX Deq: Execution Msg,PX Deq: Table Q Normal,wakeup time manager,slave wait,i/o slave wait, jobq slave wait,null event,gcs remote message,gcs for action,ges remote message,queue messages) ) t1, (select * from ( select t.event,t.total_waits,t.total_timeouts,t.time_waited,t.average_wait,rownum num from (select event,total_waits,total_timeouts,time_waited,average_wait from v$system_event where event not in (smon timer,pmon timer,rdbms ipc message,Null event,parallel query dequeue,pipe get, client message,SQL*Net message to client,SQL*Net message from client,SQL*Net more data from client, dispatcher timer,virtual circuit status,lock manager wait for remote message,PX Idle Wait, PX Deq: Execution Msg,PX Deq: Table Q Normal,wakeup time manager,slave wait,i/o slave wait, jobq slave wait,null event,gcs remote message,gcs for action,ges remote message,queue messages) order by time_waited desc ) t) where num11) t2, (SELECT VALUE CPU FROM v$sysstat WHERE NAME LIKE CPU used by this session ) t3 --oracle10g select t2.event,round(100*t2.time_waited/(t1.w1+t3.cpu),2) event_wait_percent from ( SELECT SUM(time_waited) w1 FROM v$system_event WHERE event NOT IN (smon timer,pmon timer,rdbms ipc message,Null event,parallel query dequeue,pipe get,client message,SQL*Net message to client,SQL*Net message from client,SQL*Net more dat