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