| Name |
| alter rbs offline |
| AQ Deallocate Wait |
| AQ Proxy Cleanup Wait |
| ARCH wait for archivelog lock |
| ARCH wait for flow-control |
| ARCH wait for net re-connect |
| ARCH wait for netserver detach |
| ARCH wait for netserver init 1 |
| ARCH wait for netserver init 2 |
| ARCH wait for netserver start |
| ARCH wait for pending I/Os |
| ARCH wait for process death 1 |
| ARCH wait for process death 2 |
| ARCH wait for process death 3 |
| ARCH wait for process death 4 |
| ARCH wait for process death 5 |
| ARCH wait for process start 1 |
| ARCH wait for process start 2 |
| ARCH wait for process start 3 |
| ARCH wait for process start 4 |
| ARCH wait on c/f tx acquire 1 |
| ARCH wait on c/f tx acquire 2 |
| ASM background running |
| ASM background starting |
| ASM background timer |
| ASM db client exists |
| ASM mount : wait for heartbeat |
| ASM PST query : wait for [PM][grp][0] grant |
| Backup: sbtbackup |
| Backup: sbtclose |
| Backup: sbtclose2 |
| Backup: sbtcommand |
| Backup: sbtend |
| Backup: sbterror |
| Backup: sbtinfo |
| Backup: sbtinfo2 |
| Backup: sbtinit |
| Backup: sbtinit2 |
| Backup: sbtopen |
| Backup: sbtpcbackup |
| Backup: sbtpccancel |
| Backup: sbtpccommit |
| Backup: sbtpcend |
| Backup: sbtpcquerybackup |
| Backup: sbtpcqueryrestore |
| Backup: sbtpcrestore |
| Backup: sbtpcstart |
| Backup: sbtpcstatus |
| Backup: sbtpcvalidate |
| Backup: sbtread |
| Backup: sbtread2 |
| Backup: sbtremove |
| Backup: sbtremove2 |
| Backup: sbtrestore |
| Backup: sbtwrite |
| Backup: sbtwrite2 |
| block change tracking buffer space |
| buffer busy |
| buffer dirty disabled |
| buffer freelistbusy |
| buffer invalidation wait |
| buffer rememberlist busy |
| buffer write wait |
| buffer writeList full |
| change tracking file parallel write |
| change tracking file synchronous read |
| change tracking file synchronous write |
| check CPU wait times |
| checkpoint advanced |
| class slave wait |
| Cluster stablization wait |
| Cluster Suspension wait |
| Data Guard broker: wait upon ORA-12850 error |
| DBFG waiting for reply |
| DBMS_LDAP: LDAP operation |
| dedicated server timer |
| direct path read temp |
| direct path write temp |
| DLM lock cancel |
| DLM lock cvt S |
| DLM lock cvt X |
| DLM lock esc |
| DLM lock esc X |
| DLM lock open |
| DLM lock open S |
| DLM lock open X |
| DLM recovery lock convert |
| DLM recovery lock open |
| dma prepare busy |
| enq: AD - allocate AU |
| enq: AD - deallocate AU |
| enq: AF - task serialization |
| enq: AG - contention |
| enq: AO - contention |
| enq: AS - contention |
| enq: AT - contention |
| enq: AW - AW generation lock |
| enq: AW - AW state lock |
| enq: AW - AW$ table lock |
| enq: AW - user access for AW |
| enq: BR - file shrink |
| enq: BR - proxy-copy |
| enq: CF - contention |
| enq: CI - contention |
| enq: CL - compare labels |
| enq: CL - drop label |
| enq: CM - gate |
| enq: CM - instance |
| enq: CT - change stream ownership |
| enq: CT - CTWR process start/stop |
| enq: CT - global space management |
| enq: CT - local space management |
| enq: CT - reading |
| enq: CT - state |
| enq: CT - state change gate 1 |
| enq: CT - state change gate 2 |
| enq: CU - contention |
| enq: DB - contention |
| enq: DD - contention |
| enq: DF - contention |
| enq: DG - contention |
| enq: DL - contention |
| enq: DM - contention |
| enq: DN - contention |
| enq: DP - contention |
| enq: DR - contention |
| enq: DS - contention |
| enq: DT - contention |
| enq: DV - contention |
| enq: DX - contention |
| enq: FA - access file |
| enq: FB - contention |
| enq: FC - open an ACD thread |
| enq: FC - recover an ACD thread |
| enq: FD - Flashback coordinator |
| enq: FD - Flashback on/off |
| enq: FD - Marker generation |
| enq: FD - Tablespace flashback on/off |
| enq: FG - FG redo generation enq race |
| enq: FG - LGWR redo generation enq race |
| enq: FG - serialize ACD relocate |
| enq: FL - Flashback database log |
| enq: FL - Flashback db command |
| enq: FM - contention |
| enq: FR - contention |
| enq: FS - contention |
| enq: FT - allow LGWR writes |
| enq: FT - disable LGWR writes |
| enq: FU - contention |
| enq: HD - contention |
| enq: HP - contention |
| enq: HQ - contention |
| enq: HV - contention |
| enq: HW - contention |
| enq: IA - contention |
| enq: ID - contention |
| enq: IL - contention |
| enq: IM - contention for blr |
| enq: IR - contention |
| enq: IR - contention2 |
| enq: IS - contention |
| enq: IT - contention |
| enq: JD - contention |
| enq: JI - contention |
| enq: JQ - contention |
| enq: JS - contention |
| enq: JS - coord post lock |
| enq: JS - coord rcv lock |
| enq: JS - global wdw lock |
| enq: JS - job chain evaluate lock |
| enq: JS - job recov lock |
| enq: JS - job run lock - synchronize |
| enq: JS - q mem clnup lck |
| enq: JS - queue lock |
| enq: JS - running job cnt lock |
| enq: JS - running job cnt lock2 |
| enq: JS - running job cnt lock3 |
| enq: JS - slave enq get lock1 |
| enq: JS - slave enq get lock2 |
| enq: KK - context |
| enq: KM - contention |
| enq: KP - contention |
| enq: KT - contention |
| enq: MD - contention |
| enq: MH - contention |
| enq: ML - contention |
| enq: MN - contention |
| enq: MR - contention |
| enq: MS - contention |
| enq: MW - contention |
| enq: OC - contention |
| enq: OL - contention |
| enq: OQ - xsoq*histrecb |
| enq: OQ - xsoqhiAlloc |
| enq: OQ - xsoqhiClose |
| enq: OQ - xsoqhiFlush |
| enq: OQ - xsoqhistrecb |
| enq: PD - contention |
| enq: PE - contention |
| enq: PF - contention |
| enq: PG - contention |
| enq: PH - contention |
| enq: PI - contention |
| enq: PL - contention |
| enq: PR - contention |
| enq: PS - contention |
| enq: PT - contention |
| enq: PV - syncshut |
| enq: PV - syncstart |
| enq: PW - flush prewarm buffers |
| enq: PW - perwarm status in dbw0 |
| enq: RB - contention |
| enq: RF - atomicity |
| enq: RF - new AI |
| enq: RF - synch: per-SGA Broker metadata |
| enq: RF - synchronization: aifo master |
| enq: RF - synchronization: chief |
| enq: RF - synchronization: critical ai |
| enq: RF - synchronization: HC master |
| enq: RN - contention |
| enq: RO - contention |
| enq: RO - fast object reuse |
| enq: RP - contention |
| enq: RS - file delete |
| enq: RS - persist alert level |
| enq: RS - prevent aging list update |
| enq: RS - prevent file delete |
| enq: RS - read alert level |
| enq: RS - record reuse |
| enq: RS - write alert level |
| enq: RT - contention |
| enq: SB - contention |
| enq: SF - contention |
| enq: SH - contention |
| enq: SI - contention |
| enq: SK - contention |
| enq: SQ - contention |
| enq: SR - contention |
| enq: SS - contention |
| enq: ST - contention |
| enq: SU - contention |
| enq: SW - contention |
| enq: TA - contention |
| enq: TB - SQL Tuning Base Cache Load |
| enq: TB - SQL Tuning Base Cache Update |
| enq: TC - contention |
| enq: TC - contention2 |
| enq: TD - KTF dump entries |
| enq: TE - KTF broadcast |
| enq: TF - contention |
| enq: TL - contention |
| enq: TM - contention |
| enq: TO - contention |
| enq: TQ - DDL contention |
| enq: TQ - INI contention |
| enq: TQ - TM contention |
| enq: TS - contention |
| enq: TT - contention |
| enq: TW - contention |
| enq: TX - allocate ITL entry |
| enq: TX - contention |
| enq: TX - index contention |
| enq: TX - row lock contention |
| enq: UL - contention |
| enq: US - contention |
| enq: WA - contention |
| enq: WF - contention |
| enq: WL - contention |
| enq: WP - contention |
| enq: XH - contention |
| enq: XR - database force logging |
| enq: XR - quiesce database |
| enq: XY - contention |
| extent map load/unlock |
| flashback buf free by RVWR |
| flashback free VI log |
| flashback log switch |
| Flow Control Event |
| foreground creation: start |
| foreground creation: wait |
| gc assume |
| gc block recovery request |
| gc buffer busy |
| gc claim |
| gc cr block 2-way |
| gc cr block 3-way |
| gc cr block busy |
| gc cr block congested |
| gc cr block unknown |
| gc cr cancel |
| gc cr disk read |
| gc cr disk request |
| gc cr failure |
| gc cr grant 2-way |
| gc cr grant busy |
| gc cr grant congested |
| gc cr grant unknown |
| gc cr multi block request |
| gc cr request |
| gc current block 2-way |
| gc current block 3-way |
| gc current block busy |
| gc current block congested |
| gc current block unknown |
| gc current cancel |
| gc current grant 2-way |
| gc current grant busy |
| gc current grant congested |
| gc current grant unknown |
| gc current multi block request |
| gc current request |
| gc current retry |
| gc current split |
| gc domain validation |
| gc freelist |
| gc prepare |
| gc quiesce wait |
| gc recovery free |
| gc recovery quiesce |
| gc remaster |
| gcs ddet enter server mode |
| gcs drm freeze begin |
| gcs drm freeze in enter server mode |
| gcs enter server mode |
| gcs log flush sync |
| gcs remastering wait for read latch |
| gcs remastering wait for write latch |
| gcs resource directory to be unfrozen |
| ges resource directory to be unfrozen |
| ges user error |
| ges wait for lmon to be ready |
| ges2 LMON to wake up lms - mrcvr 3 |
| global enqueue expand wait |
| GV$: slave acquisition retry wait time |
| HS message to agent |
| job scheduler coordinator slave wait |
| JS coord start wait |
| JS external job |
| JS kgl get object wait |
| JS kill job wait |
| kfcl: instance recovery |
| kfk: async disk IO |
| kjbdomalc allocate recovery domain - retry |
| kjbdrmcvtq lmon drm quiesce: ping completion |
| kjbopen wait for recovery domain attach |
| kjudomatt wait for recovery domain attach |
| kjudomdet wait for recovery domain detach |
| ksfd: async disk IO |
| ksfd: fib/fob latch |
| ksim generic wait event |
| ksv slave avail wait |
| ktfbtgex |
| ktm: instance recovery |
| Kupp process shutdown |
| kupp process wait |
| latch: cache buffer handles |
| latch: cache buffers chains |
| latch: cache buffers lru chain |
| latch: checkpoint queue latch |
| latch: enqueue hash chains |
| latch: gcs resource hash |
| latch: ges resource hash list |
| latch: In memory undo latch |
| latch: KCL gc element parent latch |
| latch: latch wait list |
| latch: library cache |
| latch: library cache lock |
| latch: library cache pin |
| latch: messages |
| latch: MQL Tracking Latch |
| latch: object queue header heap |
| latch: object queue header operation |
| latch: parallel query alloc buffer |
| latch: redo allocation |
| latch: redo copy |
| latch: redo writing |
| latch: row cache objects |
| latch: session allocation |
| latch: shared pool |
| latch: undo global data |
| latch: virtual circuit queues |
| library cache revalidation |
| lock close |
| lock release pending |
| lock remastering |
| log write(even) |
| log write(odd) |
| master exit |
| master wait |
| MMON (Lite) shutdown |
| MMON slave messages |
| MRP wait on archivelog archival |
| MRP wait on archivelog arrival |
| MRP wait on archivelog delay |
| MRP wait on process death |
| MRP wait on process restart |
| MRP wait on process start |
| MRP wait on startup clear |
| MRP wait on state change |
| MRP wait on state n_a |
| MRP wait on state reset |
| no free buffers |
| no free locks |
| OLAP Aggregate Client Deq |
| OLAP Aggregate Client Enq |
| OLAP Aggregate Master Deq |
| OLAP Aggregate Master Enq |
| OLAP Null PQ Reason |
| OLAP Parallel Temp Grew |
| OLAP Parallel Temp Grow Request |
| OLAP Parallel Temp Grow Wait |
| OLAP Parallel Type Deq |
| pi renounce write complete |
| process shutdown |
| PX Deq: kdcphc_ack |
| PX Deq: kdcph_mai |
| qerex_gdml |
| Queue Monitor IPC wait |
| Queue Monitor Shutdown Wait |
| Queue Monitor Slave Wait |
| Queue Monitor Task Wait |
| Queue Monitor Wait |
| queue slave messages |
| read by other session |
| recovery area: computing applied logs |
| recovery area: computing backed up files |
| recovery area: computing dropped files |
| recovery area: computing identical files |
| recovery area: computing obsolete files |
| resmgr:become active |
| resmgr:cpu quantum |
| resmgr:internal state change |
| resmgr:internal state cleanup |
| resmgr:sessions to exit |
| rfc_open_retry |
| rfi_drcx_site_del |
| rfi_insv_shut |
| rfi_insv_start |
| rfi_nsv_deldef |
| rfi_nsv_md_close |
| rfi_nsv_md_write |
| rfi_nsv_postdef |
| rfi_nsv_shut |
| rfi_nsv_start |
| rfi_recon1 |
| rfi_recon2 |
| rfm_dmon_last_gasp |
| rfm_dmon_pdefer |
| rfm_dmon_shut |
| rfm_dmon_timeout_op |
| rfm_pmon_dso_stall |
| rfrdb_dbop |
| rfrdb_recon1 |
| rfrdb_recon2 |
| rfrdb_try235 |
| rfrla_lapp1 |
| rfrla_lapp2 |
| rfrla_lapp3 |
| rfrla_lapp4 |
| rfrla_lapp5 |
| rfrm_dbcl |
| rfrm_dbop |
| rfrm_nonzero_sub_count |
| rfrm_rsm_shut |
| rfrm_rsm_so_attach |
| rfrm_rsm_start |
| rfrm_stall |
| rfrm_zero_sub_count |
| rfrpa_mrpdn |
| rfrpa_mrpup |
| rfrxpt_pdl |
| RFS announce |
| RFS attach |
| RFS close |
| RFS create |
| RFS detach |
| RFS dispatch |
| RFS ping |
| RFS register |
| RFS write |
| rollback operations active |
| rollback operations block full |
| RVWR wait for flashback copy |
| simulated log write delay |
| STREAMS apply slave idle wait |
| Streams: Wait for inter instance ack |
| SWRF RWM Auto Capture Event |
| SWRF Wait on Flushing |
| Sync ASM rebalance |
| test long ops |
| unspecified wait event |
| wait active processes |
| wait for change |
| wait for EMON to die |
| wait for EMON to process ntfns |
| wait for resize request completion |
| wait for scn ack |
| wait for SGA component shrink |
| wait for sga_target resize |
| Wait for shrink lock |
| Wait for shrink lock2 |
| Wait for Table Lock |
| Wait for TT enqueue |
| Wait on stby instance close |
| waiting for low memory condition to be resolved |
| waiting for subscribers to catch up |
| wakeup blocked enqueuers |
