oracle wait events(等待事件) 一览表

最新推荐文章于 2023-09-19 18:58:50 发布

congtangguan9702

最新推荐文章于 2023-09-19 18:58:50 发布

阅读量3.4k

点赞数

文章标签：数据库网络 ldap

在oracle出现性能问题时，通过等待事件，非常有助于我们去分析问题。在oracle的每个大的版本里面，都会增加或者删除一些等待事件。
我们可以通过查询v$event_name查看所有的等待事件(wait events)，下面将查询结果贴出来供大家参考。
版本

select * from v$version where rownum<2;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

select name,wait_class from v$event_name;

NAME WAIT_CLASS
-------------------------------------------------------------------------------- --------------------
ASM COD rollback operation completion Administrative
enq: ZG - contention Administrative
JS kgl get object wait Administrative
JS kill job wait Administrative
JS coord start wait Administrative
Backup: MML initialization Administrative
Backup: MML v1 open backup piece Administrative
Backup: MML v1 read backup piece Administrative
Backup: MML v1 write backup piece Administrative
Backup: MML v1 close backup piece Administrative
Backup: MML v1 query backup piece Administrative
Backup: MML v1 delete backup piece Administrative
Backup: MML create a backup piece Administrative
Backup: MML commit backup piece Administrative
Backup: MML command to channel Administrative
Backup: MML shutdown Administrative
Backup: MML obtain textual error Administrative
Backup: MML query backup piece Administrative
Backup: MML extended initialization Administrative
Backup: MML read backup piece Administrative
Backup: MML delete backup piece Administrative
Backup: MML restore backup piece Administrative
Backup: MML write backup piece Administrative
Backup: MML proxy initialize backup Administrative
Backup: MML proxy cancel Administrative
Backup: MML proxy commit backup piece Administrative
Backup: MML proxy session end Administrative
Backup: MML datafile proxy backup? Administrative
Backup: MML datafile proxy restore? Administrative
Backup: MML proxy initialize restore Administrative
Backup: MML proxy start data movement Administrative
Backup: MML data movement done? Administrative
Backup: MML proxy prepare to start Administrative
Backup: MML obtain a direct buffer Administrative
Backup: MML release a direct buffer Administrative
Backup: MML get base address Administrative
Backup: MML query for direct buffers Administrative
control file backup creation Administrative
multiple dbwriter suspend/resume for file offline Administrative
db flash cache dynamic disabling wait Administrative
switch logfile command Administrative
enq: MV - datafile move Administrative
wait for possible quiesce finish Administrative
concurrent I/O completion Administrative
datafile copy range completion Administrative
switch undo - offline Administrative
alter rbs offline Administrative
enq: TW - contention Administrative
index (re)build online start Administrative
index (re)build online cleanup Administrative
index (re)build online merge Administrative
alter system set dispatcher Administrative
connection pool wait Administrative
enq: DB - contention Administrative
ASM mount : wait for heartbeat Administrative
enq: UL - contention Application
OLAP DML Sleep Application
WCR: replay lock order Application
enq: PW - flush prewarm buffers Application
enq: RO - contention Application
enq: RO - fast object reuse Application
enq: KO - fast object checkpoint Application
enq: TM - contention Application
enq: TX - row lock contention Application
Wait for Table Lock Application
enq: RC - Result Cache: Contention Application
Streams capture: filter callback waiting for ruleset Application
Streams: apply reader waiting for DDL to apply Application
SQL*Net break/reset to client Application
SQL*Net break/reset to dblink Application
External Procedure initial connection Application
External Procedure call Application
gc claim Cluster
gc cancel retry Cluster
ASM PST query : wait for [PM][grp][0] grant Cluster
lock remastering Cluster
retry contact SCN lock master Cluster
gc buffer busy acquire Cluster
gc buffer busy release Cluster
pi renounce write complete Cluster
gc current request Cluster
gc cr request Cluster
gc cr disk request Cluster
gc cr multi block request Cluster
gc current multi block request Cluster
gc block recovery request 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 failure Cluster
gc cr block lost Cluster
gc cr block unknown Cluster
gc current block 2-way Cluster
gc current block 3-way Cluster
gc current block busy Cluster
gc current block congested Cluster
gc current retry Cluster
gc current block lost Cluster
gc current split Cluster
gc current block unknown Cluster
gc cr grant 2-way Cluster
gc cr grant busy Cluster
gc cr grant congested Cluster
gc cr grant unknown Cluster
gc cr disk read Cluster
gc current grant 2-way Cluster
gc current grant busy Cluster
gc current grant congested Cluster
gc current grant unknown Cluster
gc freelist Cluster
gc remaster Cluster
gc quiesce Cluster
gc object scan Cluster
gc recovery Cluster
gc flushed buffer Cluster
gc current cancel Cluster
gc cr cancel Cluster
gc assume Cluster
gc domain validation Cluster
gc recovery free Cluster
gc recovery quiesce Cluster
log file sync Commit
enq: BB - 2PC across RAC instances Commit
row cache read Concurrency
row cache lock Concurrency
latch: row cache objects Concurrency
enq: WG - lock fso Concurrency
SecureFile mutex Concurrency
db flash cache invalidate wait Concurrency
buffer busy waits Concurrency
enq: HV - contention Concurrency
latch: In memory undo latch Concurrency
latch: Undo Hint Latch Concurrency
latch: cache buffers chains Concurrency
Shared IO Pool Memory Concurrency
os thread startup Concurrency
logout restrictor Concurrency
enq: TX - index contention Concurrency
Streams apply: waiting for dependency Concurrency
securefile chain update Concurrency
pipe put Concurrency
resmgr:sessions to exit Concurrency
resmgr:internal state change Concurrency
cursor: mutex S Concurrency
cursor: pin X Concurrency
cursor: pin S Concurrency
cursor: pin S wait on X Concurrency
latch: MQL Tracking Latch Concurrency
latch: shared pool Concurrency
library cache pin Concurrency
library cache lock Concurrency
library cache load lock Concurrency
library cache: mutex X Concurrency
library cache: mutex S Concurrency
cursor: mutex X Concurrency
libcache interrupt action by LCK Concurrency
log file switch completion Configuration
log file switch (archiving needed) Configuration
log file switch (private strand flush incomplete) Configuration
log file switch (checkpoint incomplete) Configuration
log buffer space Configuration
latch: redo copy Configuration
latch: redo writing Configuration
write complete waits: flash cache Configuration
write complete waits Configuration
checkpoint completed Configuration
free buffer waits Configuration
wait for EMON to process ntfns Configuration
Streams apply: waiting to commit Configuration
Global transaction acquire instance locks Configuration
enq: SQ - contention Configuration
sort segment request Configuration
enq: SS - contention Configuration
enq: HW - contention Configuration
statement suspended, wait error to be cleared Configuration
enq: TX - allocate ITL entry Configuration
undo segment tx slot Configuration
undo segment extension Configuration
flashback buf free by RVWR Configuration
enq: ST - contention Configuration
PX Deq Credit: send blkd Idle
PX Deq: Msg Fragment Idle
PX Deq: Parse Reply Idle
PX Deq: Execute Reply Idle
PX Deq: Execution Msg Idle
PX Deq: Table Q Normal Idle
PX Deq: Table Q Sample Idle
Streams fetch slave: waiting for txns Idle
Streams: waiting for messages Idle
Streams capture: waiting for archive log Idle
single-task message Idle
SQL*Net message from client Idle
SQL*Net vector message from client Idle
SQL*Net vector message from dblink Idle
PL/SQL lock timer Idle
Streams AQ: emn coordinator idle wait Idle
EMON slave idle wait Idle
Streams AQ: waiting for messages in the queue Idle
Streams AQ: waiting for time management or cleanup tasks Idle
Streams AQ: delete acknowledged messages Idle
Streams AQ: deallocate messages from Streams Pool Idle
Streams AQ: qmn coordinator idle wait Idle
Streams AQ: qmn slave idle wait Idle
Streams AQ: RAC qmn coordinator idle wait Idle
HS message to agent Idle
ASM background timer Idle
auto-sqltune: wait graph update Idle
WCR: replay client notify Idle
WCR: replay clock Idle
WCR: replay paused Idle
JS external job Idle
cell worker idle Idle
pmon timer Idle
VKTM Logical Idle Wait Idle
VKTM Init Wait for GSGA Idle
IORM Scheduler Slave Idle Wait Idle
rdbms ipc message Idle
i/o slave wait Idle
VKRM Idle Idle
wait for unread message on broadcast channel Idle
wait for unread message on multiple broadcast channels Idle
class slave wait Idle
KSV master wait Idle
PING Idle
watchdog main loop Idle
DIAG idle wait Idle
ges remote message Idle
gcs remote message Idle
heartbeat monitor sleep Idle
GCR sleep Idle
SGA: MMAN sleep for component shrink Idle
MRP redo arrival Idle
LNS ASYNC archive log Idle
LNS ASYNC dest activation Idle
LNS ASYNC end of log Idle
simulated log write delay Idle
LGWR real time apply sync Idle
parallel recovery slave idle wait Idle
LogMiner builder: idle Idle
LogMiner builder: branch Idle
LogMiner preparer: idle Idle
LogMiner reader: log (idle) Idle
LogMiner reader: redo (idle) Idle
LogMiner client: transaction Idle
LogMiner: other Idle
LogMiner: activate Idle
LogMiner: reset Idle
LogMiner: find session Idle
LogMiner: internal Idle
Logical Standby Apply Delay Idle
parallel recovery coordinator waits for slave cleanup Idle
parallel recovery control message reply Idle
parallel recovery slave next change Idle
PX Deq: Txn Recovery Start Idle
PX Deq: Txn Recovery Reply Idle
fbar timer Idle
smon timer Idle
PX Deq: Metadata Update Idle
Space Manager: slave idle wait Idle
PX Deq: Index Merge Reply Idle
PX Deq: Index Merge Execute Idle
PX Deq: Index Merge Close Idle
PX Deq: kdcph_mai Idle
PX Deq: kdcphc_ack Idle
virtual circuit next request Idle
shared server idle wait Idle
dispatcher timer Idle
cmon timer Idle
pool server timer Idle
JOX Jit Process Sleep Idle
jobq slave wait Idle
pipe get Idle
PX Deque wait Idle
PX Idle Wait Idle
PX Deq: Join ACK Idle
PX Deq Credit: need buffer Idle
remote db operation Network
TEXT: URL_DATASTORE network wait Network
remote db file write Network
ARCH wait for net re-connect Network
LGWR wait on ATTACH Network
ARCH wait on ATTACH Network
ARCH wait for netserver start Network
LNS wait on ATTACH Network
LNS wait on SENDREQ Network
LNS wait on DETACH Network
LGWR wait on SENDREQ Network
LGWR wait on DETACH Network
ARCH wait on SENDREQ Network
ARCH wait on DETACH Network
ARCH wait for netserver init 2 Network
LNS wait on LGWR Network
LGWR wait on LNS Network
ARCH wait for flow-control Network
ARCH wait for netserver detach Network
TCP Socket (KGAS) Network
virtual circuit wait Network
dispatcher listen timer Network
dedicated server timer Network
SQL*Net message to client Network
SQL*Net message to dblink Network
SQL*Net more data to client Network
SQL*Net more data to dblink Network
SQL*Net more data from client Network
SQL*Net message from dblink Network
SQL*Net more data from dblink Network
SQL*Net vector data to client Network
SQL*Net vector data from client Network
SQL*Net vector data to dblink Network
SQL*Net vector data from dblink Network
remote db file read Network
null event Other
events in waitclass Other Other
enq: WM - WLM Plan activation Other
latch free Other
kslwait unit test event 1 Other
kslwait unit test event 2 Other
kslwait unit test event 3 Other
unspecified wait event Other
latch activity Other
wait list latch activity Other
wait list latch free Other
global enqueue expand wait Other
free process state object Other
inactive session Other
process terminate Other
latch: call allocation Other
latch: session allocation Other
check CPU wait times Other
enq: CI - contention Other
enq: PR - contention Other
enq: AK - contention Other
enq: DI - contention Other
enq: RM - contention Other
enq: BO - contention Other
ksim generic wait event Other
debugger command Other
ksdxexeother Other
ksdxexeotherwait Other
enq: PE - contention Other
enq: PG - contention Other
ksbsrv Other
ksbcic Other
process startup Other
process shutdown Other
prior spawner clean up Other
latch: messages Other
rdbms ipc message block Other
rdbms ipc reply Other
latch: enqueue hash chains Other
enq: FP - global fob contention Other
enq: RE - block repair contention Other
enq: BM - clonedb bitmap file write Other
asynch descriptor resize Other
imm op Other
slave exit Other
enq: KM - contention Other
enq: KT - contention Other
enq: CA - contention Other
enq: KD - determine DBRM master Other
reliable message Other
broadcast mesg queue transition Other
broadcast mesg recovery queue transition Other
master exit Other
ksv slave avail wait Other
enq: PV - syncstart Other
enq: PV - syncshut Other
enq: SP - contention 1 Other
enq: SP - contention 2 Other
enq: SP - contention 3 Other
enq: SP - contention 4 Other
enq: SX - contention 5 Other
enq: SX - contention 6 Other
first spare wait event Other
second spare wait event Other
IPC send completion sync Other
OSD IPC library Other
IPC wait for name service busy Other
IPC busy async request Other
IPC waiting for OSD resources Other
ksxr poll remote instances Other
ksxr wait for mount shared Other
DBMS_LDAP: LDAP operation Other
wait for FMON to come up Other
enq: FM - contention Other
enq: XY - contention Other
set director factor wait Other
latch: active service list Other
enq: AS - service activation Other
enq: PD - contention Other
cleanup of aborted process Other
enq: RU - contention Other
enq: RU - waiting Other
rolling migration: cluster quiesce Other
LMON global data update Other
process diagnostic dump Other
enq: MX - sync storage server info Other
master diskmon startup Other
master diskmon read Other
DSKM to complete cell health check Other
pmon dblkr tst event Other
enq: ZX - repopulation file write Other
latch: ges resource hash list Other
DFS lock handle Other
ges LMD to shutdown Other
ges client process to exit Other
ges global resource directory to be frozen Other
ges resource directory to be unfrozen Other
gcs resource directory to be unfrozen Other
ges LMD to inherit communication channels Other
ges lmd sync during reconfig Other
ges wait for lmon to be ready Other
ges cgs registration Other
wait for master scn Other
ges yield cpu in reconfig Other
ges2 proc latch in rm latch get 1 Other
ges2 proc latch in rm latch get 2 Other
ges lmd/lmses to freeze in rcfg Other
ges lmd/lmses to unfreeze in rcfg Other
ges lms sync during dynamic remastering and reconfig Other
ges LMON to join CGS group Other
ges pmon to exit Other
ges lmd and pmon to attach Other
gcs drm freeze begin Other
gcs retry nowait latch get Other
gcs remastering wait for read latch Other
ges cached resource cleanup Other
ges generic event Other
ges retry query node Other
ges process with outstanding i/o Other
ges user error Other
ges enter server mode Other
gcs enter server mode Other
gcs drm freeze in enter server mode Other
gcs ddet enter server mode Other
ges cancel Other
ges resource cleanout during enqueue open Other
ges resource cleanout during enqueue open-cvt Other
ges master to get established for SCN op Other
ges LMON to get to FTDONE 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
ges inquiry response Other
ges reusing os pid Other
ges LMON for send queues Other
ges LMD suspend for testing event Other
ges performance test completion Other
kjbopen wait for recovery domain attach Other
kjudomatt wait for recovery domain attach Other
kjudomdet wait for recovery domain detach Other
kjbdomalc allocate recovery domain - retry Other
kjbdrmcvtq lmon drm quiesce: ping completion Other
ges RMS0 retry add redo log Other
readable standby redo apply remastering Other
ges DFS hang analysis phase 2 acks Other
ges/gcs diag dump Other
global plug and play automatic resource creation Other
gcs lmon dirtydetach step completion Other
recovery instance recovery completion Other
ack for a broadcasted res from a remote instance Other
KJC: Wait for msg sends to complete Other
ges message buffer allocation Other
kjctssqmg: quick message send wait Other
kjctcisnd: Queue/Send client message Other
gcs domain validation Other
latch: gcs resource hash Other
affinity expansion in replay Other
wait for sync ack Other
wait for verification ack Other
wait for assert messages to be sent Other
wait for scn ack Other
lms flush message acks Other
name-service call wait Other
CGS wait for IPC msg Other
kjxgrtest Other
IMR mount phase II completion Other
IMR disk votes Other
IMR rr lock release Other
IMR net-check message ack Other
IMR rr update Other
IMR membership resolution Other
IMR CSS join retry Other
CGS skgxn join retry Other
gcs to be enabled Other
gcs log flush sync Other
GCR ctx lock acquisition Other
GCR lock acquisition Other
GCR CSS join retry Other
GCR member Data from CSS Other
SGA: allocation forcing component growth Other
SGA: sga_target resize Other
enq: SC - contention Other
control file heartbeat Other
control file diagnostic dump Other
enq: CF - contention Other
enq: SW - contention Other
enq: DS - contention Other
enq: TC - contention Other
enq: TC - contention2 Other
buffer exterminate Other
buffer resize Other
latch: cache buffers lru chain Other
enq: PW - perwarm status in dbw0 Other
latch: checkpoint queue latch Other
latch: cache buffer handles Other
kcbzps Other
DBWR range invalidation sync Other
buffer deadlock Other
buffer latch Other
cr request retry Other
writes stopped by instance recovery or database suspension Other
lock escalate retry Other
lock deadlock retry Other
prewarm transfer retry Other
recovery buffer pinned Other
TSE master key rekey Other
TSE SSO wallet reopen Other
force-cr-override flush Other
enq: CR - block range reuse ckpt Other
wait for MTTR advisory state object Other
latch: object queue header operation Other
Wait on stby instance close Other
ARCH wait for archivelog lock Other
enq: WL - Test access/locking Other
FAL archive wait 1 sec for REOPEN minimum Other
TEST: action sync Other
TEST: action hang Other
RSGA: RAC reconfiguration Other
enq: WL - RAC-wide SGA contention Other
LGWR ORL/NoExp FAL archival Other
enq: WS - contention Other
MRP wait on process start Other
MRP wait on process restart Other
MRP wait on startup clear Other
MRP inactivation Other
MRP termination Other
MRP state inspection Other
MRP wait on archivelog arrival Other
MRP wait on archivelog archival Other
log switch/archive Other
ARCH wait on c/f tx acquire 1 Other
RFS attach Other
RFS create Other
RFS close Other
RFS announce Other
RFS register Other
RFS detach Other
RFS ping Other
RFS dispatch Other
enq: WL - RFS global state contention Other
LGWR simulation latency wait Other
LNS simulation latency wait Other
Data Guard: RFS disk I/O Other
ARCH wait for process start 1 Other
ARCH wait for process death 1 Other
ARCH wait for process start 3 Other
Data Guard: process exit Other
Data Guard: process clean up Other
LGWR-LNS wait on channel Other
enq: WR - contention Other
Image redo gen delay Other
LGWR wait for redo copy Other
latch: redo allocation Other
log file switch (clearing log file) Other
enq: WL - contention Other
enq: RN - contention Other
DFS db file lock Other
enq: DF - contention Other
enq: IS - contention Other
enq: FS - contention Other
enq: DM - contention Other
enq: RP - contention Other
latch: gc element Other
enq: RT - contention Other
enq: RT - thread internal enable/disable Other
enq: IR - contention Other
enq: IR - contention2 Other
enq: MR - contention Other
enq: MR - standby role transition Other
enq: MR - datafile online Other
shutdown after switchover to standby Other
parallel recovery coord wait for reply Other
parallel recovery coord send blocked Other
parallel recovery slave wait for change Other
enq: BR - file shrink Other
enq: BR - proxy-copy Other
enq: BR - multi-section restore header Other
enq: BR - multi-section restore section Other
enq: BR - space info datafile hdr update Other
enq: BR - request autobackup Other
enq: BR - perform autobackup Other
enq: ID - contention Other
Backup Restore Throttle sleep Other
Backup Restore Switch Bitmap sleep Other
Backup Restore Event 19778 sleep Other
enq: BS - krb spare1 Other
enq: BS - krb spare2 Other
enq: BS - krb spare3 Other
enq: BS - krb spare4 Other
enq: BS - krb spare5 Other
enq: BS - krb spare6 Other
enq: BS - krb spare7 Other
enq: BS - krb spare8 Other
enq: BS - krb spare9 Other
enq: BS - krb spare0 Other
enq: AB - ABMR process start/stop Other
enq: AB - ABMR process initialized Other
Auto BMR completion Other
Auto BMR RPC standby catchup Other
enq: MN - contention Other
enq: PL - contention Other
enq: SB - logical standby metadata Other
enq: SB - table instantiation Other
Logical Standby Apply shutdown Other
Logical Standby pin transaction Other
Logical Standby dictionary build Other
Logical Standby Terminal Apply Other
Logical Standby Debug Other
Resolution of in-doubt txns Other
enq: XR - quiesce database Other
enq: XR - database force logging Other
standby query scn advance Other
change tracking file synchronous read Other
change tracking file synchronous write Other
change tracking file parallel write Other
block change tracking buffer space Other
CTWR media recovery checkpoint request Other
enq: CT - global space management Other
enq: CT - local space management Other
enq: CT - change stream ownership Other
enq: CT - state Other
enq: CT - state change gate 1 Other
enq: CT - state change gate 2 Other
enq: CT - CTWR process start/stop Other
enq: CT - reading Other
recovery area: computing dropped files Other
recovery area: computing obsolete files Other
recovery area: computing backed up files Other
recovery area: computing applied logs Other
enq: RS - file delete Other
enq: RS - record reuse Other
enq: RS - prevent file delete Other
enq: RS - prevent aging list update Other
enq: RS - persist alert level Other
enq: RS - read alert level Other
enq: RS - write alert level Other
enq: FL - Flashback database log Other
enq: FL - Flashback db command Other
enq: FD - Marker generation Other
enq: FD - Tablespace flashback on/off Other
enq: FD - Flashback coordinator Other
enq: FD - Flashback on/off Other
enq: FD - Restore point create/drop Other
enq: FD - Flashback logical operations Other
flashback free VI log Other
flashback log switch Other
enq: FW - contention Other
RVWR wait for flashback copy Other
parallel recovery read buffer free Other
parallel recovery change buffer free Other
cell smart flash unkeep Other
datafile move cleanup during resize Other
blocking txn id for DDL Other
transaction Other
inactive transaction branch Other
txn to complete Other
PMON to cleanup pseudo-branches at svc stop time Other
PMON to cleanup detached branches at shutdown Other
test long ops Other
latch: undo global data Other
undo segment recovery Other
unbound tx Other
wait for change Other
wait for another txn - undo rcv abort Other
wait for another txn - txn abort Other
wait for another txn - rollback to savepoint Other
undo_retention publish retry Other
enq: TA - contention Other
enq: TX - contention Other
enq: US - contention Other
wait for stopper event to be increased Other
wait for a undo record Other
wait for a paralle reco to abort Other
enq: IM - contention for blr Other
enq: TD - KTF dump entries Other
enq: TE - KTF broadcast Other
enq: CN - race with txn Other
enq: CN - race with reg Other
enq: CN - race with init Other
latch: Change Notification Hash table latch Other
enq: CO - master slave det Other
enq: FE - contention Other
latch: change notification client cache latch Other
enq: TF - contention Other
latch: lob segment hash table latch Other
latch: lob segment query latch Other
latch: lob segment dispenser latch Other
Wait for shrink lock2 Other
Wait for shrink lock Other
L1 validation Other
Wait for TT enqueue Other
kttm2d Other
ktsambl Other
ktfbtgex Other
enq: DT - contention Other
enq: TS - contention Other
enq: FB - contention Other
enq: SK - contention Other
enq: DW - contention Other
enq: SU - contention Other
enq: TT - contention Other
ktm: instance recovery Other
instance state change Other
enq: SM - contention Other
enq: SJ - Slave Task Cancel Other
Space Manager: slave messages Other
enq: SV - contention Other
index block split Other
kdblil wait before retrying ORA-54 Other
dupl. cluster key Other
kdic_do_merge Other
enq: DL - contention Other
enq: HQ - contention Other
enq: HP - contention Other
enq: KL - contention Other
enq: WG - delete fso Other
enq: SL - get lock Other
enq: SL - escalate lock Other
enq: SL - get lock for undo Other
enq: ZH - compression analysis Other
Compression analysis Other
row cache cleanup Other
row cache process Other
enq: QA - contention Other
enq: QB - contention Other
enq: QC - contention Other
enq: QD - contention Other
enq: QE - contention Other
enq: QF - contention Other
enq: QG - contention Other
enq: QH - contention Other
enq: QI - contention Other
enq: QJ - contention Other
enq: QK - contention Other
enq: QL - contention Other
enq: QM - contention Other
enq: QN - contention Other
enq: QO - contention Other
enq: QP - contention Other
enq: QQ - contention Other
enq: QR - contention Other
enq: QS - contention Other
enq: QT - contention Other
enq: QU - contention Other
enq: QV - contention Other
enq: QX - contention Other
enq: QY - contention Other
enq: QZ - contention Other
enq: DV - contention Other
enq: SO - contention Other
enq: VA - contention Other
enq: VB - contention Other
enq: VC - contention Other
enq: VD - contention Other
enq: VE - contention Other
enq: VF - contention Other
enq: VG - contention Other
enq: VH - contention Other
enq: VI - contention Other
enq: VJ - contention Other
enq: VK - contention Other
enq: VL - contention Other
enq: VM - contention Other
enq: VN - contention Other
enq: VO - contention Other
enq: VP - contention Other
enq: VQ - contention Other
enq: VR - contention Other
enq: VS - contention Other
enq: VT - contention Other
enq: VU - contention Other
enq: VV - contention Other
enq: VX - contention Other
enq: VY - contention Other
enq: VZ - contention Other
enq: EA - contention Other
enq: EB - contention Other
enq: EC - contention Other
enq: ED - contention Other
enq: EE - contention Other
enq: EF - contention Other
enq: EG - contention Other
enq: EH - contention Other
enq: EI - contention Other
enq: EJ - contention Other
enq: EK - contention Other
enq: EL - contention Other
enq: EM - contention Other
enq: EN - contention Other
enq: EO - contention Other
enq: EP - contention Other
enq: EQ - contention Other
enq: ER - contention Other
enq: ES - contention Other
enq: ET - contention Other
enq: EU - contention Other
enq: EV - contention Other
enq: EX - contention Other
enq: EY - contention Other
enq: EZ - contention Other
enq: LA - contention Other
enq: LB - contention Other
enq: LC - contention Other
enq: LD - contention Other
enq: LE - contention Other
enq: LF - contention Other
enq: LG - contention Other
enq: LH - contention Other
enq: LI - contention Other
enq: LJ - contention Other
enq: LK - contention Other
enq: LL - contention Other
enq: LM - contention Other
enq: LN - contention Other
enq: LO - contention Other
enq: LP - contention Other
enq: LQ - contention Other
enq: LR - contention Other
enq: LS - contention Other
enq: LT - contention Other
enq: LU - contention Other
enq: LV - contention Other
enq: LX - contention Other
enq: LY - contention Other
enq: LZ - contention Other
enq: YA - contention Other
enq: YB - contention Other
enq: YC - contention Other
enq: YD - contention Other
enq: YE - contention Other
enq: YF - contention Other
enq: YG - contention Other
enq: YH - contention Other
enq: YI - contention Other
enq: YJ - contention Other
enq: YK - contention Other
enq: YL - contention Other
enq: YM - contention Other
enq: YN - contention Other
enq: YO - contention Other
enq: YP - contention Other
enq: YQ - contention Other
enq: YR - contention Other
enq: YS - contention Other
enq: YT - contention Other
enq: YU - contention Other
enq: YV - contention Other
enq: YX - contention Other
enq: YY - contention Other
enq: YZ - contention Other
enq: GA - contention Other
enq: GB - contention Other
enq: GC - contention Other
enq: GD - contention Other
enq: GE - contention Other
enq: GF - contention Other
enq: GG - contention Other
enq: GH - contention Other
enq: GI - contention Other
enq: GJ - contention Other
enq: GK - contention Other
enq: GL - contention Other
enq: GM - contention Other
enq: GN - contention Other
enq: GO - contention Other
enq: GP - contention Other
enq: GQ - contention Other
enq: GR - contention Other
enq: GS - contention Other
enq: GT - contention Other
enq: GU - contention Other
enq: GV - contention Other
enq: GX - contention Other
enq: GY - contention Other
enq: GZ - contention Other
enq: NA - contention Other
enq: NB - contention Other
enq: NC - contention Other
enq: ND - contention Other
enq: NE - contention Other
enq: NF - contention Other
enq: NG - contention Other
enq: NH - contention Other
enq: NI - contention Other
enq: NJ - contention Other
enq: NK - contention Other
enq: NL - contention Other
enq: NM - contention Other
enq: NN - contention Other
enq: NO - contention Other
enq: NP - contention Other
enq: NQ - contention Other
enq: NR - contention Other
enq: NS - contention Other
enq: NT - contention Other
enq: NU - contention Other
enq: NV - contention Other
enq: NX - contention Other
enq: NY - contention Other
enq: NZ - contention Other
enq: IV - contention Other
enq: TP - contention Other
enq: RW - MV metadata contention Other
enq: OC - contention Other
enq: OL - contention Other
kkdlgon Other
kkdlsipon Other
kkdlhpon Other
kgltwait Other
kksfbc research Other
kksscl hash split Other
kksfbc child completion Other
enq: CU - contention Other
enq: AE - lock Other
enq: PF - contention Other
enq: IL - contention Other
enq: CL - drop label Other
enq: CL - compare labels Other
enq: MK - contention Other
enq: OW - initialization Other
enq: OW - termination Other
enq: RK - set key Other
enq: RL - RAC wallet lock Other
enq: ZZ - update hash tables Other
enq: ZA - add std audit table partition Other
enq: ZF - add fga audit table partition Other
enq: DX - contention Other
enq: DR - contention Other
pending global transaction(s) Other
free global transaction table entry Other
library cache revalidation Other
library cache shutdown Other
BFILE closure Other
BFILE check if exists Other
BFILE check if open Other
BFILE get length Other
BFILE get name object Other
BFILE get path object Other
BFILE open Other
BFILE internal seek Other
waiting to get CAS latch Other
waiting to get RM CAS latch Other
resmgr:internal state cleanup Other
xdb schema cache initialization Other
ASM cluster file access Other
CSS initialization Other
CSS group registration Other
CSS group membership query Other
CSS operation: data query Other
CSS operation: data update Other
CSS Xgrp shared operation Other
CSS operation: query Other
CSS operation: action Other
CSS operation: diagnostic Other
GIPC operation: dump Other
GPnP Initialization Other
GPnP Termination Other
GPnP Get Item Other
GPnP Set Item Other
GPnP Get Error Other
ADR file lock Other
ADR block file read Other
ADR block file write Other
CRS call completion Other
dispatcher shutdown Other
listener registration dump Other
latch: virtual circuit queues Other
listen endpoint status Other
OJVM: Generic Other
select wait Other
jobq slave shutdown wait Other
jobq slave TJ process wait Other
job scheduler coordinator slave wait Other
enq: JD - contention Other
enq: JQ - contention Other
enq: OD - Serializing DDLs Other
RAC referential constraint parent lock Other
kkshgnc reloop Other
optimizer stats update retry Other
wait active processes Other
SUPLOG PL wait for inflight pragma-d PL/SQL Other
enq: MD - contention Other
enq: MS - contention Other
wait for kkpo ref-partitioning *TEST EVENT* Other
enq: AP - contention Other
PX slave connection Other
PX slave release Other
PX Send Wait Other
PX qref latch Other
PX server shutdown Other
PX create server Other
PX signal server Other
PX Deq Credit: free buffer Other
PX Deq: Test for msg Other
PX Deq: Test for credit Other
PX Deq: Signal ACK RSG Other
PX Deq: Signal ACK EXT Other
PX Deq: reap credit Other
PX Nsq: PQ descriptor query Other
PX Nsq: PQ load info query Other
PX Deq Credit: Session Stats Other
PX Deq: Slave Session Stats Other
PX Deq: Slave Join Frag Other
enq: PI - contention Other
enq: PS - contention Other
latch: parallel query alloc buffer Other
kxfxse Other
kxfxsp Other
PX Deq: Table Q qref Other
PX Deq: Table Q Get Keys Other
PX Deq: Table Q Close Other
GV$: slave acquisition retry wait time Other
PX hash elem being inserted Other
latch: PX hash array latch Other
enq: AY - contention Other
enq: TO - contention Other
enq: IT - contention Other
enq: BF - allocation contention Other
enq: BF - PMON Join Filter cleanup Other
enq: RD - RAC load Other
timer in sksawat Other
scginq AST call Other
kupp process wait Other
Kupp process shutdown Other
Data Pump slave startup Other
Data Pump slave init Other
enq: KP - contention Other
Replication Dequeue Other
knpc_acwm_AwaitChangedWaterMark Other
knpc_anq_AwaitNonemptyQueue Other
knpsmai Other
enq: SR - contention Other
Streams capture: waiting for database startup Other
Streams miscellaneous event Other
enq: SI - contention Other
Streams: RAC waiting for inter instance ack Other
enq: IA - contention Other
enq: JI - contention Other
qerex_gdml Other
enq: AT - contention Other
opishd Other
kpodplck wait before retrying ORA-54 Other
enq: CQ - contention Other
Streams AQ: emn coordinator waiting for slave to start Other
wait for EMON to spawn Other
EMON termination Other
EMON slave messages Other
enq: SE - contention Other
tsm with timeout Other
Streams AQ: waiting for busy instance for instance_name Other
enq: TQ - TM contention Other
enq: TQ - DDL contention Other
enq: TQ - INI contention Other
enq: TQ - DDL-INI contention Other
AQ propagation connection Other
enq: DP - contention Other
enq: MH - contention Other
enq: ML - contention Other
enq: PH - contention Other
enq: SF - contention Other
enq: XH - contention Other
enq: WA - contention Other
Streams AQ: QueueTable kgl locks Other
AQ spill debug idle Other
queue slave messages Other
Streams AQ: qmn coordinator waiting for slave to start Other
enq: CX - TEXT: Index Specific Lock Other
enq: OT - TEXT: Generic Lock Other
XDB SGA initialization Other
enq: XC - XDB Configuration Other
NFS read delegation outstanding Other
Data Guard Broker Wait Other
enq: RF - synch: DG Broker metadata Other
enq: RF - atomicity Other
enq: RF - synchronization: aifo master Other
enq: RF - new AI Other
enq: RF - synchronization: critical ai Other
enq: RF - RF - Database Automatic Disable Other
enq: RF - FSFO Observer Heartbeat Other
enq: RF - DG Broker Current File ID Other
enq: RF - FSFO Primary Shutdown suspended Other
PX Deq: OLAP Update Reply Other
PX Deq: OLAP Update Execute Other
PX Deq: OLAP Update Close Other
OLAP Parallel Type Deq Other
OLAP Parallel Temp Grow Request Other
OLAP Parallel Temp Grow Wait Other
OLAP Parallel Temp Grew Other
OLAP Null PQ Reason Other
OLAP Aggregate Master Enq Other
OLAP Aggregate Client Enq Other
OLAP Aggregate Master Deq Other
OLAP Aggregate Client Deq Other
enq: AW - AW$ table lock Other
enq: AW - AW state lock Other
enq: AW - user access for AW Other
enq: AW - AW generation lock Other
enq: AG - contention Other
enq: AO - contention Other
enq: OQ - xsoqhiAlloc Other
enq: OQ - xsoqhiFlush Other
enq: OQ - xsoq*histrecb Other
enq: OQ - xsoqhiClose Other
enq: OQ - xsoqhistrecb Other
enq: IZ - contention Other
enq: AM - client registration Other
enq: AM - shutdown Other
enq: AM - rollback COD reservation Other
enq: AM - background COD reservation Other
enq: AM - ASM cache freeze Other
enq: AM - ASM ACD Relocation Other
enq: AM - group use Other
enq: AM - group block Other
enq: AM - ASM File Destroy Other
enq: AM - ASM User Other
enq: AM - ASM Password File Update Other
enq: AM - ASM Amdu Dump Other
enq: AM - disk offline Other
enq: AM - ASM reserved Other
enq: AM - block repair Other
enq: AM - ASM disk based alloc/dealloc Other
enq: AM - ASM file descriptor Other
enq: AM - ASM file relocation Other
enq: AM - ASM Grow ACD Other
enq: AM - ASM DD update SrRloc Other
ASM internal hang test Other
ASM Instance startup Other
buffer busy Other
buffer freelistbusy Other
buffer rememberlist busy Other
buffer writeList full Other
no free buffers Other
buffer write wait Other
buffer invalidation wait Other
buffer dirty disabled Other
ASM metadata cache frozen Other
enq: FZ - contention Other
enq: CM - gate Other
enq: CM - instance Other
enq: CM - diskgroup dismount Other
enq: XQ - recovery Other
enq: XQ - relocation Other
enq: XQ - purification Other
enq: AD - allocate AU Other
enq: AD - deallocate AU Other
enq: AD - relocate AU Other
enq: DO - disk online Other
enq: DO - disk online recovery Other
enq: DO - Staleness Registry create Other
enq: DO - startup of MARK process Other
enq: DO - disk online operation Other
extent map load/unlock Other
enq: XL - fault extent map Other
Sync ASM rebalance Other
enq: DG - contention Other
enq: DD - contention Other
enq: HD - contention Other
enq: DQ - contention Other
enq: DN - contention Other
Cluster stabilization wait Other
Cluster Suspension wait Other
ASM background starting Other
ASM db client exists Other
ASM file metadata operation Other
ASM network foreground exits Other
enq: XB - contention Other
enq: FA - access file Other
enq: RX - relocate extent Other
enq: RX - unlock extent Other
enq: AR - contention Other
log write(odd) Other
log write(even) Other
checkpoint advanced Other
enq: FR - contention Other
enq: FR - use the thread Other
enq: FR - recover the thread Other
enq: FG - serialize ACD relocate Other
enq: FG - FG redo generation enq race Other
enq: FG - LGWR redo generation enq race Other
enq: FT - allow LGWR writes Other
enq: FT - disable LGWR writes Other
enq: FC - open an ACD thread Other
enq: FC - recover an ACD thread Other
enq: FX - issue ACD Xtnt Relocation CIC Other
rollback operations block full Other
rollback operations active Other
enq: RB - contention Other
ASM: MARK subscribe to msg channel Other
enq: PT - contention Other
enq: PM - contention Other
ASM PST operation Other
global cache busy Other
lock release pending Other
dma prepare busy Other
GCS lock cancel Other
GCS lock open S Other
GCS lock open X Other
GCS lock open Other
GCS lock cvt S Other
GCS lock cvt X Other
GCS lock esc X Other
GCS lock esc Other
GCS recovery lock open Other
GCS recovery lock convert Other
kfcl: instance recovery Other
no free locks Other
lock close Other
enq: KE - contention Other
enq: KQ - access ASM attribute Other
ASM Volume Background Other
ASM DG Unblock Other
enq: AV - persistent DG number Other
enq: AV - volume relocate Other
enq: AV - AVD client registration Other
enq: AV - add/enable first volume in DG Other
ASM: OFS Cluster membership update Other
enq: WF - contention Other
enq: WP - contention Other
enq: FU - contention Other
enq: MW - contention Other
AWR Flush Other
AWR Metric Capture Other
enq: TB - SQL Tuning Base Cache Update Other
enq: TB - SQL Tuning Base Cache Load Other
enq: SH - contention Other
enq: AF - task serialization Other
MMON slave messages Other
MMON (Lite) shutdown Other
enq: MO - contention Other
enq: TL - contention Other
enq: TH - metric threshold evaluation Other
enq: TK - Auto Task Serialization Other
enq: TK - Auto Task Slave Lockout Other
enq: RR - contention Other
WCR: RAC message context busy Other
WCR: capture file IO write Other
WCR: Sync context busy Other
latch: WCR: sync Other
latch: WCR: processes HT Other
enq: JS - contention Other
enq: JS - job run lock - synchronize Other
enq: JS - job recov lock Other
enq: JS - queue lock Other
enq: JS - sch locl enqs Other
enq: JS - q mem clnup lck Other
enq: JS - evtsub add Other
enq: JS - evtsub drop Other
enq: JS - wdw op Other
enq: JS - evt notify Other
enq: JS - aq sync Other
enq: XD - ASM disk drop/add Other
enq: XD - ASM disk ONLINE Other
enq: XD - ASM disk OFFLINE Other
cell worker online completion Other
cell worker retry Other
cell manager cancel work request Other
secondary event Other
LogMiner builder: memory Queueing
LogMiner builder: DDL Queueing
LogMiner preparer: memory Queueing
LogMiner reader: buffer Queueing
Streams AQ: enqueue blocked due to flow control Queueing
Streams: resolve low memory condition Queueing
Streams: flow control Queueing
Streams AQ: enqueue blocked on low memory Queueing
Streams capture: waiting for subscribers to catch up Queueing
resmgr:small I/O queued Scheduler
resmgr:large I/O queued Scheduler
resmgr:cpu quantum Scheduler
PX Queuing: statement queue Scheduler
enq: JX - cleanup of queue Scheduler
enq: JX - SQL statement queue Scheduler
resmgr:pq queued Scheduler
resmgr:become active Scheduler
DBWR slave I/O System I/O
LGWR slave I/O System I/O
Archiver slave I/O System I/O
File Repopulation Write System I/O
control file sequential read System I/O
control file single write System I/O
control file parallel write System I/O
recovery read System I/O
RFS sequential i/o System I/O
RFS random i/o System I/O
RFS write System I/O
log file sequential read System I/O
log file single write System I/O
log file parallel write System I/O
db file parallel write System I/O
db file async I/O submit System I/O
flashback log file write System I/O
flashback log file read System I/O
cell smart incremental backup System I/O
cell smart restore from backup System I/O
kfk: async disk IO System I/O
cell manager opening cell System I/O
cell manager closing cell System I/O
RMAN Tape slave I/O System I/O
RMAN Disk slave I/O System I/O
io done System I/O
Network file transfer System I/O
Standby redo I/O System I/O
RMAN backup & recovery I/O System I/O
cell manager discovering disks System I/O
Clonedb bitmap file write System I/O
Log archive I/O System I/O
Parameter File I/O User I/O
cell list of blocks physical read User I/O
Disk file I/O Calibration User I/O
Disk file Mirror Read User I/O
Disk file Mirror/Media Repair Write User I/O
direct path sync User I/O
Datapump dump file I/O User I/O
dbms_file_transfer I/O User I/O
DG Broker configuration file I/O User I/O
Data file init write User I/O
Log file init write User I/O
Shared IO Pool IO Completion User I/O
local write wait User I/O
buffer read retry User I/O
read by other session User I/O
db flash cache single block physical read User I/O
db flash cache multiblock physical read User I/O
db flash cache write User I/O
db file sequential read User I/O
db file scattered read User I/O
db file single write User I/O
db file parallel read User I/O
direct path read User I/O
direct path read temp User I/O
direct path write User I/O
direct path write temp User I/O
flashback log file sync User I/O
cell smart table scan User I/O
cell smart index scan User I/O
cell statistics gather User I/O
cell smart file creation User I/O
Archive Manager file transfer I/O User I/O
securefile direct-read completion User I/O
securefile direct-write completion User I/O
BFILE read User I/O
utl_file I/O User I/O
external table read User I/O
external table write User I/O
external table open User I/O
external table seek User I/O
external table misc IO User I/O
dbverify reads User I/O
TEXT: File System I/O User I/O
ASM Fixed Package I/O User I/O
ASM Staleness File I/O User I/O
cell single block physical read User I/O
cell multiblock physical read User I/O
Disk file operations I/O User I/O
1367 rows selected.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28697282/viewspace-1581921/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28697282/viewspace-1581921/

congtangguan9702

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
oracle wait events(等待事件) 一览表

在oracle出现性能问题时，通过等待事件，非常有助于我们去分析问题。在oracle的每个大的版本里面，都会增加或者删除一些等待事件。我们可以通过查询v$event_name查看所有的等待事件(wait eve...
复制链接

扫一扫