| 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# |
|
