Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 10.2 Wait Events

In Oracle 10.1 there were 811 wait events; in Oracle 10.2 there are 874 wait events

The following table shows the 134 wait events that were added in Oracle 10.2:

Name
affinity expansion in replay
ASM COD rollback operation completion
AWR Flush
AWR Metric Capture
cleanup of aborted process
control file diagnostic dump
cursor: mutex S
cursor: mutex X
cursor: pin S
cursor: pin S wait on X
cursor: pin X
Data file init write
Data Guard broker: single instance
Data Guard: process clean up
Data Guard: process exit
Datapump dump file I/O
dbms_file_transfer I/O
DG Broker configuration file I/O
DIAG idle wait
EMON idle wait
enq: AM - client registration
enq: AM - rollback COD reservation
enq: AM - shutdown
enq: AS - modify service
enq: AS - service activation
enq: AU - audit index file
enq: BF - allocation contention
enq: CN - race with init
enq: CN - race with reg
enq: CN - race with txn
enq: FD - Restore point create/drop
enq: FP - global fob contention
enq: JS - evt notify
enq: JS - evtsub add
enq: JS - evtsub drop
enq: JS - sch locl enqs
enq: JS - wdw op
enq: KO - fast object checkpoint
enq: MK - contention
enq: OW - initialization
enq: OW - termination
enq: RF - RF - FSFO connectivity
enq: RF - RF - FSFO Observed
enq: RF - RF - FSFO state
enq: RF - RF - FSFO synchronization
enq: RF - RF - FSFO wait
enq: RF - synch: DG Broker metadata
enq: RU - contention
enq: RU - waiting
enq: RW - MV metadata contention
enq: SE - contention
enq: WR - contention
enq: XQ - recovery
enq: XQ - relocation
enq: ZG - contention
events in waitclass Other
FAL archive wait 1 sec for REOPEN minimum
gc cr block lost
gc current block lost
GCS lock cancel
GCS lock cvt S
GCS lock cvt X
GCS lock esc
GCS lock esc X
GCS lock open
GCS lock open S
GCS lock open X
GCS recovery lock convert
GCS recovery lock open
ges retry query node
jobq slave shutdown wait
jobq slave TJ process wait
kst: async disk IO
KSV master wait
ksxr wait for mount shared
latch: Change Notification Hash table latch
latch: Undo Hint Latch
library cache shutdown
LMON global data update
lms flush message acks
LNS ASYNC archive log
LNS ASYNC control file txn
LNS ASYNC dest activation
LNS ASYNC end of log
Log archive I/O
Log file init write
log file switch (private strand flush incomplete)
Logical Standby Apply shutdown
Logical Standby dictionary build
Logical Standby pin transaction
Logical Standby Terminal Apply
LogMiner: client waiting for transaction
LogMiner: slave waiting for activate message
LogMiner: wakeup event for builder
LogMiner: wakeup event for preparer
LogMiner: wakeup event for reader
optimizer stats update retry
os thread startup
PMON to cleanup pseudo-branches at svc stop time
prewarm transfer retry
prior spawner clean up
process terminate
RF - FSFO Wait for Ack
rfrld_rhmrpwait
RMAN backup & recovery I/O
rolling migration: cluster quiesce
set director factor wait
SGA: allocation forcing component growth
SGA: MMAN sleep for component shrink
SGA: sga_target resize
Standby redo I/O
Streams AQ: deallocate messages from Streams Pool
Streams AQ: delete acknowledged messages
Streams AQ: enqueue blocked due to flow control
Streams AQ: enqueue blocked on low memory
Streams AQ: qmn coordinator idle wait
Streams AQ: qmn coordinator waiting for slave to start
Streams AQ: qmn slave idle wait
Streams AQ: RAC qmn coordinator idle wait
Streams AQ: waiting for busy instance for instance_name
Streams AQ: waiting for messages in the queue
Streams AQ: waiting for time management or cleanup tasks
Streams capture: filter callback waiting for ruleset
Streams capture: resolve low memory condition
Streams capture: waiting for archive log
Streams capture: waiting for database startup
Streams capture: waiting for subscribers to catch up
Streams fetch slave: waiting for txns
Streams: apply reader waiting for DDL to apply
Streams: RAC waiting for inter instance ack
TCP Socket (KGAS)
tsm with timeout
undo_retention publish retry
watchdog main loop

The following table shows the 71 wait events that were removed in Oracle 10.2:

Name
AQ Deallocate Wait
AQ Proxy Cleanup Wait
contacting SCN server or SCN lock master
DIAG dummy wait
DLM lock cancel
DLM lock cvt S
DLM lock cvt X
DLM lock esc
DLM lock esc X
DLM lock open
DLM lock open S
DLM lock open X
DLM recovery lock convert
DLM recovery lock open
enq: AS - contention
enq: JS - coord post lock
enq: JS - coord rcv lock
enq: JS - global wdw lock
enq: JS - job chain evaluate lock
enq: JS - running job cnt lock
enq: JS - running job cnt lock2
enq: JS - running job cnt lock3
enq: JS - slave enq get lock1
enq: JS - slave enq get lock2
enq: RF - synch: per-SGA Broker metadata
Flow Control Event
foreground creation: start
foreground creation: wait
knlqdeq
knlWaitForStartup
ksfd: fib/fob latch
latch: latch wait list
master wait
queue messages
Queue Monitor IPC wait
Queue Monitor Shutdown Wait
Queue Monitor Slave Wait
Queue Monitor Task Wait
Queue Monitor Wait
refresh controlfile command
rfc_open_retry
slave shutdown wait
slave TJ process wait
STREAMS apply coord waiting for slave message
STREAMS apply slave idle wait
STREAMS apply slave waiting for coord message
STREAMS capture process filter callback wait for ruleset
STREAMS capture process waiting for archive log
STREAMS fetch slave waiting for txns
Streams: Wait for inter instance ack
Streams: Wating for DDL to apply
SWRF RWM Auto Capture Event
SWRF Wait on Flushing
trace continue
trace unfreeze
trace writer flush
trace writer I/O
wait for activate message
Wait for Dictionary Build to lock all tables
wait for Logical Standby Apply shutdown
wait for resize request completion
wait for SGA component shrink
wait for sga_target resize
wait for transaction
waiting for low memory condition to be resolved
waiting for subscribers to catch up
wakeup blocked enqueuers
wakeup event for builder
wakeup event for preparer
wakeup event for reader
wakeup time manager