oracle 等待,oracle 所有等待事件

set linesize 200 pages 120

select 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 9

13 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.