oracle 所有等待事件
来源:互联网 发布:java访问修饰符 案例 编辑:程序博客网 时间:2024/05/22 12:48
set linesize 200 pages 120select wait_class#,wait_class_id,wait_class,count(*) as "count" from v$event_name group by wait_class#,wait_class_id,wait_class order by wait_class#;WAIT_CLASS# WAIT_CLASS_ID WAIT_CLASS count----------- ------------- ---------------------------------------------------------------- ---------- 0 1893977003 Other 745 1 4217450380 Application 17 2 3290255840 Configuration 24 3 4166625743 Administrative 55 4 3875070507 Concurrency 33 5 3386400367 Commit 2 6 2723168908 Idle 95 7 2000153315 Network 35 8 1740759767 User I/O 48 9 4108307767 System I/O 31 10 2396326234 Scheduler 8 11 3871361733 Cluster 50 12 644977587 Queueing 913 rows selected. select * from v$event_name where wait_class='Idle' order by name;NAME ----------------------------------------------------------------ASM background timer DIAG idle wait EMON slave idle wait GCR sleep HS message to agent IORM Scheduler Slave Idle Wait JOX Jit Process Sleep JS external job KSV master wait LGWR real time apply sync LNS ASYNC archive log LNS ASYNC dest activation LNS ASYNC end of log LogMiner builder: branch LogMiner builder: idle LogMiner client: transaction LogMiner preparer: idle LogMiner reader: log (idle) LogMiner reader: redo (idle) LogMiner: activate LogMiner: find session LogMiner: internal LogMiner: other LogMiner: reset Logical Standby Apply Delay MRP redo arrival PING PL/SQL lock timer PX Deq Credit: need buffer PX Deq Credit: send blkd PX Deq: Execute Reply PX Deq: Execution Msg PX Deq: Index Merge Close PX Deq: Index Merge Execute PX Deq: Index Merge Reply PX Deq: Join ACK PX Deq: Metadata Update PX Deq: Msg Fragment PX Deq: Parse Reply PX Deq: Table Q Normal PX Deq: Table Q Sample PX Deq: Txn Recovery Reply PX Deq: Txn Recovery Start PX Deq: kdcph_mai PX Deq: kdcphc_ack PX Deque wait PX Idle Wait SGA: MMAN sleep for component shrink SQL*Net message from client SQL*Net vector message from client SQL*Net vector message from dblink Space Manager: slave idle wait Streams AQ: RAC qmn coordinator idle wait Streams AQ: deallocate messages from Streams Pool Streams AQ: delete acknowledged messages Streams AQ: emn coordinator idle wait Streams AQ: qmn coordinator idle wait Streams AQ: qmn slave idle wait Streams AQ: waiting for messages in the queue Streams AQ: waiting for time management or cleanup tasks Streams capture: waiting for archive log Streams fetch slave: waiting for txns Streams: waiting for messages VKRM Idle VKTM Init Wait for GSGA VKTM Logical Idle Wait WCR: replay client notify WCR: replay clock WCR: replay paused auto-sqltune: wait graph update cell worker idle class slave wait cmon timer dispatcher timer fbar timer gcs remote message ges remote message heartbeat monitor sleep i/o slave wait jobq slave wait parallel recovery control message reply parallel recovery coordinator waits for slave cleanup parallel recovery slave idle wait parallel recovery slave next change pipe get pmon timer pool server timer rdbms ipc message shared server idle wait simulated log write delay single-task message smon timer wait for unread message on broadcast channel wait for unread message on multiple broadcast channels watchdog main loop 95 rows selected.