The following is a list of the Idle Events.
ARCH random i/o
ARCH sequential i/o
KXFX: execution message dequeue - Slaves
LGWR random i/o
LGWR sequential i/o
LGWR wait for redo copy
Null event
PL/SQL lock timer
PX Deq Credit: need buffer
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: Msg Fragment
PX Deq: Par Recov Change Vector
PX Deq: Par Recov Execute
PX Deq: Par Recov Reply
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 Deque wait
PX Idle Wait
Queue Monitor Shutdown Wait
Queue Monitor Slave Wait
Queue Monitor Wait
RFS random i/o
RFS sequential i/o
RFS write
SQL*Net message from client
SQL*Net message from dblink
STREAMS apply coord waiting for slave message
STREAMS apply coord waiting for some work to finish
STREAMS apply slave idle wait
STREAMS capture process filter callback wait for ruleset
STREAMS fetch slave waiting for txns
WMON goes to sleep
async disk IO
client message
control file parallel write
control file sequential read
control file single write
db file single write
db file parallel write
dispatcher timer
gcs log flush sync
gcs remote message
ges reconfiguration to start
ges remote message
io done
jobq slave wait
lock manager wait for remote message
log file parallel write
log file sequential read
log file single write
parallel dequeue wait
parallel recovery coordinator waits for cleanup of slaves
parallel query dequeue
parallel query idle wait - Slaves
pipe get
pmon timer
queue messages
rdbms ipc message
recovery read
single-task message
slave wait
smon timer
statement suspended, wait error to be cleared
unread message
virtual circuit
virtual circuit status
wait for activate message
wait for transaction
wait for unread message on broadcast channel
wait for unread message on multiple broadcast channels
wakeup event for builder
wakeup event for preparer
wakeup event for reader
wakeup time manager
Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.