Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 11.1 Wait Events

In Oracle 10.2 there were 874 wait events; in Oracle 11.1 there are 961 wait events

The following table shows the 160 wait events that were added in Oracle 11.1:

Name
AQ propagation connection
ASM file metadata operation
ASM internal hang test
ASM metadata cache frozen
ASM network foreground exits
ASM Volume Background
ASM: OFS Cluster membership update
auto-sqltune: wait graph update
Backup: sbtbufinfo
Backup: sbtgetbuf
Backup: sbtmapbuf
Backup: sbtrelbuf
blocking txn id for DDL
broadcast mesg queue transition
broadcast mesg recovery queue transition
Cluster stabilization wait
cmon timer
connection pool wait
Data Guard Broker Wait
dbverify reads
EMON slave idle wait
EMON slave messages
EMON termination
enq: AD - relocate AU
enq: AE - lock
enq: AM - ASM ACD Relocation
enq: AM - ASM cache freeze
enq: AM - background COD reservation
enq: AV - persistent DG number
enq: AY - contention
enq: BB - 2PC across RAC instances
enq: BF - PMON Join Filter cleanup
enq: BR - multi-section restore header
enq: BR - multi-section restore section
enq: BR - space info datafile hdr update
enq: CA - contention
enq: CO - master slave det
enq: CQ - contention
enq: DO - disk online
enq: DO - disk online operation
enq: DO - disk online recovery
enq: DO - Staleness Registry create
enq: DO - startup of MARK process
enq: DW - contention
enq: FE - contention
enq: FX - issue ACD Xtnt Relocation CIC
enq: JS - aq sync
enq: KQ - access ASM attribute
enq: MO - contention
enq: MX - sync storage server info
enq: OD - Serializing DDLs
enq: RC - Result Cache: Contention
enq: RE - block repair contention
enq: RF - DG Broker Current File ID
enq: RF - FSFO Observer Heartbeat
enq: RF - RF - Database Automatic Disable
enq: RR - contention
enq: RX - relocate extent
enq: SJ - Slave Task Cancel
enq: SL - escalate lock
enq: SL - get lock
enq: SL - get lock for undo
enq: SO - contention
enq: TH - metric threshold evaluation
enq: TK - Auto Task Serialization
enq: TK - Auto Task Slave Lockout
enq: TQ - DDL-INI contention
enq: WG - delete fso
enq: WG - lock fso
enq: WM - WLM Plan activation
enq: XL - fault extent map
fbar timer
gc buffer busy acquire
gc buffer busy release
gc object scan
gc quiesce
ges RMS0 retry add redo log
Global transaction acquire instance locks
Intelligent Storage OSS I/O completion
IORM Scheduler Slave Idle Wait
JOX Jit Process Sleep
kdblil wait before retrying ORA-54
kpodplck wait before retrying ORA-54
kslwait unit test event 1
kslwait unit test event 2
kslwait unit test event 3
latch: change notification client cache latch
latch: gc element
latch: lob segment dispenser latch
latch: lob segment hash table latch
latch: lob segment query latch
library cache: mutex S
library cache: mutex X
Logical Standby Apply Delay
LogMiner: builder idle
LogMiner: generic process sleep
LogMiner: preparer idle
LogMiner: reader idle
LogMiner: reader waiting for more redo
LogMiner: waiting for processes to soft detach
LogMiner: waiting for redo from new branch
LogMiner: waiting for session to become visible
logout restrictor
MRP redo arrival
Network file transfer
NFS read delegation outstanding
OLAP DML Sleep
OSD IPC library
parallel recovery change buffer free
parallel recovery control message reply
parallel recovery coord send blocked
parallel recovery coord wait for reply
parallel recovery coordinator waits for slave cleanup
parallel recovery read buffer free
parallel recovery slave idle wait
parallel recovery slave next change
parallel recovery slave wait for change
PING
pool server timer
PX Deq Credit: Session Stats
PX Deq: Signal ACK EXT
PX Deq: Signal ACK RSG
PX Deq: Slave Join Frag
PX Deq: Slave Session Stats
PX Deq: Test for credit
readable standby redo apply remastering
recovery buffer pinned
remote db file read
remote db file write
remote db operation
resmgr:I/O prioritization
securefile direct-read completion
securefile direct-write completion
Shared IO Pool IO Completion
Shared IO Pool Memory
Space Manager: slave idle wait
Space Manager: slave messages
SQL*Net vector data from client
SQL*Net vector data from dblink
SQL*Net vector data to client
SQL*Net vector data to dblink
standby query scn advance
storage device registration
Streams AQ: emn coordinator idle wait
Streams AQ: emn coordinator waiting for slave to start
Streams AQ: QueueTable kgl locks
Streams miscellaneous event
SUPLOG PL wait for inflight pragma-d PL/SQL
TEXT: URL_DATASTORE network wait
VKTM Init Wait for GSGA
VKTM Logical Idle Wait
wait for IMR CSS join retry
wait for kkpo ref-partitioning *TEST EVENT*
WCR: RAC message context busy
WCR: replay client notify
WCR: replay clock
WCR: replay lock order
WCR: Sync context busy
xdb schema cache initialization
XDB SGA initialization

The following table shows the 73 wait events that were removed in Oracle 11.1:

Name
ARCH wait for pending I/Os
Cluster stablization wait
Data Guard broker: single instance
Data Guard broker: wait upon ORA-12850 error
EMON idle wait
enq: AS - modify service
enq: KK - context
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 - synchronization: chief
enq: RF - synchronization: HC master
gc buffer busy
gc prepare
gc quiesce wait
ksqded
kst: async disk IO
latch: KCL gc element parent latch
latch: library cache
latch: library cache lock
latch: library cache pin
latch: object queue header heap
LogMiner: wakeup event for builder
LogMiner: wakeup event for preparer
LogMiner: wakeup event for reader
parallel recovery coordinator waits for cleanup of slaves
PX Deq: Par Recov Change Vector
PX Deq: Par Recov Execute
PX Deq: Par Recov Reply
PX Deq: Signal ACK
recovery area: computing identical files
RF - FSFO Wait for Ack
rfi_drcx_site_del
rfi_insv_shut
rfi_insv_start
rfi_nsv_deldef
rfi_nsv_md_close
rfi_nsv_md_write
rfi_nsv_postdef
rfi_nsv_shut
rfi_nsv_start
rfi_recon1
rfi_recon2
rfm_dmon_last_gasp
rfm_dmon_pdefer
rfm_dmon_shut
rfm_dmon_timeout_op
rfm_pmon_dso_stall
rfrdb_dbop
rfrdb_recon1
rfrdb_recon2
rfrdb_try235
rfrla_lapp1
rfrla_lapp2
rfrla_lapp3
rfrla_lapp4
rfrla_lapp5
rfrld_rhmrpwait
rfrm_dbcl
rfrm_dbop
rfrm_nonzero_sub_count
rfrm_rsm_shut
rfrm_rsm_so_attach
rfrm_rsm_start
rfrm_stall
rfrm_zero_sub_count
rfrpa_mrpdn
rfrpa_mrpup
rfrxptarcurlog
rfrxpt_pdl
wait for EMON to die