Call (800) 766-1884 for Oracle support & training
Free Oracle Tips


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 

HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

 

Oracle10g Wait Event List

 

Name Wait Class P1 P2 P3
alter rbs offline Administrative      
alter system set dispatcher Administrative waited    
AQ Deallocate Wait Configuration      
AQ Proxy Cleanup Wait Idle      
ARCH random i/o System I/O      
ARCH sequential i/o System I/O      
ARCH wait for archivelog lock Other      
ARCH wait for flow-control Network      
ARCH wait for net re-connect Network      
ARCH wait for netserver detach Network      
ARCH wait for netserver init 1 Network      
ARCH wait for netserver init 2 Network      
ARCH wait for netserver start Network      
ARCH wait for pending I/Os System I/O      
ARCH wait for process death 1 Other      
ARCH wait for process death 2 Other      
ARCH wait for process death 3 Other      
ARCH wait for process death 4 Other      
ARCH wait for process death 5 Other      
ARCH wait for process start 1 Other      
ARCH wait for process start 2 Other      
ARCH wait for process start 3 Other      
ARCH wait for process start 4 Other      
ARCH wait on ATTACH Network      
ARCH wait on c/f tx acquire 1 Other      
ARCH wait on c/f tx acquire 2 Other      
ARCH wait on DETACH Network      
ARCH wait on SENDREQ Network      
ASM background running Other      
ASM background starting Other      
ASM background timer Idle      
ASM db client exists Other      
ASM mount : wait for heartbeat Administrative      
ASM PST query : wait for [PM][grp][0] grant Cluster      
Backup: sbtbackup Administrative      
Backup: sbtclose Administrative      
Backup: sbtclose2 Administrative      
Backup: sbtcommand Administrative      
Backup: sbtend Administrative      
Backup: sbterror Administrative      
Backup: sbtinfo Administrative      
Backup: sbtinfo2 Administrative      
Backup: sbtinit Administrative      
Backup: sbtinit2 Administrative      
Backup: sbtopen Administrative      
Backup: sbtpcbackup Administrative      
Backup: sbtpccancel Administrative      
Backup: sbtpccommit Administrative      
Backup: sbtpcend Administrative      
Backup: sbtpcquerybackup Administrative      
Backup: sbtpcqueryrestore Administrative      
Backup: sbtpcrestore Administrative      
Backup: sbtpcstart Administrative      
Backup: sbtpcstatus Administrative      
Backup: sbtpcvalidate Administrative      
Backup: sbtread Administrative      
Backup: sbtread2 Administrative      
Backup: sbtremove Administrative      
Backup: sbtremove2 Administrative      
Backup: sbtrestore Administrative      
Backup: sbtwrite Administrative      
Backup: sbtwrite2 Administrative      
BFILE check if exists Other      
BFILE check if open Other      
BFILE closure Other      
BFILE get length Other      
BFILE get name object Other      
BFILE get path object Other      
BFILE internal seek Other      
BFILE open Other      
BFILE read User I/O      
block change tracking buffer space Other      
buffer busy Other group# obj# block#
buffer busy waits Concurrency file# block# class#
buffer deadlock Other dba class*10+mode flag
buffer dirty disabled Other group#    
buffer exterminate Other file# block# buf_ptr
buffer freelistbusy Other group# obj# block#
buffer invalidation wait Other group# obj# block#
buffer latch Other latch addr chain#  
buffer pool resize Administrative buffer pool id current size new size
buffer read retry User I/O file# block#  
buffer rememberlist busy Other group# obj# block#
buffer resize Other      
buffer write wait Other group# obj# block#
buffer writeList full Other group# obj# block#
CGS skgxn join retry Other retry count    
CGS wait for IPC msg Other      
change tracking file parallel write Other blocks requests  
change tracking file synchronous read Other block# blocks  
change tracking file synchronous write Other block# blocks  
check CPU wait times Other      
checkpoint advanced Other group#    
checkpoint completed Configuration      
class slave wait Other slave id    
Cluster stablization wait Other      
Cluster Suspension wait Other      
contacting SCN server or SCN lock master Cluster      
control file heartbeat Other      
control file parallel write System I/O files block# requests
control file sequential read System I/O file# block# blocks
control file single write System I/O file# block# blocks
cr request retry Other file# block#  
Data Guard broker: wait upon ORA-12850 error Other waiting for retrying the query to mask ORA-12850 error    
db file parallel read User I/O files blocks requests
db file parallel write System I/O requests interrupt timeout
db file scattered read User I/O file# block# blocks
db file sequential read User I/O file# block# blocks
db file single write User I/O file# block# blocks
DBFG waiting for reply Other      
DBMS_LDAP: LDAP operation Other      
debugger command Other      
dedicated server timer Network wait event    
DFS db file lock Other file#    
DFS lock handle Other type|mode id1 id2
DIAG dummy wait Other      
direct path read User I/O file number first dba block cnt
direct path read temp User I/O file number first dba block cnt
direct path write User I/O file number first dba block cnt
direct path write temp User I/O file number first dba block cnt
dispatcher listen timer Network sleep time    
dispatcher shutdown Other waited    
dispatcher timer Idle sleep time    
DLM lock cancel Other le    
DLM lock cvt S Other group obj# block#
DLM lock cvt X Other group obj# block#
DLM lock esc Other group obj# block#
DLM lock esc X Other group obj# block#
DLM lock open Other group obj# block#
DLM lock open S Other group obj# block#
DLM lock open X Other group obj# block#
DLM recovery lock convert Other group obj# block#
DLM recovery lock open Other group obj# block#
dma prepare busy Other group obj# block#
dupl. cluster key Other dba    
enq: AD - allocate AU Other name|mode group and disk number AU number
enq: AD - deallocate AU Other name|mode group and disk number AU number
enq: AF - task serialization Other name|mode task id 0
enq: AG - contention Other name|mode workspace # generation
enq: AO - contention Other name|mode workspace # object #
enq: AS - contention Other name|mode 0 0
enq: AT - contention Other name|mode 0 0
enq: AW - AW generation lock Other name|mode operation workspace #
enq: AW - AW state lock Other name|mode operation workspace #
enq: AW - AW$ table lock Other name|mode operation workspace #
enq: AW - user access for AW Other name|mode operation workspace #
enq: BR - file shrink Other name|mode operation file #
enq: BR - proxy-copy Other name|mode operation file #
enq: CF - contention Other name|mode 0 operation
enq: CI - contention Other name|mode opcode type
enq: CL - compare labels Other name|mode object # 0
enq: CL - drop label Other name|mode object # 0
enq: CM - gate Other name|mode disk group # type
enq: CM - instance Other name|mode disk group # type
enq: CT - change stream ownership Other name|mode operation operation parm
enq: CT - CTWR process start/stop Other name|mode operation operation parm
enq: CT - global space management Other name|mode operation operation parm
enq: CT - local space management Other name|mode operation operation parm
enq: CT - reading Other name|mode operation operation parm
enq: CT - state Other name|mode operation operation parm
enq: CT - state change gate 1 Other name|mode operation operation parm
enq: CT - state change gate 2 Other name|mode operation operation parm
enq: CU - contention Other name|mode handle handle
enq: DB - contention Administrative name|mode EnqMode 0
enq: DD - contention Other name|mode disk group type
enq: DF - contention Other name|mode 0 file #
enq: DG - contention Other name|mode disk group type
enq: DL - contention Other name|mode object # 0
enq: DM - contention Other name|mode type type
enq: DN - contention Other name|mode 0 0
enq: DP - contention Other name|mode 0 0
enq: DR - contention Other name|mode 0 0
enq: DS - contention Other name|mode 0 0
enq: DT - contention Other name|mode 0 0
enq: DV - contention Other name|mode object # 0
enq: DX - contention Other name|mode transaction entry # 0
enq: FA - access file Other name|mode disk group number file number
enq: FB - contention Other name|mode tablespace # dba
enq: FC - open an ACD thread Other name|mode disk group thread
enq: FC - recover an ACD thread Other name|mode disk group thread
enq: FD - Flashback coordinator Other name|mode Internal Internal
enq: FD - Flashback on/off Other name|mode Internal Internal
enq: FD - Marker generation Other name|mode Internal Internal
enq: FD - Tablespace flashback on/off Other name|mode Internal Internal
enq: FG - FG redo generation enq race Other name|mode disk group type
enq: FG - LGWR redo generation enq race Other name|mode disk group type
enq: FG - serialize ACD relocate Other name|mode disk group type
enq: FL - Flashback database log Other name|mode Log # zero
enq: FL - Flashback db command Other name|mode Log # zero
enq: FM - contention Other name|mode 0 0
enq: FR - contention Other name|mode disk group unused
enq: FS - contention Other name|mode 0 type
enq: FT - allow LGWR writes Other name|mode disk group thread
enq: FT - disable LGWR writes Other name|mode disk group thread
enq: FU - contention Other name|mode 0 0
enq: HD - contention Other name|mode disk group 0
enq: HP - contention Other name|mode tablespace # dba
enq: HQ - contention Other name|mode object # hash value
enq: HV - contention Other name|mode object # 0
enq: HW - contention Configuration name|mode table space # block
enq: IA - contention Other name|mode 0 0
enq: ID - contention Other name|mode 0 0
enq: IL - contention Other name|mode object # 0
enq: IM - contention for blr Other name|mode pool # 0
enq: IR - contention Other name|mode 0 0/1
enq: IR - contention2 Other name|mode 0 0/1
enq: IS - contention Other name|mode 0 type
enq: IT - contention Other name|mode object # 0
enq: JD - contention Other name|mode 0 0
enq: JI - contention Other name|mode view object # 0
enq: JQ - contention Other name|mode 0 0
enq: JS - contention Other name|mode service ID queue type
enq: JS - coord post lock Other name|mode service ID queue type
enq: JS - coord rcv lock Other name|mode service ID queue type
enq: JS - global wdw lock Other name|mode service ID queue type
enq: JS - job chain evaluate lock Other name|mode service ID queue type
enq: JS - job recov lock Other name|mode service ID queue type
enq: JS - job run lock - synchronize Other name|mode service ID queue type
enq: JS - q mem clnup lck Other name|mode service ID queue type
enq: JS - queue lock Other name|mode service ID queue type
enq: JS - running job cnt lock Other name|mode service ID queue type
enq: JS - running job cnt lock2 Other name|mode service ID queue type
enq: JS - running job cnt lock3 Other name|mode service ID queue type
enq: JS - slave enq get lock1 Other name|mode service ID queue type
enq: JS - slave enq get lock2 Other name|mode service ID queue type
enq: KK - context Other name|mode 0 redo thread
enq: KM - contention Other name|mode type type
enq: KP - contention Other name|mode 0 0
enq: KT - contention Other name|mode plan # 0
enq: MD - contention Other name|mode master object # 0
enq: MH - contention Other name|mode 0 0
enq: ML - contention Other name|mode 0 0
enq: MN - contention Other name|mode session ID 0
enq: MR - contention Other name|mode 0 or file # type
enq: MS - contention Other name|mode master object # 0
enq: MW - contention Other name|mode Schedule Id 0
enq: OC - contention Other name|mode 1 2
enq: OL - contention Other name|mode hash value 0
enq: OQ - xsoq*histrecb Other name|mode resource id 0
enq: OQ - xsoqhiAlloc Other name|mode resource id 0
enq: OQ - xsoqhiClose Other name|mode resource id 0
enq: OQ - xsoqhiFlush Other name|mode resource id 0
enq: OQ - xsoqhistrecb Other name|mode resource id 0
enq: PD - contention Other name|mode property name key hash
enq: PE - contention Other name|mode parno 0
enq: PF - contention Other name|mode 0 0
enq: PG - contention Other name|mode 0 0
enq: PH - contention Other name|mode 0 0
enq: PI - contention Other name|mode operation serial #
enq: PL - contention Other name|mode 0 0
enq: PR - contention Other name|mode 0 0
enq: PS - contention Other name|mode instance slave ID
enq: PT - contention Other name|mode disk group # type
enq: PV - syncshut Other name|mode 0 0
enq: PV - syncstart Other name|mode 0 0
enq: PW - flush prewarm buffers Application name|mode 0 0
enq: PW - perwarm status in dbw0 Other name|mode 0 0
enq: RB - contention Other name|mode disk group 0
enq: RF - atomicity Other name|mode lock operation lock value
enq: RF - new AI Other name|mode lock operation lock value
enq: RF - synch: per-SGA Broker metadata Other name|mode lock operation lock value
enq: RF - synchronization: aifo master Other name|mode lock operation lock value
enq: RF - synchronization: chief Other name|mode lock operation lock value
enq: RF - synchronization: critical ai Other name|mode lock operation lock value
enq: RF - synchronization: HC master Other name|mode lock operation lock value
enq: RN - contention Other name|mode thread number log number
enq: RO - contention Application name|mode 1 0
enq: RO - fast object reuse Application name|mode 1 0
enq: RP - contention Other name|mode file # 1 or block
enq: RS - file delete Other name|mode record type record id
enq: RS - persist alert level Other name|mode record type record id
enq: RS - prevent aging list update Other name|mode record type record id
enq: RS - prevent file delete Other name|mode record type record id
enq: RS - read alert level Other name|mode record type record id
enq: RS - record reuse Other name|mode record type record id
enq: RS - write alert level Other name|mode record type record id
enq: RT - contention Other name|mode redo thread type
enq: SB - contention Other name|mode 0 0
enq: SF - contention Other name|mode 0 0
enq: SH - contention Other name|mode 0 0
enq: SI - contention Other name|mode object # 0
enq: SK - contention Other name|mode tablespace # dba
enq: SQ - contention Configuration name|mode object # 0
enq: SR - contention Other name|mode operation sequence # / apply #
enq: SS - contention Other name|mode tablespace # dba
enq: ST - contention Configuration name|mode 0 0
enq: SU - contention Other name|mode table space # 0
enq: SW - contention Other name|mode 0 0
enq: TA - contention Other name|mode operation undo segment # / other
enq: TB - SQL Tuning Base Cache Load Other name|mode 1 2
enq: TB - SQL Tuning Base Cache Update Other name|mode 1 2
enq: TC - contention Other name|mode checkpoint ID 0
enq: TC - contention2 Other name|mode checkpoint ID 0
enq: TD - KTF dump entries Other name|mode 0 0
enq: TE - KTF broadcast Other name|mode 0 0
enq: TF - contention Other name|mode tablespace # relative file #
enq: TL - contention Other name|mode 0 0
enq: TM - contention Application name|mode object # table/partition
enq: TO - contention Other name|mode object # 1
enq: TQ - DDL contention Other name|mode QT_OBJ# 0
enq: TQ - INI contention Other name|mode QT_OBJ# 0
enq: TQ - TM contention Other name|mode QT_OBJ# 0
enq: TS - contention Other name|mode tablespace ID dba
enq: TT - contention Other name|mode tablespace ID operation
enq: TW - contention Administrative name|mode 0 operation
enq: TX - allocate ITL entry Configuration name|mode usn<<16 | slot sequence
enq: TX - contention Other name|mode usn<<16 | slot sequence
enq: TX - index contention Concurrency name|mode usn<<16 | slot sequence
enq: TX - row lock contention Application name|mode usn<<16 | slot sequence
enq: UL - contention Application name|mode id 0
enq: US - contention Other name|mode undo segment # 0
enq: WA - contention Other name|mode 0 0
enq: WF - contention Other name|mode 0 0
enq: WL - contention Other name|mode log # / thread id # sequence #
enq: WP - contention Other name|mode 0 0
enq: XH - contention Other name|mode 0 0
enq: XR - database force logging Other name|mode operation 0
enq: XR - quiesce database Other name|mode operation 0
enq: XY - contention Other name|mode id1 id2
extent map load/unlock Other group file extent
flashback buf free by RVWR Other      
flashback free VI log Other      
flashback log switch Other      
Flow Control Event Other      
foreground creation: start Other      
foreground creation: wait Other      
free buffer waits Configuration file# block# set-id#
free global transaction table entry Other tries    
free process state object Other      
gc assume Cluster le    
gc block recovery request Cluster file# block# class#
gc buffer busy Cluster file# block# id#
gc claim Cluster      
gc cr block 2-way Cluster      
gc cr block 3-way Cluster      
gc cr block busy Cluster      
gc cr block congested Cluster      
gc cr block unknown Cluster      
gc cr cancel Cluster le    
gc cr disk read Cluster      
gc cr disk request Cluster file# block# class#
gc cr failure Cluster      
gc cr grant 2-way Cluster      
gc cr grant busy Cluster      
gc cr grant congested Cluster      
gc cr grant unknown Cluster      
gc cr multi block request Cluster file# block# class#
gc cr request Cluster file# block# class#
gc current block 2-way Cluster      
gc current block 3-way Cluster      
gc current block busy Cluster      
gc current block congested Cluster      
gc current block unknown Cluster      
gc current cancel Cluster le    
gc current grant 2-way Cluster      
gc current grant busy Cluster      
gc current grant congested Cluster      
gc current grant unknown Cluster      
gc current multi block request Cluster file# block# id#
gc current request Cluster file# block# id#
gc current retry Cluster      
gc current split Cluster      
gc domain validation Cluster      
gc freelist Cluster      
gc prepare Cluster      
gc quiesce wait Cluster      
gc recovery free Cluster      
gc recovery quiesce Cluster      
gc remaster Cluster      
gcs ddet enter server mode Other      
gcs domain validation Other cluinc rcvinc  
gcs drm freeze begin Other      
gcs drm freeze in enter server mode Other      
gcs enter server mode Other      
gcs log flush sync Other waittime poll event
gcs remastering wait for read latch Other      
gcs remastering wait for write latch Other      
gcs remote message Idle waittime poll event
gcs resource directory to be unfrozen Other      
gcs to be enabled Other      
ges cached resource cleanup Other waittime    
ges cancel Other      
ges cgs registration Other      
ges enter server mode Other      
ges generic event Other      
ges global resource directory to be frozen Other      
ges inquiry response Other type|mode id1 id2
ges lmd and pmon to attach Other      
ges LMD suspend for testing event Other      
ges LMD to inherit communication channels Other      
ges LMD to shutdown Other      
ges lmd/lmses to freeze in rcfg - mrcvr Other      
ges lmd/lmses to unfreeze in rcfg - mrcvr Other      
ges LMON for send queues Other      
ges LMON to get to FTDONE Other      
ges LMON to join CGS group Other      
ges master to get established for SCN op Other      
ges performance test completion Other      
ges pmon to exit Other      
ges process with outstanding i/o Other pid    
ges reconfiguration to start Idle      
ges remote message Idle waittime loop p3
ges resource cleanout during enqueue open Other      
ges resource cleanout during enqueue open-cvt Other      
ges resource directory to be unfrozen Other      
ges reusing os pid Other pid count  
ges user error Other error    
ges wait for lmon to be ready Other      
ges1 LMON to wake up LMD - mrcvr Other      
ges2 LMON to wake up LMD - mrcvr Other      
ges2 LMON to wake up lms - mrcvr 2 Other      
ges2 LMON to wake up lms - mrcvr 3 Other      
ges2 proc latch in rm latch get 1 Other      
ges2 proc latch in rm latch get 2 Other      
global cache busy Other group file# block#
global enqueue expand wait Other      
GV$: slave acquisition retry wait time Other      
HS message to agent Idle      
i/o slave wait Other msg ptr    
imm op Other msg ptr    
inactive session Other session# waited  
inactive transaction branch Other branch# waited  
index (re)build online cleanup Administrative object mode wait
index (re)build online merge Administrative object mode wait
index (re)build online start Administrative object mode wait
index block split Other rootdba level childdba
instance state change Other layer value waited
io done System I/O msg ptr    
IPC busy async request Other      
IPC send completion sync Other send count    
IPC wait for name service busy Other      
IPC waiting for OSD resources Other      
job scheduler coordinator slave wait Other      
jobq slave wait Idle      
JS coord start wait Other      
JS external job Idle      
JS kgl get object wait Other      
JS kill job wait Other      
kcbzps Other      
kcrrrcp Other      
kdic_do_merge Other      
kfcl: instance recovery Other group obj# block#
kfk: async disk IO System I/O count intr timeout
kgltwait Other      
kjbdomalc allocate recovery domain - retry Other      
kjbdrmcvtq lmon drm quiesce: ping completion Other      
kjbopen wait for recovery domain attach Other      
KJC: Wait for msg sends to complete Other msg dest|rcvr mtype
kjctcisnd: Queue/Send client message Other      
kjctssqmg: quick message send wait Other      
kjudomatt wait for recovery domain attach Other      
kjudomdet wait for recovery domain detach Other      
kjxgrtest Other      
kkdlgon Other      
kkdlhpon Other      
kkdlsipon Other      
kksfbc child completion Other      
kksfbc research Other      
kkshgnc reloop Other      
kksscl hash split Other      
knlqdeq Other      
knlWaitForStartup Other      
knpc_acwm_AwaitChangedWaterMark Other      
knpc_anq_AwaitNonemptyQueue Other      
knpsmai Other      
ksbcic Other      
ksbsrv Other      
ksdxexeother Other      
ksdxexeotherwait Other      
ksfd: async disk IO System I/O count intr timeout
ksfd: fib/fob latch Other      
ksim generic wait event Other where wait_count  
ksqded Other      
ksv slave avail wait Other      
ksxr poll remote instances Other      
ktfbtgex Other tsn    
ktm: instance recovery Other undo segment#    
ktsambl Other      
kttm2d Other      
Kupp process shutdown Other nalive sleeptime loop
kupp process wait Other      
kxfxse Other kxfxse debug wait: stalling for slave 0    
kxfxsp Other kxfxsp debug wait: stalling for slave 0    
L1 validation Other seghdr l1bmb  
latch activity Other address number process#
latch free Other address number tries
latch: cache buffer handles Other address number tries
latch: cache buffers chains Concurrency address number tries
latch: cache buffers lru chain Other address number tries
latch: checkpoint queue latch Other address number tries
latch: enqueue hash chains Other address number tries
latch: gcs resource hash Other address number tries
latch: ges resource hash list Other address number tries
latch: In memory undo latch Concurrency address number tries
latch: KCL gc element parent latch Other address number tries
latch: latch wait list Other address number tries
latch: library cache Concurrency address number tries
latch: library cache lock Concurrency address number tries
latch: library cache pin Concurrency address number tries
latch: messages Other address number tries
latch: MQL Tracking Latch Concurrency address number tries
latch: object queue header heap Other address number tries
latch: object queue header operation Other address number tries
latch: parallel query alloc buffer Other address number tries
latch: redo allocation Other address number tries
latch: redo copy Configuration address number tries
latch: redo writing Configuration address number tries
latch: row cache objects Other address number tries
latch: session allocation Other address number tries
latch: shared pool Configuration address number tries
latch: undo global data Other address number tries
latch: virtual circuit queues Other address number tries
LGWR random i/o System I/O      
LGWR sequential i/o System I/O      
LGWR simulation latency wait Other      
LGWR wait for redo copy Other copy latch #    
LGWR wait on ATTACH Network      
LGWR wait on DETACH Network      
LGWR wait on full LNS buffer Other      
LGWR wait on LNS Network      
LGWR wait on SENDREQ Network      
LGWR-LNS wait on channel Other      
library cache load lock Concurrency object address lock address 100*mask+namespace
library cache lock Concurrency handle address lock address 100*mode+namespace
library cache pin Concurrency handle address pin address 100*mode+namespace
library cache revalidation Other      
listen endpoint status Other end-point# status  
LNS simulation latency wait Other      
LNS wait for LGWR redo Other      
LNS wait on ATTACH Network      
LNS wait on DETACH Network      
LNS wait on LGWR Network      
LNS wait on SENDREQ Network      
local write wait User I/O file# block#  
lock close Other group lms#  
lock deadlock retry Other      
lock escalate retry Other      
lock release pending Other group file# block#
lock remastering Cluster      
log buffer space Configuration      
log file parallel write System I/O files blocks requests
log file sequential read System I/O log# block# blocks
log file single write System I/O log# block# blocks
log file switch (archiving needed) Configuration      
log file switch (checkpoint incomplete) Configuration      
log file switch (clearing log file) Configuration      
log file switch completion Configuration      
log file sync Commit buffer#    
log switch/archive Configuration thread#    
log write(even) Other group#    
log write(odd) Other group#    
master exit Other alive slaves    
master wait Other      
MMON (Lite) shutdown Other process# waited  
MMON slave messages Other      
MRP wait on archivelog archival Other      
MRP wait on archivelog arrival Other      
MRP wait on archivelog delay Other      
MRP wait on process death Other      
MRP wait on process restart Other      
MRP wait on process start Other      
MRP wait on startup clear Other      
MRP wait on state change Other      
MRP wait on state n_a Other      
MRP wait on state reset Other      
multiple dbwriter suspend/resume for file offline Administrative      
name-service call wait Other waittime    
no free buffers Other group# obj# block#
no free locks Other      
null event Other      
OLAP Aggregate Client Deq Other sleeptime/senderid passes  
OLAP Aggregate Client Enq Other sleeptime/senderid passes  
OLAP Aggregate Master Deq Other sleeptime/senderid passes  
OLAP Aggregate Master Enq Other sleeptime/senderid passes  
OLAP Null PQ Reason Other sleeptime/senderid passes  
OLAP Parallel Temp Grew Other sleeptime/senderid passes  
OLAP Parallel Temp Grow Request Other sleeptime/senderid passes  
OLAP Parallel Temp Grow Wait Other sleeptime/senderid passes  
OLAP Parallel Type Deq Other sleeptime/senderid passes  
opishd Other      
parallel recovery coordinator waits for cleanup of slaves Idle      
pending global transaction(s) Other scans    
pi renounce write complete Cluster file# block#  
pipe get Idle handle address buffer length timeout
pipe put Concurrency handle address record length timeout
PL/SQL lock timer Idle duration    
pmon timer Idle duration    
process shutdown Other type process# waited
process startup Other type process# waited
PX create server Other nservers sleeptime enqueue
PX Deq Credit: free buffer Other sleeptime/senderid passes qref
PX Deq Credit: need buffer Idle sleeptime/senderid passes qref
PX Deq Credit: send blkd Other sleeptime/senderid passes qref
PX Deq: Execute Reply Idle sleeptime/senderid passes  
PX Deq: Execution Msg Idle sleeptime/senderid passes  
PX Deq: Index Merge Close Idle sleeptime/senderid passes  
PX Deq: Index Merge Execute Idle sleeptime/senderid passes  
PX Deq: Index Merge Reply Idle sleeptime/senderid passes  
PX Deq: Join ACK Idle sleeptime/senderid passes  
PX Deq: kdcph_mai Idle kdcph_mai    
PX Deq: kdcphc_ack Idle kdcphc_ack    
PX Deq: Msg Fragment Idle sleeptime/senderid passes  
PX Deq: OLAP Update Close Other sleeptime/senderid passes  
PX Deq: OLAP Update Execute Other sleeptime/senderid passes  
PX Deq: OLAP Update Reply Other sleeptime/senderid passes  
PX Deq: Par Recov Change Vector Idle sleeptime/senderid passes  
PX Deq: Par Recov Execute Idle sleeptime/senderid passes  
PX Deq: Par Recov Reply Idle sleeptime/senderid passes  
PX Deq: Parse Reply Idle sleeptime/senderid passes  
PX Deq: reap credit Other      
PX Deq: Signal ACK Other sleeptime/senderid passes  
PX Deq: Table Q Close Other sleeptime/senderid passes  
PX Deq: Table Q Get Keys Other sleeptime/senderid passes  
PX Deq: Table Q Normal Idle sleeptime/senderid passes  
PX Deq: Table Q qref Other sleeptime/senderid passes  
PX Deq: Table Q Sample Idle sleeptime/senderid passes  
PX Deq: Test for msg Other sleeptime/senderid passes  
PX Deq: Txn Recovery Reply Idle sleeptime/senderid passes  
PX Deq: Txn Recovery Start Idle sleeptime/senderid passes  
PX Deque wait Idle sleeptime/senderid passes  
PX Idle Wait Idle sleeptime/senderid passes  
PX Nsq: PQ descriptor query Other      
PX Nsq: PQ load info query Other      
PX qref latch Other function sleeptime qref
PX Send Wait Other      
PX server shutdown Other nalive sleeptime loop
PX signal server Other serial error nbusy
PX slave connection Other      
PX slave release Other      
qerex_gdml Other      
queue messages Idle queue id process# wait time
Queue Monitor IPC wait Idle      
Queue Monitor Shutdown Wait Idle      
Queue Monitor Slave Wait Idle      
Queue Monitor Task Wait Other      
Queue Monitor Wait Idle      
queue slave messages Other      
rdbms ipc message Idle timeout    
rdbms ipc message block Other      
rdbms ipc reply Other from_process timeout  
read by other session User I/O file# block# class#
recovery area: computing applied logs Other      
recovery area: computing backed up files Other      
recovery area: computing dropped files Other      
recovery area: computing identical files Other      
recovery area: computing obsolete files Other      
recovery read System I/O      
refresh controlfile command Administrative      
reliable message Other channel context channel handle broadcast message
Replication Dequeue Other sleeptime/senderid passes  
resmgr:become active Scheduler location    
resmgr:cpu quantum Scheduler location    
resmgr:internal state change Concurrency location    
resmgr:internal state cleanup Concurrency location    
resmgr:sessions to exit Concurrency location    
retry contact SCN lock master Cluster      
rfc_open_retry Other DMON waiting to retry configuration file open    
rfi_drcx_site_del Other DRCX waiting for site to delete metadata    
rfi_insv_shut Other wait for INSV to shutdown    
rfi_insv_start Other wait for INSV to start    
rfi_nsv_deldef Other NSVx to defer delete response message post to DMON    
rfi_nsv_md_close Other NSVx metadata file close wait    
rfi_nsv_md_write Other NSVx metadata file write wait    
rfi_nsv_postdef Other NSVx to defer message post to DMON    
rfi_nsv_shut Other wait for NSVx to shutdown    
rfi_nsv_start Other wait for NSVx to start    
rfi_recon1 Other letting site register with its local listener before connect ret    
rfi_recon2 Other retrying connection for sending to remote DRCX    
rfm_dmon_last_gasp Other DMON waiting on the last gasp event    
rfm_dmon_pdefer Other DMON phase deferral wait    
rfm_dmon_shut Other wait for DMON to shutdown    
rfm_dmon_timeout_op Other DMON waiting to timeout an operation    
rfm_pmon_dso_stall Other PMON delete state object stall    
rfrdb_dbop Other waiting for database to be opened    
rfrdb_recon1 Other reconnecting back to new primary site during standby viability c    
rfrdb_recon2 Other waiting for standby database to be mounted    
rfrdb_try235 Other waiting for retrying the query to mask ORA-235 error    
rfrla_lapp1 Other waiting for logical apply engine to initialize    
rfrla_lapp2 Other checking for logical apply engine run-down progress    
rfrla_lapp3 Other waiting for new primary to initialize tables    
rfrla_lapp4 Other waiting for v$logstdby_stats view to be initialized    
rfrla_lapp5 Other waiting to reconnect to primary that is in BUILD_UP    
rfrm_dbcl Other RSM notifier: waiting for sql latch on db close    
rfrm_dbop Other RSM notifier: waiting for sql latch on db open    
rfrm_nonzero_sub_count Other wait for subscriber count to become nonzero    
rfrm_rsm_shut Other wait for RSMx processes to shutdown    
rfrm_rsm_so_attach Other wait for RSMx to attach to state object    
rfrm_rsm_start Other wait for RSMx processes to start    
rfrm_stall Other RSM stall due to event RSM_STALL    
rfrm_zero_sub_count Other wait for subscriber count to become zero    
rfrpa_mrpdn Other waiting for MRP0 to stop while bringing physical apply engine of    
rfrpa_mrpup Other waiting for MRP0 to start while bringing physical apply engine o    
rfrxpt_pdl Other waiting for retrying potential dataloss calculation before switc    
rfrxptarcurlog Other waiting for logical apply engine to finish initialization    
RFS announce Other      
RFS attach Other      
RFS close Other      
RFS create Other      
RFS detach Other      
RFS dispatch Other      
RFS ping Other      
RFS random i/o System I/O      
RFS register Other      
RFS sequential i/o System I/O      
RFS write System I/O      
rollback operations active Other operation count    
rollback operations block full Other max operations    
row cache lock Concurrency cache id mode request
row cache read Concurrency cache id address times
RVWR wait for flashback copy Other copy latch #    
scginq AST call Other      
secondary event Other event # wait time  
select wait Other      
simulated log write delay Other      
single-task message Idle      
slave exit Other nalive sleeptime loop
slave shutdown wait Other      
slave TJ process wait Other      
smon timer Idle sleep time failed  
sort segment request Configuration      
SQL*Net break/reset to client Application driver id break?  
SQL*Net break/reset to dblink Application driver id break?  
SQL*Net message from client Idle driver id #bytes  
SQL*Net message from dblink Idle driver id #bytes  
SQL*Net message to client Network driver id #bytes  
SQL*Net message to dblink Network driver id #bytes  
SQL*Net more data from client Network driver id #bytes  
SQL*Net more data from dblink Network driver id #bytes  
SQL*Net more data to client Network driver id #bytes  
SQL*Net more data to dblink Network driver id #bytes  
statement suspended, wait error to be cleared Idle      
STREAMS apply coord waiting for slave message Idle      
STREAMS apply slave idle wait Idle      
STREAMS apply slave waiting for coord message Application      
STREAMS capture process filter callback wait for ruleset Idle      
STREAMS capture process waiting for archive log Other      
STREAMS fetch slave waiting for txns Idle      
Streams: Wait for inter instance ack Other      
Streams: Wating for DDL to apply Application sleep time    
switch logfile command Administrative      
switch undo - offline Administrative      
SWRF RWM Auto Capture Event Other      
SWRF Wait on Flushing Other      
Sync ASM rebalance Other      
test long ops Other      
timer in sksawat Other      
trace continue Other delay time    
trace unfreeze Other      
trace writer flush Other      
trace writer I/O Other      
transaction Other undo seg#|slot# wrap# count
txn to complete Other      
unbound tx Other      
undo segment extension Configuration segment#    
undo segment recovery Other segment# tx flags  
undo segment tx slot Configuration segment#    
unspecified wait event Other      
virtual circuit status Idle circuit# status  
wait active processes Other      
wait for a paralle reco to abort Other      
wait for a undo record Other      
wait for activate message Idle      
wait for another txn - rollback to savepoint Other      
wait for another txn - txn abort Other      
wait for another txn - undo rcv abort Other      
wait for assert messages to be sent Other      
wait for change Other      
Wait for Dictionary Build to lock all tables Other      
wait for EMON to die Other      
wait for EMON to process ntfns Configuration      
wait for EMON to spawn Other      
wait for FMON to come up Other      
wait for Logical Standby Apply shutdown Other      
wait for master scn Other waittime startscn ackscn
wait for membership synchronization Other      
wait for message ack Other      
wait for MTTR advisory state object Other      
wait for possible quiesce finish Administrative      
wait for record update Other      
wait for resize request completion Other      
wait for rr lock release Other      
wait for scn ack Other pending_nd scnwrp scnbas
wait for SGA component shrink Other component id current size target size
wait for sga_target resize Other      
Wait for shrink lock Other object_id lock_mode  
Wait for shrink lock2 Other object_id lock_mode  
wait for split-brain resolution Other      
wait for stopper event to be increased Other      
wait for sync ack Other cluinc pending_nd  
Wait for Table Lock Application      
wait for tmc2 to complete Other      
wait for transaction Idle      
Wait for TT enqueue Other tsn    
wait for unread message on broadcast channel Idle channel context channel handle  
wait for unread message on multiple broadcast channels Idle channel context channel handle count  
wait for verification ack Other cluinc pending_insts  
wait for votes Other      
wait list latch activity Other address number process#
wait list latch free Other address number tries
Wait on stby instance close Other      
waiting for low memory condition to be resolved Idle      
waiting for subscribers to catch up Idle      
waiting to get CAS latch Other      
waiting to get RM CAS latch Other      
wakeup blocked enqueuers Other      
wakeup event for builder Idle      
wakeup event for preparer Idle      
wakeup event for reader Idle      
wakeup time manager Idle      
write complete waits Configuration file# block#  
writes stopped by instance recovery or database suspension Other by thread# our thread#  

 

 

 

 

”call

  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 
   

Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.