美创科技技术社区

注册

 

发新话题 回复该主题

Oracle wait Event信息 [复制链接]

1#
Oracle wait event是极为重要的性能诊断和优化途径,理解并且处理oracle wait Event是一个性能DBA的主要任务,通过对于Wait的处理,可以解决绝大部分性能问题,并且相对比较快。

在视图v$event_name中对于Wait event进行了描述:
SQL> desc v$event_name
Name          Type         Nullable Default Comments
————- ———— ——– ——- ——–
EVENT#        NUMBER       Y
EVENT_ID      NUMBER       Y
NAME          VARCHAR2(64) Y
PARAMETER1    VARCHAR2(64) Y
PARAMETER2    VARCHAR2(64) Y
PARAMETER3    VARCHAR2(64) Y
WAIT_CLASS_ID NUMBER       Y
WAIT_CLASS#   NUMBER       Y
WAIT_CLASS    VARCHAR2(64) Y
以下语句获得等待事件和分类:
select wait_class,event from v$event_name;
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
null event                                                       Other
pmon timer                                                       Idle
logout restrictor                                                Concurrency
rdbms ipc message                                                Idle
kst: async disk IO                                               System I/O
ksfd: async disk IO                                              System 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
Log archive I/O                                                  System I/O
RMAN backup & recovery I/O                                       System I/O
Standby redo I/O                                                 System I/O
Backup: sbtinit                                                  Administrative
Backup: sbtopen                                                  Administrative
Backup: sbtread                                                  Administrative
Backup: sbtwrite                                                 Administrative
Backup: sbtclose                                                 Administrative
Backup: sbtinfo                                                  Administrative
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
Backup: sbtremove                                                Administrative
Backup: sbtbackup                                                Administrative
Backup: sbtclose2                                                Administrative
Backup: sbtcommand                                               Administrative
Backup: sbtend                                                   Administrative
Backup: sbterror                                                 Administrative
Backup: sbtinfo2                                                 Administrative
Backup: sbtinit2                                                 Administrative
Backup: sbtread2                                                 Administrative
Backup: sbtremove2                                               Administrative
Backup: sbtrestore                                               Administrative
Backup: sbtwrite2                                                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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
Backup: sbtpcvalidate                                            Administrative
io done                                                          System I/O
i/o slave wait                                                   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
os thread startup                                                Concurrency
watchdog main loop                                               Idle
DIAG idle wait                                                   Idle
ges remote message                                               Idle
gcs remote message                                               Idle
SGA: MMAN sleep for component shrink                             Idle
retry contact SCN lock master                                    Cluster
control file sequential read                                     System I/O
control file single write                                        System I/O
control file parallel write                                      System I/O
enq: PW – flush prewarm buffers                                  Application
latch: cache buffers chains                                      Concurrency
free buffer waits                                                Configuration
local write wait                                                 User I/O
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
checkpoint completed                                             Configuration
write complete waits                                             Configuration
buffer read retry                                                User I/O
buffer busy waits                                                Concurrency
gc buffer busy                                                   Cluster
read by other session                                            User I/O
multiple dbwriter suspend/resume for file offline                Administrative
buffer pool resize                                               Administrative
recovery read                                                    System I/O
pi renounce write complete                                       Cluster
enq: RO – contention                                             Application
enq: RO – fast object reuse                                      Application
enq: KO – fast object checkpoint                                 Application
ARCH wait for pending I/Os                                       System I/O
ARCH wait for netserver start                                    Network
ARCH wait for netserver init 1                                   Network
ARCH wait for netserver init 2                                   Network
ARCH wait for flow-control                                       Network
ARCH wait for netserver detach                                   Network
ARCH wait for net re-connect                                     Network
LNS ASYNC control file txn                                       System I/O
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
LNS ASYNC archive log                                            Idle
LNS ASYNC dest activation                                        Idle
LNS ASYNC end of log                                             Idle
LNS wait on ATTACH                                               Network
LNS wait on SENDREQ                                              Network
LNS wait on DETACH                                               Network
LNS wait on LGWR                                                 Network
LGWR wait on ATTACH                                              Network
LGWR wait on SENDREQ                                             Network
LGWR wait on DETACH                                              Network
LGWR sequential i/o                                              System I/O
LGWR random i/o                                                  System I/O
LGWR wait on LNS                                                 Network
RFS sequential i/o                                               System I/O
RFS random i/o                                                   System I/O
RFS write                                                        System I/O
ARCH wait on ATTACH                                              Network
ARCH wait on SENDREQ                                             Network
ARCH wait on DETACH                                              Network
ARCH sequential i/o                                              System I/O
ARCH random i/o                                                  System I/O
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
log file sequential read                                         System I/O
log file single write                                            System I/O
log file parallel write                                          System I/O
latch: redo writing                                              Configuration
latch: redo copy                                                 Configuration
log buffer space                                                 Configuration
log file switch (checkpoint incomplete)                          Configuration
log file switch (private strand flush incomplete)                Configuration
log file switch (archiving needed)                               Configuration
switch logfile command                                           Administrative
log file switch completion                                       Configuration
log file sync                                                    Commit
db file sequential read                                          User I/O
db file scattered read                                           User I/O
db file single write                                             User I/O
db file parallel write                                           System I/O
db file parallel read                                            User I/O
gc current request                                               Cluster
gc cr request                                                    Cluster
gc cr disk request                                               Cluster
gc cr multi block request                                        Cluster
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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 prepare                                                       Cluster
gc remaster                                                      Cluster
gc current cancel                                                Cluster
gc cr cancel                                                     Cluster
gc assume                                                        Cluster
gc domain validation                                             Cluster
gc recovery free                                                 Cluster
gc recovery quiesce                                              Cluster
gc claim                                                         Cluster
gc quiesce wait                                                  Cluster
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
PX Deq: Par Recov Reply                                          Idle
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
PX Deq: Par Recov Execute                                        Idle
PX Deq: Par Recov Change Vector                                  Idle
LogMiner: slave waiting for activate message                     Idle
LogMiner: wakeup event for builder                               Idle
LogMiner: wakeup event for preparer                              Idle
LogMiner: wakeup event for reader                                Idle
LogMiner: client waiting for transaction                         Idle
wait for possible quiesce finish                                 Administrative
parallel recovery coordinator waits for cleanup of slaves        Idle
enq: TM – contention                                             Application
enq: ST – contention                                             Configuration
enq: HW – contention                                             Configuration
enq: SS – contention                                             Configuration
undo segment extension                                           Configuration
undo segment tx slot                                             Configuration
switch undo – offline                                            Administrative
alter rbs offline                                                Administrative
enq: TX – row lock contention                                    Application
enq: TX – allocate ITL entry                                     Configuration
enq: TX – index contention                                       Concurrency
enq: TW – contention                                             Administrative
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
sort segment request                                             Configuration
smon timer                                                       Idle
PX Deq: Txn Recovery Start                                       Idle
PX Deq: Txn Recovery Reply                                       Idle
latch: Undo Hint Latch                                           Concurrency
statement suspended, wait error to be cleared                    Configuration
latch: In memory undo latch                                      Concurrency
latch: MQL Tracking Latch                                        Concurrency
enq: SQ – contention                                             Configuration
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
index (re)build online start                                     Administrative
index (re)build online cleanup                                   Administrative
index (re)build online merge                                     Administrative
latch: row cache objects                                         Concurrency
row cache lock                                                   Concurrency
row cache read                                                   Concurrency
cursor: mutex X                                                  Concurrency
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
cursor: mutex S                                                  Concurrency
cursor: pin S wait on X                                          Concurrency
latch: shared pool                                               Concurrency
latch: library cache                                             Concurrency
latch: library cache lock                                        Concurrency
latch: library cache pin                                         Concurrency
library cache pin                                                Concurrency
library cache lock                                               Concurrency
library cache load lock                                          Concurrency
BFILE read                                                       User I/O
resmgr:cpu quantum                                               Scheduler
resmgr:internal state change                                     Concurrency
resmgr:internal state cleanup                                    Concurrency
resmgr:sessions to exit                                          Concurrency
resmgr:become active                                             Scheduler
TCP Socket (KGAS)                                                Network
alter system set dispatcher                                      Administrative
virtual circuit status                                           Idle
dispatcher timer                                                 Idle
dispatcher listen timer                                          Network
dedicated server timer                                           Network
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
jobq slave wait                                                  Idle
Wait for Table Lock                                              Application
pipe get                                                         Idle
pipe put                                                         Concurrency
enq: DB – contention                                             Administrative
PX Deque wait                                                    Idle
PX Idle Wait                                                     Idle
PX Deq: Join ACK                                                 Idle
PX Deq Credit: need buffer                                       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 capture: filter callback waiting for ruleset             Application
Streams: RAC waiting for inter instance ack                      Cluster
Streams: apply reader waiting for DDL to apply                   Application
Streams capture: waiting for subscribers to catch up             Configuration
Streams capture: resolve low memory condition                    Configuration
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
enq: ZG – contention                                             Administrative
single-task message                                              Idle
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 message from client                                      Idle
SQL*Net more data from client                                    Network
SQL*Net message from dblink                                      Idle
SQL*Net more data from dblink                                    Network
SQL*Net break/reset to client                                    Application
SQL*Net break/reset to dblink                                    Application
PL/SQL lock timer                                                Idle
enq: UL – contention                                             Application
wait for EMON to process ntfns                                   Configuration
EMON idle wait                                                   Idle
Streams AQ: waiting for messages in the queue                    Idle
Streams AQ: waiting for time management or cleanup tasks         Idle
Streams AQ: enqueue blocked on low memory                        Configuration
Streams AQ: delete acknowledged messages                         Idle
Streams AQ: deallocate messages from Streams Pool                Idle
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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
TEXT: URL_DATASTORE network wait                                 Network
ASM COD rollback operation completion                            Administrative
kfk: async disk IO                                               System I/O
ASM background timer                                             Idle
ASM mount : wait for heartbeat                                   Administrative
ASM PST query : wait for [PM][grp][0] grant                      Cluster
lock remastering                                                 Cluster
JS kgl get object wait                                           Administrative
JS external job                                                  Idle
JS kill job wait                                                 Administrative
JS coord start wait                                              Administrative
events in waitclass Other                                        Other
unspecified wait event                                           Other
latch activity                                                   Other
wait list latch activity                                         Other
latch free                                                       Other
wait list latch free                                             Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
ksqded                                                           Other
global enqueue expand wait                                       Other
enq: KM – contention                                             Other
enq: KT – contention                                             Other
free process state object                                        Other
inactive session                                                 Other
process terminate                                                Other
latch: session allocation                                        Other
check CPU wait times                                             Other
enq: CI – contention                                             Other
enq: PR – 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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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
imm op                                                           Other
slave exit                                                       Other
reliable message                                                 Other
master exit                                                      Other
ksv slave avail wait                                             Other
enq: PV – syncstart                                              Other
enq: PV – syncshut                                               Other
IPC send completion sync                                         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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
enq: FM – contention                                             Other
enq: XY – contention                                             Other
set director factor wait                                         Other
enq: AS – service activation                                     Other
enq: AS – modify service                                         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
latch: ges resource hash list                                    Other
DFS lock handle                                                  Other
ges LMD to shutdown                                              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 wait for lmon to be ready                                    Other
ges cgs registration                                             Other
wait for master scn                                              Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
ges reconfiguration to start                                     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 – mrcvr                          Other
ges lmd/lmses to unfreeze in rcfg – mrcvr                        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 remastering wait for write latch                             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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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
KJC: Wait for msg sends to complete                              Other
kjctssqmg: quick message send wait                               Other
kjctcisnd: Queue/Send client message                             Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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
wait for tmc2 to complete                                        Other
wait for votes                                                   Other
wait for rr lock release                                         Other
wait for message ack                                             Other
wait for record update                                           Other
wait for membership synchronization                              Other
wait for split-brain resolution                                  Other
CGS skgxn join retry                                             Other
gcs to be enabled                                                Other
gcs log flush sync                                               Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
SGA: allocation forcing component growth                         Other
SGA: sga_target resize                                           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
buffer deadlock                                                  Other
buffer latch                                                     Other
cr request retry                                                 Other
writes stopped by instance recovery or database suspension       Other
lock escalate retry                                              Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
lock deadlock retry                                              Other
prewarm transfer retry                                           Other
wait for MTTR advisory state object                              Other
latch: object queue header operation                             Other
latch: object queue header heap                                  Other
enq: WR – contention                                             Other
log switch/archive                                               Other
ARCH wait on c/f tx acquire 1                                    Other
ARCH wait on c/f tx acquire 2                                    Other
ARCH wait for process start 1                                    Other
ARCH wait for process death 1                                    Other
ARCH wait for process start 2                                    Other
ARCH wait for process death 2                                    Other
ARCH wait for process start 3                                    Other
ARCH wait for process death 3                                    Other
ARCH wait for process start 4                                    Other
ARCH wait for process death 4                                    Other
ARCH wait for process death 5                                    Other
ARCH wait for archivelog lock                                    Other
Wait on stby instance close                                      Other
RFS dispatch                                                     Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
RFS attach                                                       Other
RFS create                                                       Other
RFS close                                                        Other
RFS announce                                                     Other
RFS register                                                     Other
RFS detach                                                       Other
RFS ping                                                         Other
LGWR simulation latency wait                                     Other
LGWR-LNS wait on channel                                         Other
LGWR wait on full LNS buffer                                     Other
LNS simulation latency wait                                      Other
kcrrrcp                                                          Other
LNS wait for LGWR redo                                           Other
Data Guard: process exit                                         Other
Data Guard: process clean up                                     Other
MRP wait on process start                                        Other
MRP wait on process restart                                      Other
MRP wait on startup clear                                        Other
MRP wait on process death                                        Other
MRP wait on state change                                         Other
MRP wait on state n_a                                            Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
MRP wait on state reset                                          Other
MRP wait on archivelog delay                                     Other
MRP wait on archivelog arrival                                   Other
MRP wait on archivelog archival                                  Other
FAL archive wait 1 sec for REOPEN minimum                        Other
LGWR wait for redo copy                                          Other
latch: redo allocation                                           Other
log file switch (clearing log file)                              Other
simulated log write delay                                        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: KCL gc element parent latch                               Other
enq: RT – contention                                             Other
enq: KK – context                                                Other
enq: IR – contention                                             Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
enq: IR – contention2                                            Other
enq: MR – contention                                             Other
enq: BR – file shrink                                            Other
enq: BR – proxy-copy                                             Other
enq: ID – contention                                             Other
enq: MN – contention                                             Other
enq: PL – contention                                             Other
Logical Standby Apply shutdown                                   Other
Logical Standby pin transaction                                  Other
Logical Standby dictionary build                                 Other
Logical Standby Terminal Apply                                   Other
enq: SB – contention                                             Other
enq: XR – quiesce database                                       Other
enq: XR – database force logging                                 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
enq: CT – global space management                                Other
enq: CT – local space management                                 Other
enq: CT – change stream ownership                                Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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 identical 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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
enq: FD – Flashback coordinator                                  Other
enq: FD – Flashback on/off                                       Other
enq: FD – Restore point create/drop                              Other
flashback free VI log                                            Other
flashback buf free by RVWR                                       Other
flashback log switch                                             Other
RVWR wait for flashback copy                                     Other
transaction                                                      Other
inactive transaction branch                                      Other
txn to complete                                                  Other
PMON to cleanup pseudo-branches at svc stop time                 Other
test long ops                                                    Other
enq: TF – contention                                             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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
enq: TS – contention                                             Other
enq: FB – contention                                             Other
enq: SK – contention                                             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
enq: SU – contention                                             Other
enq: TT – contention                                             Other
ktm: instance recovery                                           Other
instance state change                                            Other
wait for stopper event to be increased                           Other
wait for a undo record                                           Other
wait for a paralle reco to abort                                 Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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
index block split                                                Other
enq: HV – contention                                             Other
dupl. cluster key                                                Other
kdic_do_merge                                                    Other
enq: DL – contention                                             Other
enq: HQ – contention                                             Other
enq: HP – contention                                             Other
enq: DV – contention                                             Other
enq: RW – MV metadata contention                                 Other
enq: OC – contention                                             Other
enq: OL – contention                                             Other
kkdlgon                                                          Other
kkdlsipon                                                        Other
kkdlhpon                                                         Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
kgltwait                                                         Other
kksfbc research                                                  Other
kksscl hash split                                                Other
kksfbc child completion                                          Other
enq: CU – contention                                             Other
cursor: pin X                                                    Other
cursor: pin S                                                    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: AU – audit index file                                       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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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
dispatcher shutdown                                              Other
latch: virtual circuit queues                                    Other
listen endpoint status                                           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
kkshgnc reloop                                                   Other
optimizer stats update retry                                     Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
wait active processes                                            Other
enq: MD – contention                                             Other
enq: MS – 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 Credit: send blkd                                         Other
PX Deq: Test for msg                                             Other
PX Deq: Signal ACK                                               Other
PX Deq: reap credit                                              Other
PX Nsq: PQ descriptor query                                      Other
PX Nsq: PQ load info query                                       Other
enq: PI – contention                                             Other
enq: PS – contention                                             Other
latch: parallel query alloc buffer                               Other
kxfxse                                                           Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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
enq: TO – contention                                             Other
enq: IT – contention                                             Other
enq: BF – allocation contention                                  Other
timer in sksawat                                                 Other
scginq AST call                                                  Other
kupp process wait                                                Other
Kupp process shutdown                                            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 capture: waiting for archive log                         Other
enq: SI – contention                                             Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
enq: IA – contention                                             Other
enq: JI – contention                                             Other
qerex_gdml                                                       Other
enq: AT – contention                                             Other
opishd                                                           Other
wait for EMON to spawn                                           Other
wait for EMON to die                                             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: 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: enqueue blocked due to flow control                  Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
queue slave messages                                             Other
Streams AQ: qmn coordinator waiting for slave to start           Other
rfm_dmon_pdefer                                                  Other
rfm_dmon_shut                                                    Other
rfm_dmon_timeout_op                                              Other
rfm_pmon_dso_stall                                               Other
rfm_dmon_last_gasp                                               Other
Data Guard broker: single instance                               Other
rfrm_dbop                                                        Other
rfrm_dbcl                                                        Other
rfrm_stall                                                       Other
rfrm_rsm_shut                                                    Other
rfrm_zero_sub_count                                              Other
rfrm_rsm_start                                                   Other
rfrm_nonzero_sub_count                                           Other
rfrm_rsm_so_attach                                               Other
rfi_drcx_site_del                                                Other
rfi_insv_shut                                                    Other
rfi_insv_start                                                   Other
rfi_nsv_deldef                                                   Other
rfi_nsv_md_close                                                 Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
rfi_nsv_md_write                                                 Other
rfi_nsv_postdef                                                  Other
rfi_nsv_shut                                                     Other
rfi_nsv_start                                                    Other
rfi_recon1                                                       Other
rfi_recon2                                                       Other
enq: RF – synch: DG Broker metadata                              Other
enq: RF – atomicity                                              Other
enq: RF – synchronization: chief                                 Other
enq: RF – synchronization: HC master                             Other
enq: RF – synchronization: aifo master                           Other
enq: RF – new AI                                                 Other
enq: RF – synchronization: critical ai                           Other
enq: RF – RF – FSFO state                                        Other
enq: RF – RF – FSFO wait                                         Other
enq: RF – RF – FSFO connectivity                                 Other
enq: RF – RF – FSFO synchronization                              Other
enq: RF – RF – FSFO Observed                                     Other
enq: RF – RF – Database Automatic Disable                        Other
rfrxptarcurlog                                                   Other
rfrxpt_pdl                                                       Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
rfrdb_recon1                                                     Other
rfrdb_recon2                                                     Other
rfrdb_dbop                                                       Other
rfrdb_try235                                                     Other
Data Guard broker: wait upon ORA-12850 error                     Other
rfrla_lapp1                                                      Other
rfrla_lapp2                                                      Other
rfrla_lapp3                                                      Other
rfrla_lapp4                                                      Other
rfrla_lapp5                                                      Other
rfrpa_mrpup                                                      Other
rfrpa_mrpdn                                                      Other
RF – FSFO Wait for Ack                                           Other
rfrld_rhmrpwait                                                  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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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: AM – client registration                                    Other
enq: AM – shutdown                                               Other
enq: AM – rollback COD reservation                               Other
ASM internal hang test                                           Other
buffer busy                                                      Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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
enq: CM – gate                                                   Other
enq: CM – instance                                               Other
enq: XQ – recovery                                               Other
enq: XQ – relocation                                             Other
enq: AD – allocate AU                                            Other
enq: AD – deallocate AU                                          Other
extent map load/unlock                                           Other
Sync ASM rebalance                                               Other
enq: DG – contention                                             Other
enq: DD – contention                                             Other
enq: HD – contention                                             Other
enq: DN – contention                                             Other
Cluster stablization wait                                        Other
Cluster Suspension wait                                          Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
ASM background starting                                          Other
ASM background running                                           Other
ASM db client exists                                             Other
DBFG waiting for reply                                           Other
enq: FA – access file                                            Other
log write(odd)                                                   Other
log write(even)                                                  Other
checkpoint advanced                                              Other
enq: FR – contention                                             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
rollback operations block full                                   Other
rollback operations active                                       Other
enq: RB – contention                                             Other
enq: PT – contention                                             Other
global cache busy                                                Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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: WF – contention                                             Other
enq: WP – contention                                             Other
enq: FU – contention                                             Other
enq: MW – contention                                             Other
AWR Flush                                                        Other
AWR Metric Capture                                               Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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: TL – contention                                             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
secondary event                                                  Other
878 rows selected
SQL>
SQL> select name,wait_class from v$event_name order by 2;
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
Backup: sbtinit                                                  Administrative
JS coord start wait                                              Administrative
Backup: sbtread                                                  Administrative
Backup: sbtwrite                                                 Administrative
Backup: sbtclose                                                 Administrative
Backup: sbtinfo                                                  Administrative
Backup: sbtremove                                                Administrative
Backup: sbtbackup                                                Administrative
Backup: sbtclose2                                                Administrative
Backup: sbtcommand                                               Administrative
Backup: sbtend                                                   Administrative
Backup: sbterror                                                 Administrative
Backup: sbtinfo2                                                 Administrative
Backup: sbtinit2                                                 Administrative
Backup: sbtread2                                                 Administrative
Backup: sbtremove2                                               Administrative
Backup: sbtrestore                                               Administrative
Backup: sbtwrite2                                                Administrative
Backup: sbtpcbackup                                              Administrative
Backup: sbtpccancel                                              Administrative
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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: sbtopen                                                  Administrative
JS kill job wait                                                 Administrative
JS kgl get object wait                                           Administrative
ASM mount : wait for heartbeat                                   Administrative
ASM COD rollback operation completion                            Administrative
enq: ZG – contention                                             Administrative
enq: DB – contention                                             Administrative
alter system set dispatcher                                      Administrative
index (re)build online merge                                     Administrative
index (re)build online cleanup                                   Administrative
index (re)build online start                                     Administrative
enq: TW – contention                                             Administrative
multiple dbwriter suspend/resume for file offline                Administrative
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
buffer pool resize                                               Administrative
switch logfile command                                           Administrative
wait for possible quiesce finish                                 Administrative
switch undo – offline                                            Administrative
alter rbs offline                                                Administrative
enq: TX – row lock contention                                    Application
Wait for Table Lock                                              Application
SQL*Net break/reset to client                                    Application
enq: TM – contention                                             Application
enq: UL – contention                                             Application
enq: PW – flush prewarm buffers                                  Application
enq: KO – fast object checkpoint                                 Application
enq: RO – fast object reuse                                      Application
enq: RO – contention                                             Application
Streams capture: filter callback waiting for ruleset             Application
SQL*Net break/reset to dblink                                    Application
Streams: apply reader waiting for DDL to apply                   Application
Streams: RAC waiting for inter instance ack                      Cluster
gc quiesce wait                                                  Cluster
lock remastering                                                 Cluster
retry contact SCN lock master                                    Cluster
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
gc buffer busy                                                   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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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 prepare                                                       Cluster
gc remaster                                                      Cluster
gc current cancel                                                Cluster
gc cr cancel                                                     Cluster
gc assume                                                        Cluster
gc domain validation                                             Cluster
gc recovery free                                                 Cluster
gc recovery quiesce                                              Cluster
gc claim                                                         Cluster
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
ASM PST query : wait for [PM][grp][0] grant                      Cluster
log file sync                                                    Commit
latch: In memory undo latch                                      Concurrency
latch: MQL Tracking Latch                                        Concurrency
latch: row cache objects                                         Concurrency
row cache lock                                                   Concurrency
row cache read                                                   Concurrency
cursor: mutex X                                                  Concurrency
cursor: mutex S                                                  Concurrency
cursor: pin S wait on X                                          Concurrency
latch: shared pool                                               Concurrency
latch: library cache                                             Concurrency
latch: library cache lock                                        Concurrency
latch: library cache pin                                         Concurrency
library cache pin                                                Concurrency
library cache lock                                               Concurrency
library cache load lock                                          Concurrency
resmgr:internal state change                                     Concurrency
resmgr:internal state cleanup                                    Concurrency
resmgr:sessions to exit                                          Concurrency
pipe put                                                         Concurrency
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
logout restrictor                                                Concurrency
os thread startup                                                Concurrency
latch: cache buffers chains                                      Concurrency
buffer busy waits                                                Concurrency
enq: TX – index contention                                       Concurrency
latch: Undo Hint Latch                                           Concurrency
enq: TX – allocate ITL entry                                     Configuration
sort segment request                                             Configuration
statement suspended, wait error to be cleared                    Configuration
enq: SQ – contention                                             Configuration
Streams capture: waiting for subscribers to catch up             Configuration
Streams capture: resolve low memory condition                    Configuration
wait for EMON to process ntfns                                   Configuration
Streams AQ: enqueue blocked on low memory                        Configuration
free buffer waits                                                Configuration
checkpoint completed                                             Configuration
write complete waits                                             Configuration
latch: redo writing                                              Configuration
latch: redo copy                                                 Configuration
log buffer space                                                 Configuration
log file switch (checkpoint incomplete)                          Configuration
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
log file switch (private strand flush incomplete)                Configuration
log file switch (archiving needed)                               Configuration
log file switch completion                                       Configuration
enq: ST – contention                                             Configuration
enq: HW – contention                                             Configuration
enq: SS – contention                                             Configuration
undo segment extension                                           Configuration
undo segment tx slot                                             Configuration
pmon timer                                                       Idle
JS external job                                                  Idle
i/o slave wait                                                   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
watchdog main loop                                               Idle
DIAG idle wait                                                   Idle
ges remote message                                               Idle
gcs remote message                                               Idle
SGA: MMAN sleep for component shrink                             Idle
LNS ASYNC archive log                                            Idle
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
LNS ASYNC dest activation                                        Idle
LNS ASYNC end of log                                             Idle
PX Deq: Par Recov Reply                                          Idle
PX Deq: Par Recov Execute                                        Idle
PX Deq: Par Recov Change Vector                                  Idle
LogMiner: slave waiting for activate message                     Idle
LogMiner: wakeup event for builder                               Idle
LogMiner: wakeup event for preparer                              Idle
LogMiner: wakeup event for reader                                Idle
LogMiner: client waiting for transaction                         Idle
parallel recovery coordinator waits for cleanup of slaves        Idle
smon timer                                                       Idle
PX Deq: Txn Recovery Start                                       Idle
PX Deq: Txn Recovery Reply                                       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 status                                           Idle
dispatcher timer                                                 Idle
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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
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
single-task message                                              Idle
SQL*Net message from client                                      Idle
SQL*Net message from dblink                                      Idle
PL/SQL lock timer                                                Idle
EMON 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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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
rdbms ipc message                                                Idle
ARCH wait for netserver start                                    Network
TEXT: URL_DATASTORE network wait                                 Network
ARCH wait for netserver init 2                                   Network
ARCH wait for flow-control                                       Network
ARCH wait for netserver detach                                   Network
ARCH wait for net re-connect                                     Network
LNS wait on ATTACH                                               Network
LNS wait on SENDREQ                                              Network
LNS wait on DETACH                                               Network
LNS wait on LGWR                                                 Network
LGWR wait on ATTACH                                              Network
LGWR wait on SENDREQ                                             Network
LGWR wait on DETACH                                              Network
LGWR wait on LNS                                                 Network
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
ARCH wait on ATTACH                                              Network
ARCH wait on SENDREQ                                             Network
ARCH wait on DETACH                                              Network
TCP Socket (KGAS)                                                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 more data from dblink                                    Network
ARCH wait for netserver init 1                                   Network
null event                                                       Other
events in waitclass Other                                        Other
unspecified wait event                                           Other
latch activity                                                   Other
wait list latch activity                                         Other
latch free                                                       Other
wait list latch free                                             Other
ksqded                                                           Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
global enqueue expand wait                                       Other
enq: KM – contention                                             Other
enq: KT – contention                                             Other
free process state object                                        Other
inactive session                                                 Other
process terminate                                                Other
latch: session allocation                                        Other
check CPU wait times                                             Other
enq: CI – contention                                             Other
enq: PR – 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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
latch: messages                                                  Other
rdbms ipc message block                                          Other
rdbms ipc reply                                                  Other
latch: enqueue hash chains                                       Other
enq: FP – global fob contention                                  Other
imm op                                                           Other
slave exit                                                       Other
reliable message                                                 Other
master exit                                                      Other
ksv slave avail wait                                             Other
enq: PV – syncstart                                              Other
enq: PV – syncshut                                               Other
IPC send completion sync                                         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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
enq: XY – contention                                             Other
set director factor wait                                         Other
enq: AS – service activation                                     Other
enq: AS – modify service                                         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
latch: ges resource hash list                                    Other
DFS lock handle                                                  Other
ges LMD to shutdown                                              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 wait for lmon to be ready                                    Other
ges cgs registration                                             Other
wait for master scn                                              Other
ges reconfiguration to start                                     Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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 – mrcvr                          Other
ges lmd/lmses to unfreeze in rcfg – mrcvr                        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 remastering wait for write latch                             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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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
KJC: Wait for msg sends to complete                              Other
kjctssqmg: quick message send wait                               Other
kjctcisnd: Queue/Send client message                             Other
gcs domain validation                                            Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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
wait for tmc2 to complete                                        Other
wait for votes                                                   Other
wait for rr lock release                                         Other
wait for message ack                                             Other
wait for record update                                           Other
wait for membership synchronization                              Other
wait for split-brain resolution                                  Other
CGS skgxn join retry                                             Other
gcs to be enabled                                                Other
gcs log flush sync                                               Other
SGA: allocation forcing component growth                         Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
SGA: sga_target resize                                           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
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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
prewarm transfer retry                                           Other
wait for MTTR advisory state object                              Other
latch: object queue header operation                             Other
latch: object queue header heap                                  Other
enq: WR – contention                                             Other
log switch/archive                                               Other
ARCH wait on c/f tx acquire 1                                    Other
ARCH wait on c/f tx acquire 2                                    Other
ARCH wait for process start 1                                    Other
ARCH wait for process death 1                                    Other
ARCH wait for process start 2                                    Other
ARCH wait for process death 2                                    Other
ARCH wait for process start 3                                    Other
ARCH wait for process death 3                                    Other
ARCH wait for process start 4                                    Other
ARCH wait for process death 4                                    Other
ARCH wait for process death 5                                    Other
ARCH wait for archivelog lock                                    Other
Wait on stby instance close                                      Other
RFS dispatch                                                     Other
RFS attach                                                       Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
RFS create                                                       Other
RFS close                                                        Other
RFS announce                                                     Other
RFS register                                                     Other
RFS detach                                                       Other
RFS ping                                                         Other
LGWR simulation latency wait                                     Other
LGWR-LNS wait on channel                                         Other
LGWR wait on full LNS buffer                                     Other
LNS simulation latency wait                                      Other
kcrrrcp                                                          Other
LNS wait for LGWR redo                                           Other
Data Guard: process exit                                         Other
Data Guard: process clean up                                     Other
MRP wait on process start                                        Other
MRP wait on process restart                                      Other
MRP wait on startup clear                                        Other
MRP wait on process death                                        Other
MRP wait on state change                                         Other
MRP wait on state n_a                                            Other
MRP wait on state reset                                          Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
MRP wait on archivelog delay                                     Other
MRP wait on archivelog arrival                                   Other
MRP wait on archivelog archival                                  Other
FAL archive wait 1 sec for REOPEN minimum                        Other
LGWR wait for redo copy                                          Other
latch: redo allocation                                           Other
log file switch (clearing log file)                              Other
simulated log write delay                                        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: KCL gc element parent latch                               Other
enq: RT – contention                                             Other
enq: KK – context                                                Other
enq: IR – contention                                             Other
enq: IR – contention2                                            Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
enq: MR – contention                                             Other
enq: BR – file shrink                                            Other
enq: BR – proxy-copy                                             Other
enq: ID – contention                                             Other
enq: MN – contention                                             Other
enq: PL – contention                                             Other
Logical Standby Apply shutdown                                   Other
Logical Standby pin transaction                                  Other
Logical Standby dictionary build                                 Other
Logical Standby Terminal Apply                                   Other
enq: SB – contention                                             Other
enq: XR – quiesce database                                       Other
enq: XR – database force logging                                 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
enq: CT – global space management                                Other
enq: CT – local space management                                 Other
enq: CT – change stream ownership                                Other
enq: CT – state                                                  Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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 identical 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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
enq: FD – Flashback on/off                                       Other
enq: FD – Restore point create/drop                              Other
flashback free VI log                                            Other
flashback buf free by RVWR                                       Other
flashback log switch                                             Other
RVWR wait for flashback copy                                     Other
transaction                                                      Other
inactive transaction branch                                      Other
txn to complete                                                  Other
PMON to cleanup pseudo-branches at svc stop time                 Other
test long ops                                                    Other
enq: TF – contention                                             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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
enq: FB – contention                                             Other
enq: SK – contention                                             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
enq: SU – contention                                             Other
enq: TT – contention                                             Other
ktm: instance recovery                                           Other
instance state change                                            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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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
index block split                                                Other
enq: HV – contention                                             Other
dupl. cluster key                                                Other
kdic_do_merge                                                    Other
enq: DL – contention                                             Other
enq: HQ – contention                                             Other
enq: HP – contention                                             Other
enq: DV – contention                                             Other
enq: RW – MV metadata contention                                 Other
enq: OC – contention                                             Other
enq: OL – contention                                             Other
kkdlgon                                                          Other
kkdlsipon                                                        Other
kkdlhpon                                                         Other
kgltwait                                                         Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
kksfbc research                                                  Other
kksscl hash split                                                Other
kksfbc child completion                                          Other
enq: CU – contention                                             Other
cursor: pin X                                                    Other
cursor: pin S                                                    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: AU – audit index file                                       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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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
dispatcher shutdown                                              Other
latch: virtual circuit queues                                    Other
listen endpoint status                                           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
kkshgnc reloop                                                   Other
optimizer stats update retry                                     Other
wait active processes                                            Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
enq: MD – contention                                             Other
enq: MS – 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 Credit: send blkd                                         Other
PX Deq: Test for msg                                             Other
PX Deq: Signal ACK                                               Other
PX Deq: reap credit                                              Other
PX Nsq: PQ descriptor query                                      Other
PX Nsq: PQ load info query                                       Other
enq: PI – contention                                             Other
enq: PS – contention                                             Other
latch: parallel query alloc buffer                               Other
kxfxse                                                           Other
kxfxsp                                                           Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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
enq: TO – contention                                             Other
enq: IT – contention                                             Other
enq: BF – allocation contention                                  Other
timer in sksawat                                                 Other
scginq AST call                                                  Other
kupp process wait                                                Other
Kupp process shutdown                                            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 capture: waiting for archive log                         Other
enq: SI – contention                                             Other
enq: IA – contention                                             Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
enq: JI – contention                                             Other
qerex_gdml                                                       Other
enq: AT – contention                                             Other
opishd                                                           Other
wait for EMON to spawn                                           Other
wait for EMON to die                                             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: 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: enqueue blocked due to flow control                  Other
queue slave messages                                             Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
Streams AQ: qmn coordinator waiting for slave to start           Other
rfm_dmon_pdefer                                                  Other
rfm_dmon_shut                                                    Other
rfm_dmon_timeout_op                                              Other
rfm_pmon_dso_stall                                               Other
rfm_dmon_last_gasp                                               Other
Data Guard broker: single instance                               Other
rfrm_dbop                                                        Other
rfrm_dbcl                                                        Other
rfrm_stall                                                       Other
rfrm_rsm_shut                                                    Other
rfrm_zero_sub_count                                              Other
rfrm_rsm_start                                                   Other
rfrm_nonzero_sub_count                                           Other
rfrm_rsm_so_attach                                               Other
rfi_drcx_site_del                                                Other
rfi_insv_shut                                                    Other
rfi_insv_start                                                   Other
rfi_nsv_deldef                                                   Other
rfi_nsv_md_close                                                 Other
rfi_nsv_md_write                                                 Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
rfi_nsv_postdef                                                  Other
rfi_nsv_shut                                                     Other
rfi_nsv_start                                                    Other
rfi_recon1                                                       Other
rfi_recon2                                                       Other
enq: RF – synch: DG Broker metadata                              Other
enq: RF – atomicity                                              Other
enq: RF – synchronization: chief                                 Other
enq: RF – synchronization: HC master                             Other
enq: RF – synchronization: aifo master                           Other
enq: RF – new AI                                                 Other
enq: RF – synchronization: critical ai                           Other
enq: RF – RF – FSFO state                                        Other
enq: RF – RF – FSFO wait                                         Other
enq: RF – RF – FSFO connectivity                                 Other
enq: RF – RF – FSFO synchronization                              Other
enq: RF – RF – FSFO Observed                                     Other
enq: RF – RF – Database Automatic Disable                        Other
rfrxptarcurlog                                                   Other
rfrxpt_pdl                                                       Other
rfrdb_recon1                                                     Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
rfrdb_recon2                                                     Other
rfrdb_dbop                                                       Other
rfrdb_try235                                                     Other
Data Guard broker: wait upon ORA-12850 error                     Other
rfrla_lapp1                                                      Other
rfrla_lapp2                                                      Other
rfrla_lapp3                                                      Other
rfrla_lapp4                                                      Other
rfrla_lapp5                                                      Other
rfrpa_mrpup                                                      Other
rfrpa_mrpdn                                                      Other
RF – FSFO Wait for Ack                                           Other
rfrld_rhmrpwait                                                  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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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: AM – client registration                                    Other
enq: AM – shutdown                                               Other
enq: AM – rollback COD reservation                               Other
ASM internal hang test                                           Other
buffer busy                                                      Other
buffer freelistbusy                                              Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
buffer rememberlist busy                                         Other
buffer writeList full                                            Other
no free buffers                                                  Other
buffer write wait                                                Other
buffer invalidation wait                                         Other
buffer dirty disabled                                            Other
enq: CM – gate                                                   Other
enq: CM – instance                                               Other
enq: XQ – recovery                                               Other
enq: XQ – relocation                                             Other
enq: AD – allocate AU                                            Other
enq: AD – deallocate AU                                          Other
extent map load/unlock                                           Other
Sync ASM rebalance                                               Other
enq: DG – contention                                             Other
enq: DD – contention                                             Other
enq: HD – contention                                             Other
enq: DN – contention                                             Other
Cluster stablization wait                                        Other
Cluster Suspension wait                                          Other
ASM background starting                                          Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
ASM background running                                           Other
ASM db client exists                                             Other
DBFG waiting for reply                                           Other
enq: FA – access file                                            Other
log write(odd)                                                   Other
log write(even)                                                  Other
checkpoint advanced                                              Other
enq: FR – contention                                             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
rollback operations block full                                   Other
rollback operations active                                       Other
enq: RB – contention                                             Other
enq: PT – contention                                             Other
global cache busy                                                Other
lock release pending                                             Other
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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: 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
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
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: TL – contention                                             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
secondary event                                                  Other
resmgr:cpu quantum                                               Scheduler
resmgr:become active                                             Scheduler
kfk: async disk IO                                               System I/O
kst: async disk IO                                               System I/O
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
ksfd: async disk IO                                              System I/O
db file parallel write                                           System I/O
log file parallel write                                          System I/O
log file single write                                            System I/O
log file sequential read                                         System I/O
ARCH random i/o                                                  System I/O
ARCH sequential i/o                                              System I/O
RFS write                                                        System I/O
RFS random i/o                                                   System I/O
RFS sequential i/o                                               System I/O
LGWR random i/o                                                  System I/O
LGWR sequential i/o                                              System I/O
LNS ASYNC control file txn                                       System I/O
ARCH wait for pending I/Os                                       System I/O
recovery read                                                    System I/O
control file parallel write                                      System I/O
control file single write                                        System I/O
Log archive I/O                                                  System I/O
RMAN backup & recovery I/O                                       System I/O
Standby redo I/O                                                 System I/O
io done                                                          System I/O
NAME                                                             WAIT_CLASS
—————————————————————- —————————————————————-
control file sequential read                                     System I/O
db file scattered read                                           User I/O
DG Broker configuration file I/O                                 User I/O
dbms_file_transfer I/O                                           User I/O
BFILE read                                                       User I/O
read by other session                                            User I/O
buffer read retry                                                User I/O
local write wait                                                 User I/O
direct path write temp                                           User I/O
direct path write                                                User I/O
direct path read temp                                            User I/O
direct path read                                                 User I/O
db file parallel read                                            User I/O
Datapump dump file I/O                                           User I/O
db file single write                                             User I/O
Log file init write                                              User I/O
Data file init write                                             User I/O
db file sequential read                                          User I/O
878 rows selected
分享 转发
TOP
发新话题 回复该主题