待機イベント一覧
19cまでの待機ベント一覧です。・P1~P3は待機イベントの補足情報でV$SESSION_WAITやV$ACTIVE_SESSION_HISTORY(10g~)を問い合わせることでそのタイミングの補足情報を確認することができます。
・wait classは待機イベントの分類を表します。
・バージョン間でP1~P3の値が変更されたものは重複表示されます。
version: class:
version | name | p1 | p2 | p3 | class |
---|---|---|---|---|---|
12cR2-19c | ADG instance recovery complete | Other | |||
12cR2-19c | ADG query scn advance | Other | |||
12cR2-19c | ADG switchover completion | pdbid | Other | ||
11gR2-19c | ADR block file read | Other | |||
11gR2-19c | ADR block file write | Other | |||
11gR2-19c | ADR file lock | Other | |||
12cR1-19c | AQ Background Master: slave start | Other | |||
12cR1-19c | AQ Cross Master idle | Idle | |||
10gR1-10gR1 | AQ Deallocate Wait | Configuration | |||
12cR2-19c | AQ OPT Operation Complete | subshard | skiplist | Other | |
10gR1-10gR1 | AQ Proxy Cleanup Wait | Idle | |||
12cR1-19c | AQ master shutdown | Other | |||
12cR1-19c | AQ master: time mgmt/task cleanup | Other | |||
11gR1-19c | AQ propagation connection | Other | |||
12cR1-19c | AQ reload SO release | Other | |||
12cR1-19c | AQ slave: time mgmt/task cleanup | Other | |||
11gR2-19c | AQ spill debug idle | Other | |||
12cR1-19c | AQ: 12c message cache init wait | Idle | |||
12cR2-19c | AQ: RAC AQ Network | Other | |||
12cR1-19c | AQ:non durable subscriber add or drop | Other | |||
12cR1-19c | AQPC idle | Idle | |||
12cR1-19c | AQPC: new master | Other | |||
12cR1-19c | ARCH Remote Write | Other | |||
9i-11gR1 | ARCH random i/o | System I/O | |||
9i-11gR1 | ARCH sequential i/o | System I/O | |||
10gR1-12cR1 | ARCH wait for archivelog lock | Other | |||
10gR1-19c | ARCH wait for flow-control | Network | |||
10gR1-19c | ARCH wait for net re-connect | Network | |||
10gR1-19c | ARCH wait for netserver detach | Network | |||
10gR1-11gR1 | ARCH wait for netserver init 1 | Network | |||
10gR1-19c | ARCH wait for netserver init 2 | Network | |||
10gR1-19c | ARCH wait for netserver start | Network | |||
10gR1-10gR2 | ARCH wait for pending I/Os | System I/O | |||
10gR1-12cR2 | ARCH wait for process death 1 | Other | |||
10gR1-11gR1 | ARCH wait for process death 2 | Other | |||
10gR1-11gR1 | ARCH wait for process death 3 | Other | |||
10gR1-11gR1 | ARCH wait for process death 4 | Other | |||
10gR1-11gR1 | ARCH wait for process death 5 | Other | |||
10gR1-12cR2 | ARCH wait for process start 1 | Other | |||
10gR1-11gR1 | ARCH wait for process start 2 | Other | |||
10gR1-12cR2 | ARCH wait for process start 3 | Other | |||
10gR1-11gR1 | ARCH wait for process start 4 | Other | |||
9i-11gR2 | ARCH wait on ATTACH | Network | |||
9i-11gR2 | ARCH wait on DETACH | Network | |||
9i-11gR2 | ARCH wait on SENDREQ | Network | |||
10gR1-19c | ARCH wait on c/f tx acquire 1 | Other | |||
10gR1-11gR1 | ARCH wait on c/f tx acquire 2 | Other | |||
12cR2-19c | ASM Async Scrub | Other | |||
10gR2-19c | ASM COD rollback operation completion | dismount force | Administrative | ||
11gR2-12cR1 | ASM DG Unblock | Other | |||
19c-19c | ASM File Group Sync | op | gn | pdbid | User I/O |
11gR2-19c | ASM Fixed Package I/O | blkno | bytes | filetype | User I/O |
19c-19c | ASM IO for non-blocking poll | count | where | timeout | User I/O |
11gR2-19c | ASM Instance startup | Other | |||
12cR1-19c | ASM PST operation | op | Other | ||
10gR1-19c | ASM PST query : wait for [PM][grp][0] grant | Cluster | |||
19c-19c | ASM Scrub Running | Other | |||
12cR2-19c | ASM Scrub Stop | Other | |||
12cR1-19c | ASM Scrubbing I/O | blkno | bytes | filetype | Other |
11gR2-19c | ASM Staleness File I/O | blkno | #blks | diskno | User I/O |
11gR1-19c | ASM Volume Background | Other | |||
12cR1-19c | ASM Volume Resource Action | Other | |||
12cR1-19c | ASM async relocation I/O | count | where | file | System I/O |
10gR1-11gR1 | ASM background running | Other | |||
10gR1-19c | ASM background starting | Other | |||
10gR1-19c | ASM background timer | Idle | |||
12cR2-19c | ASM check disk slices | group# | Other | ||
11gR2-19c | ASM cluster file access | lock | mode | Other | |
12cR2-19c | ASM cluster membership changes | Idle | |||
12cR2-19c | ASM concurrent diskgroup dismount | Other | |||
10gR1-19c | ASM db client exists | Other | |||
11gR1-19c | ASM file metadata operation | msgop | locn | Other | |
10gR2-19c | ASM internal hang test | test # | Other | ||
19c-19c | ASM ioctl to dematerialize blocks | OSS FD | where | timeout | Other |
11gR1-12cR2 | ASM metadata cache frozen | group# | Other | ||
19c-19c | ASM metadata cache frozen | group# | obj# | block# | Other |
10gR1-19c | ASM mount : wait for heartbeat | Administrative | |||
11gR1-19c | ASM network foreground exits | group# | Other | ||
12cR1-19c | ASM remote SQL | Network | |||
12cR1-19c | ASM sync cache disk read | group | obj | block | User I/O |
12cR1-19c | ASM sync relocation I/O | count | where | file | System I/O |
12cR1-19c | ASM volume directive send | msgop | dg | vol | Other |
11gR2-19c | ASM: MARK subscribe to msg channel | Other | |||
11gR1-19c | ASM: OFS Cluster membership update | Other | |||
12cR1-19c | ASM: Send msg to MARK | group# | dginc | Other | |
19c-19c | ASM: VAM activation | group# | Other | ||
19c-19c | ASMB cookie valid check | Other | |||
12cR1-19c | ASYNC Remote Write | Other | |||
10gR2-19c | AWR Flush | Other | |||
10gR2-19c | AWR Metric Capture | Other | |||
12cR2-19c | Analyze hash compare | Other | |||
11gR2-19c | Archive Manager file transfer I/O | count | intr | timeout | User I/O |
11gR1-19c | Archiver slave I/O | wait count | wait flags | timeout | System I/O |
11gR2-19c | Auto BMR RPC standby catchup | wrap | base | Other | |
11gR2-19c | Auto BMR completion | file# | block# | Other | |
12cR1-12cR1 | Availability Machine container I/O | requests | Other | ||
12cR1-12cR1 | Availability Machine container synchronous read | block# | blocks | Other | |
12cR1-12cR1 | Availability Machine container synchronous write | block# | blocks | Other | |
12cR2-19c | BA: Performance API | Administrative | |||
8i-19c | BFILE check if exists | Other | |||
8i-19c | BFILE check if open | Other | |||
8i-19c | BFILE closure | Other | |||
8i-19c | BFILE get length | Other | |||
8i-19c | BFILE get name object | Other | |||
8i-19c | BFILE get path object | Other | |||
8i-19c | BFILE internal seek | Other | |||
8i-19c | BFILE open | Other | |||
8i-19c | BFILE read | User I/O | |||
12cR2-19c | Backup Appliance Comm SGA setup wait | session_id | serial | Idle | |
12cR2-19c | Backup Appliance Servlet wait | session_id | serial | Idle | |
12cR2-19c | Backup Appliance Surrogate wait | session_id | serial | Idle | |
12cR2-19c | Backup Appliance container I/O | requests | Other | ||
12cR2-19c | Backup Appliance container synchronous read | block# | blocks | Other | |
12cR2-19c | Backup Appliance container synchronous write | block# | blocks | Other | |
12cR2-19c | Backup Appliance waiting for work | session_id | serial | Idle | |
12cR2-19c | Backup Appliance waiting restore start | session_id | serial | Idle | |
11gR2-12cR1 | Backup Restore Event 19778 sleep | session_id | serial | Other | |
12cR2-19c | Backup Restore Event sleep | session_id | serial | Other | |
11gR2-19c | Backup Restore Switch Bitmap sleep | session_id | serial | Other | |
11gR2-19c | Backup Restore Throttle sleep | session_id | serial | Other | |
11gR2-19c | Backup: MML command to channel | Administrative | |||
11gR2-19c | Backup: MML commit backup piece | Administrative | |||
11gR2-19c | Backup: MML create a backup piece | Administrative | |||
11gR2-19c | Backup: MML data movement done? | Administrative | |||
11gR2-19c | Backup: MML datafile proxy backup? | Administrative | |||
11gR2-19c | Backup: MML datafile proxy restore? | Administrative | |||
11gR2-19c | Backup: MML delete backup piece | Administrative | |||
11gR2-19c | Backup: MML extended initialization | Administrative | |||
11gR2-19c | Backup: MML get base address | Administrative | |||
11gR2-19c | Backup: MML initialization | Administrative | |||
11gR2-19c | Backup: MML obtain a direct buffer | Administrative | |||
11gR2-19c | Backup: MML obtain textual error | Administrative | |||
11gR2-19c | Backup: MML proxy cancel | Administrative | |||
11gR2-19c | Backup: MML proxy commit backup piece | Administrative | |||
11gR2-19c | Backup: MML proxy initialize backup | Administrative | |||
11gR2-19c | Backup: MML proxy initialize restore | Administrative | |||
11gR2-19c | Backup: MML proxy prepare to start | Administrative | |||
11gR2-19c | Backup: MML proxy session end | Administrative | |||
11gR2-19c | Backup: MML proxy start data movement | Administrative | |||
11gR2-19c | Backup: MML query backup piece | Administrative | |||
11gR2-19c | Backup: MML query for direct buffers | Administrative | |||
11gR2-19c | Backup: MML read backup piece | Administrative | |||
11gR2-19c | Backup: MML release a direct buffer | Administrative | |||
11gR2-19c | Backup: MML restore backup piece | Administrative | |||
11gR2-19c | Backup: MML shutdown | Administrative | |||
11gR2-19c | Backup: MML v1 close backup piece | Administrative | |||
11gR2-19c | Backup: MML v1 delete backup piece | Administrative | |||
11gR2-19c | Backup: MML v1 open backup piece | Administrative | |||
11gR2-19c | Backup: MML v1 query backup piece | Administrative | |||
11gR2-19c | Backup: MML v1 read backup piece | Administrative | |||
11gR2-19c | Backup: MML v1 write backup piece | Administrative | |||
11gR2-19c | Backup: MML write backup piece | Administrative | |||
10gR1-11gR1 | Backup: sbtbackup | Administrative | |||
11gR1-11gR1 | Backup: sbtbufinfo | Administrative | |||
10gR1-11gR1 | Backup: sbtclose | Administrative | |||
10gR1-11gR1 | Backup: sbtclose2 | Administrative | |||
10gR1-11gR1 | Backup: sbtcommand | Administrative | |||
10gR1-11gR1 | Backup: sbtend | Administrative | |||
10gR1-11gR1 | Backup: sbterror | Administrative | |||
11gR1-11gR1 | Backup: sbtgetbuf | Administrative | |||
10gR1-11gR1 | Backup: sbtinfo | Administrative | |||
10gR1-11gR1 | Backup: sbtinfo2 | Administrative | |||
10gR1-11gR1 | Backup: sbtinit | Administrative | |||
10gR1-11gR1 | Backup: sbtinit2 | Administrative | |||
11gR1-11gR1 | Backup: sbtmapbuf | Administrative | |||
10gR1-11gR1 | Backup: sbtopen | Administrative | |||
10gR1-11gR1 | Backup: sbtpcbackup | Administrative | |||
10gR1-11gR1 | Backup: sbtpccancel | Administrative | |||
10gR1-11gR1 | Backup: sbtpccommit | Administrative | |||
10gR1-11gR1 | Backup: sbtpcend | Administrative | |||
10gR1-11gR1 | Backup: sbtpcquerybackup | Administrative | |||
10gR1-11gR1 | Backup: sbtpcqueryrestore | Administrative | |||
10gR1-11gR1 | Backup: sbtpcrestore | Administrative | |||
10gR1-11gR1 | Backup: sbtpcstart | Administrative | |||
10gR1-11gR1 | Backup: sbtpcstatus | Administrative | |||
10gR1-11gR1 | Backup: sbtpcvalidate | Administrative | |||
10gR1-11gR1 | Backup: sbtread | Administrative | |||
10gR1-11gR1 | Backup: sbtread2 | Administrative | |||
11gR1-11gR1 | Backup: sbtrelbuf | Administrative | |||
10gR1-11gR1 | Backup: sbtremove | Administrative | |||
10gR1-11gR1 | Backup: sbtremove2 | Administrative | |||
10gR1-11gR1 | Backup: sbtrestore | Administrative | |||
10gR1-11gR1 | Backup: sbtwrite | Administrative | |||
10gR1-11gR1 | Backup: sbtwrite2 | Administrative | |||
12cR1-19c | CDB: Per Instance Query for PDB Info | Other | |||
12cR2-19c | CGS ping operation | location | Other | ||
9i-19c | CGS skgxn join retry | retry count | Other | ||
9i-19c | CGS wait for IPC msg | Other | |||
11gR2-19c | CRS call completion | clsrrestype | kjha_action | Other | |
11gR2-19c | CSS Xgrp shared operation | function_id | Other | ||
19c-19c | CSS cookie check | Other | |||
11gR2-19c | CSS group membership query | group_name1 | group_name2 | group_name3 | Other |
11gR2-19c | CSS group registration | group_name1 | group_name2 | mem_id | Other |
11gR2-19c | CSS initialization | Other | |||
11gR2-19c | CSS operation: action | function_id | Other | ||
11gR2-19c | CSS operation: data query | function_id | Other | ||
11gR2-19c | CSS operation: data update | function_id | Other | ||
11gR2-19c | CSS operation: diagnostic | function_id | Other | ||
11gR2-19c | CSS operation: query | function_id | Other | ||
11gR2-19c | CTWR media recovery checkpoint request | Other | |||
8i-8i | Cache simulator heap | ||||
12cR1-19c | Clonedb bitmap file write | blkno | size | System I/O | |
10gR1-19c | Cluster Suspension wait | Other | |||
11gR1-19c | Cluster stabilization wait | Other | |||
10gR1-10gR2 | Cluster stablization wait | Other | |||
11gR2-19c | Compression analysis | Other | |||
8i-8i | Contacting SCN server or SCN lock master | ||||
12cR2-19c | Cube Build Master Wait for Jobs | Concurrency | |||
19c-19c | DB Split Delay | Other | |||
10gR1-11gR1 | DBFG waiting for reply | Other | |||
10gR1-19c | DBMS_LDAP: LDAP operation | Other | |||
12cR1-19c | DBMS_ROLLING instruction completion | Instruction id | Other | ||
11gR1-19c | DBWR range invalidation sync | dbwr# | Other | ||
11gR1-19c | DBWR slave I/O | wait count | wait flags | timeout | System I/O |
19c-19c | DBWR timer | Idle | |||
8i-19c | DFS db file lock | file# | Other | ||
8i-19c | DFS lock handle | type|mode | id1 | id2 | Other |
10gR2-19c | DG Broker configuration file I/O | count | intr | timeout | User I/O |
9i-9i | DIAG dummy wait | ||||
10gR1-19c | DIAG idle wait | component | where | wait time(millisec) | Idle |
12cR1-12cR1 | DIAG lock acquisition | Other | |||
12cR2-19c | DIAG lock acquisition | where | Other | ||
12cR1-19c | DLM Omni Enq Owner replication | Owner ID | Other | ||
12cR1-19c | DLM cross inst call completion | caller instance number | cluster incarnation number | request identifier | Other |
12cR1-19c | DLM enqueue copy completion | Owner ID | op|restype | id1|id2 | Other |
8i-8i | DLM generic wait event | ||||
10gR1-10gR1 | DLM lock cancel | le | Other | ||
10gR1-10gR1 | DLM lock cvt S | group | obj# | block# | Other |
10gR1-10gR1 | DLM lock cvt X | group | obj# | block# | Other |
10gR1-10gR1 | DLM lock esc | group | obj# | block# | Other |
10gR1-10gR1 | DLM lock esc X | group | obj# | block# | Other |
10gR1-10gR1 | DLM lock open | group | obj# | block# | Other |
10gR1-10gR1 | DLM lock open S | group | obj# | block# | Other |
10gR1-10gR1 | DLM lock open X | group | obj# | block# | Other |
10gR1-10gR1 | DLM recovery lock convert | group | obj# | block# | Other |
10gR1-10gR1 | DLM recovery lock open | group | obj# | block# | Other |
12cR1-19c | DLM: shared instance mode init | Other | |||
12cR2-19c | DNFS disp IO slave cleanup | clmn pnum | Other | ||
12cR2-19c | DNFS disp IO slave completion | pnum | User I/O | ||
12cR2-19c | DNFS disp IO slave idle | Idle | |||
12cR1-19c | DSKM to complete cell health check | Other | |||
11gR1-19c | Data Guard Broker Wait | Broker Component | Wait Argument 1 | Wait Argument 2 | Other |
10gR2-10gR2 | Data Guard broker: single instance | Data Guard broker: single instance | Other | ||
10gR1-10gR2 | Data Guard broker: wait upon ORA-12850 error | waiting for retrying the query to mask ORA-12850 error | Other | ||
12cR2-19c | Data Guard network buffer stall reap | Network | |||
12cR1-19c | Data Guard server operation completion | Other | |||
12cR2-19c | Data Guard: Gap Manager | Idle | |||
12cR1-12cR2 | Data Guard: RFS disk I/O | Other | |||
12cR2-19c | Data Guard: Timer | Idle | |||
12cR2-19c | Data Guard: controlfile update | Idle | |||
10gR2-12cR2 | Data Guard: process clean up | Other | |||
10gR2-12cR2 | Data Guard: process exit | Other | |||
12cR2-19c | Data Guard: rtrt work | Other | |||
11gR2-19c | Data Pump slave init | Other | |||
11gR2-19c | Data Pump slave startup | Other | |||
10gR2-19c | Data file init write | count | intr | timeout | User I/O |
10gR2-19c | Datapump dump file I/O | count | intr | timeout | User I/O |
11gR2-19c | Disk file I/O Calibration | count | User I/O | ||
11gR2-19c | Disk file Mirror Read | fileno | blkno | filetype | User I/O |
11gR2-19c | Disk file Mirror/Media Repair Write | fileno | blkno | filetype | User I/O |
11gR2-19c | Disk file operations I/O | FileOperation | fileno | filetype | User I/O |
10gR2-10gR2 | EMON idle wait | Idle | |||
11gR1-19c | EMON slave idle wait | Idle | |||
11gR1-11gR2 | EMON slave messages | Other | |||
11gR1-19c | EMON termination | Other | |||
12cR1-19c | Emon coordinator main loop | Idle | |||
12cR1-19c | Emon coordinator startup | Other | |||
12cR1-19c | Emon slave main loop | Idle | |||
11gR2-12cR1 | External Procedure call | Application | |||
12cR2-19c | External Procedure call | HS_SESSION_ID | Application | ||
11gR2-19c | External Procedure initial connection | Application | |||
10gR2-19c | FAL archive wait 1 sec for REOPEN minimum | Other | |||
12cR2-19c | Failed Logon Delay | Other | |||
12cR1-19c | File Copy | count | intr | timeout | User I/O |
19c-19c | File Directory Use | Other | |||
12cR2-19c | File Repopulation Write | filename_hash | blkno | System I/O | |
10gR1-10gR1 | Flow Control Event | Other | |||
12cR2-19c | GCR CSS group join | retry count | Other | ||
12cR2-19c | GCR CSS group leave | Other | |||
12cR2-19c | GCR CSS group lock | Other | |||
12cR2-19c | GCR CSS group query | Other | |||
12cR2-19c | GCR CSS group update | Other | |||
12cR1-12cR1 | GCR CSS join retry | retry count | Other | ||
12cR1-19c | GCR ctx lock acquisition | retry count | Other | ||
12cR1-12cR1 | GCR lock acquisition | Other | |||
12cR1-12cR1 | GCR member Data from CSS | retry count | Other | ||
12cR1-12cR1 | GCR sleep | lock retry count | Idle | ||
12cR2-19c | GCR sleep | Idle | |||
10gR2-19c | GCS lock cancel | le | Other | ||
10gR2-19c | GCS lock cvt S | group | obj# | block# | Other |
10gR2-19c | GCS lock cvt X | group | obj# | block# | Other |
10gR2-19c | GCS lock esc | group | obj# | block# | Other |
10gR2-19c | GCS lock esc X | group | obj# | block# | Other |
10gR2-19c | GCS lock open | group | obj# | block# | Other |
10gR2-19c | GCS lock open S | group | obj# | block# | Other |
10gR2-19c | GCS lock open X | group | obj# | block# | Other |
10gR2-19c | GCS recovery lock convert | group | obj# | block# | Other |
10gR2-19c | GCS recovery lock open | group | obj# | block# | Other |
11gR2-19c | GIPC operation: dump | function_id | Other | ||
12cR2-19c | GL: cross instance latch free | Other | |||
11gR2-19c | GPnP Get Error | Other | |||
11gR2-19c | GPnP Get Item | Other | |||
11gR2-19c | GPnP Initialization | Other | |||
11gR2-19c | GPnP Set Item | Other | |||
11gR2-19c | GPnP Termination | Other | |||
10gR1-19c | GV$: slave acquisition retry wait time | Other | |||
11gR1-19c | Global transaction acquire instance locks | retries | Configuration | ||
9i-19c | HS message to agent | Idle | |||
19c-19c | IM ADG space pressure | bucket#|slave# | retry# | count | Other |
12cR2-19c | IM ADO scheduler retry | Other | |||
12cR2-19c | IM CU busy | Other | |||
12cR2-19c | IM FastStart deadlock retry | Other | |||
12cR2-19c | IM buffer busy | Concurrency | |||
12cR2-19c | IM buffer busy SHR | Concurrency | |||
12cR2-19c | IM buffer busy TXN | Concurrency | |||
12cR2-19c | IM populate completion | Other | |||
19c-19c | IMCDT end of scans cleanup | session id | Other | ||
12cR2-19c | IMFS Flush defer writes | Other | |||
12cR2-19c | IMFS defer writes scheduler | Idle | |||
11gR2-19c | IMR CSS join retry | retry count | Other | ||
11gR2-19c | IMR disk votes | Other | |||
19c-19c | IMR hang simulation | Other | |||
11gR2-19c | IMR membership resolution | Other | |||
11gR2-19c | IMR mount phase II completion | Other | |||
11gR2-19c | IMR net-check message ack | Other | |||
11gR2-19c | IMR rr lock release | Other | |||
11gR2-19c | IMR rr update | Other | |||
12cR2-19c | IMR slave acknowledgement msg | Other | |||
12cR2-19c | IMR slave process init | Other | |||
12cR2-19c | IMR slave process shutdown | location | Other | ||
19c-19c | IMXT Populate - drop HT | Other | |||
8i-8i | IO clients wait for LMON to join GMS group | ||||
11gR1-19c | IORM Scheduler Slave Idle Wait | Idle | |||
12cR2-19c | IOS client reconnect to dif IOS | Other | |||
12cR2-19c | IOS worker process exit | process type | process number | Other | |
12cR2-19c | IOS worker process startup | process type | process number | Other | |
9i-19c | IPC busy async request | Other | |||
19c-19c | IPC group service call | function id | Network | ||
9i-19c | IPC send completion sync | send count | Other | ||
9i-19c | IPC wait for name service busy | Other | |||
9i-19c | IPC waiting for OSD resources | Other | |||
12cR1-19c | Image redo gen delay | Other | |||
12cR2-19c | In-Memory populate: over pga limit | process number | serial number | Other | |
12cR2-19c | Inmemory Populate: get loadscn | Concurrency | |||
12cR2-19c | JAVA patching | Other | |||
11gR1-19c | JOX Jit Process Sleep | Idle | |||
10gR1-19c | JS coord start wait | Other | |||
10gR1-19c | JS external job | Idle | |||
10gR1-19c | JS kgl get object wait | Other | |||
10gR1-19c | JS kill job wait | Other | |||
12cR2-19c | KA: shared KGA not initialized | Other | |||
9i-9i | KJC: Wait for msg sends to complete | ||||
10gR1-19c | KJC: Wait for msg sends to complete | msg | dest|rcvr | mtype | Other |
8i-8i | KSIM GDS request cancel | ||||
10gR1-11gR2 | KSV master wait | Idle | |||
12cR1-19c | KSV master wait | indicator | Other | ||
10gR1-19c | Kupp process shutdown | nalive | sleeptime | loop | Other |
9i-19c | L1 validation | seghdr | l1bmb | Other | |
12cR2-19c | LCK0 row cache object free | heap ds | min_size | clatch | Concurrency |
11gR2-12cR2 | LGWR ORL/NoExp FAL archival | Other | |||
12cR1-19c | LGWR all worker groups | Other | |||
12cR1-19c | LGWR any worker group | Other | |||
12cR1-19c | LGWR intra group IO completion | where | groupid | slaveid | Other |
12cR1-19c | LGWR intra group sync | where | groupid | slaveid | Other |
9i-11gR1 | LGWR random i/o | System I/O | |||
11gR2-19c | LGWR real time apply sync | Idle | |||
9i-11gR1 | LGWR sequential i/o | System I/O | |||
9i-19c | LGWR simulation latency wait | Other | |||
11gR1-19c | LGWR slave I/O | wait count | wait flags | timeout | System I/O |
8i-19c | LGWR wait for redo copy | copy latch # | Other | ||
9i-11gR2 | LGWR wait on ATTACH | Network | |||
9i-11gR2 | LGWR wait on DETACH | Network | |||
9i-19c | LGWR wait on LNS | Network | |||
9i-11gR2 | LGWR wait on SENDREQ | Network | |||
9i-11gR1 | LGWR wait on full LNS buffer | Other | |||
12cR1-19c | LGWR worker group idle | group_id | slave_id | Idle | |
12cR1-19c | LGWR worker group ordering | lwn_id | phase | Other | |
9i-19c | LGWR-LNS wait on channel | Other | |||
19c-19c | LMA KGA glob lock acquisition | lock | retry count | Other | |
19c-19c | LMA glob lock acquisition | lock | retry count | Other | |
19c-19c | LMFC reconfig operation | RCFG State | Operation | Other | |
10gR2-19c | LMON global data update | Other | |||
8i-8i | LMON wait for LMD to inherit communication channels | ||||
12cR2-19c | LMS CR slave timer | type | Idle | ||
10gR2-19c | LNS ASYNC archive log | Idle | |||
10gR2-11gR1 | LNS ASYNC control file txn | System I/O | |||
10gR2-19c | LNS ASYNC dest activation | Idle | |||
10gR2-19c | LNS ASYNC end of log | Idle | |||
9i-19c | LNS simulation latency wait | Other | |||
9i-11gR1 | LNS wait for LGWR redo | Other | |||
9i-11gR2 | LNS wait on ATTACH | Network | |||
9i-11gR2 | LNS wait on DETACH | Network | |||
9i-19c | LNS wait on LGWR | Network | |||
9i-11gR2 | LNS wait on SENDREQ | Network | |||
10gR2-19c | Log archive I/O | count | intr | timeout | System I/O |
10gR2-19c | Log file init write | count | intr | timeout | User I/O |
12cR2-19c | LogMiner FSC: dictionary load completion | Session ID | Other | ||
11gR2-19c | LogMiner builder: DDL | Session ID | Queueing | ||
11gR2-19c | LogMiner builder: branch | Session ID | Idle | ||
11gR2-19c | LogMiner builder: idle | Session ID | Idle | ||
11gR2-19c | LogMiner builder: memory | Session ID | Queueing | ||
19c-19c | LogMiner builder: queue full | Session ID | Other | ||
11gR2-19c | LogMiner client: transaction | Session ID | Idle | ||
19c-19c | LogMiner merger: idle | Session ID | Thread | Idle | |
19c-19c | LogMiner merger: redo slot | Session ID | Other | ||
11gR2-19c | LogMiner preparer: idle | Session ID | Idle | ||
11gR2-19c | LogMiner preparer: memory | Session ID | Queueing | ||
11gR2-19c | LogMiner reader: buffer | Session ID | Queueing | ||
11gR2-19c | LogMiner reader: log (idle) | Session ID | Thread | Sequence | Idle |
19c-19c | LogMiner reader: memory | Session ID | Other | ||
11gR2-19c | LogMiner reader: redo (idle) | Session ID | Thread | Sequence | Idle |
19c-19c | LogMiner reader: redo slot | Session ID | Thread | Other | |
11gR2-19c | LogMiner: activate | Session ID | Idle | ||
11gR1-11gR1 | LogMiner: builder idle | Session ID | Idle | ||
10gR2-10gR2 | LogMiner: client waiting for transaction | Idle | |||
11gR1-11gR1 | LogMiner: client waiting for transaction | Session ID | Idle | ||
11gR2-19c | LogMiner: find session | Session ID | Idle | ||
11gR1-11gR1 | LogMiner: generic process sleep | Caller ID | Idle | ||
11gR2-19c | LogMiner: internal | Caller ID | Idle | ||
11gR2-19c | LogMiner: other | Session ID | Idle | ||
11gR1-11gR1 | LogMiner: preparer idle | Session ID | Idle | ||
19c-19c | LogMiner: queue | Session ID | Lock | State | Other |
11gR1-11gR1 | LogMiner: reader idle | Session ID | Idle | ||
10gR2-11gR1 | LogMiner: reader waiting for more redo | Session ID | Thread | Sequence | Idle |
11gR2-19c | LogMiner: reset | Caller ID | Idle | ||
19c-19c | LogMiner: session audit list | Session ID | Lock | State | Other |
10gR2-10gR2 | LogMiner: slave waiting for activate message | Idle | |||
11gR1-11gR1 | LogMiner: slave waiting for activate message | Session ID | Idle | ||
19c-19c | LogMiner: txn | Session ID | Lock | State | Other |
11gR1-11gR1 | LogMiner: waiting for processes to soft detach | Caller ID | Idle | ||
11gR1-11gR1 | LogMiner: waiting for redo from new branch | Other | |||
11gR1-11gR1 | LogMiner: waiting for session to become visible | Other | |||
10gR2-10gR2 | LogMiner: wakeup event for builder | Idle | |||
10gR2-10gR2 | LogMiner: wakeup event for preparer | Idle | |||
10gR2-10gR2 | LogMiner: wakeup event for reader | Idle | |||
11gR1-19c | Logical Standby Apply Delay | Idle | |||
10gR2-19c | Logical Standby Apply shutdown | Other | |||
11gR1-19c | Logical Standby Debug | event | Other | ||
10gR2-19c | Logical Standby Terminal Apply | stage | Other | ||
10gR2-19c | Logical Standby dictionary build | Other | |||
10gR2-19c | Logical Standby pin transaction | xidusn | xidslt | xidsqn | Other |
19c-19c | Long operation CF pause | Other | |||
10gR1-19c | MMON (Lite) shutdown | process# | waited | Other | |
10gR1-19c | MMON slave messages | Other | |||
12cR1-19c | MRP inactivation | Other | |||
11gR1-19c | MRP redo arrival | Idle | |||
12cR1-12cR1 | MRP state inspection | Other | |||
12cR2-19c | MRP stop | Other | |||
12cR1-12cR1 | MRP termination | Other | |||
10gR1-19c | MRP wait on archivelog archival | Other | |||
10gR1-19c | MRP wait on archivelog arrival | Other | |||
10gR1-11gR2 | MRP wait on archivelog delay | Other | |||
10gR1-11gR2 | MRP wait on process death | Other | |||
10gR1-19c | MRP wait on process restart | Other | |||
10gR1-19c | MRP wait on process start | Other | |||
10gR1-19c | MRP wait on startup clear | Other | |||
10gR1-11gR2 | MRP wait on state change | Other | |||
10gR1-11gR2 | MRP wait on state n_a | Other | |||
10gR1-11gR2 | MRP wait on state reset | Other | |||
19c-19c | Memory: Reg/Dereg | ksmsq context | address | length | Other |
12cR2-19c | Monitor testing | Other | |||
11gR1-19c | NFS read delegation outstanding | delegation count | Other | ||
19c-19c | Nest operation | Other | |||
11gR1-19c | Network file transfer | count | intr | timeout | System I/O |
19c-19c | Nologging Standby Unit Test | Other | |||
19c-19c | Nologging standby progress | Primary client SCN | Max wait in centi-seconds | Commit | |
12cR2-12cR2 | Nonlogged block fetch | Absolute file | Start block | Request number | Other |
19c-19c | Nonlogged block fetch | Absolute file | Start block | RCVID or Request | Other |
8i-8i | Null event | ||||
12cR2-19c | OFS Receive Queue | Idle | |||
12cR1-19c | OFS idle | Idle | |||
12cR2-19c | OFS interrupted req not found | Other | |||
12cR1-19c | OFS operation completion | Administrative | |||
11gR2-19c | OJVM: Generic | Other | |||
10gR1-12cR1 | OLAP Aggregate Client Deq | sleeptime/senderid | passes | Other | |
10gR1-12cR1 | OLAP Aggregate Client Enq | sleeptime/senderid | passes | Other | |
10gR1-12cR1 | OLAP Aggregate Master Deq | sleeptime/senderid | passes | Other | |
10gR1-12cR1 | OLAP Aggregate Master Enq | sleeptime/senderid | passes | Other | |
11gR1-19c | OLAP DML Sleep | duration | Application | ||
10gR1-12cR1 | OLAP Null PQ Reason | sleeptime/senderid | passes | Other | |
10gR1-12cR1 | OLAP Parallel Temp Grew | sleeptime/senderid | passes | Other | |
10gR1-12cR1 | OLAP Parallel Temp Grow Request | sleeptime/senderid | passes | Other | |
10gR1-12cR1 | OLAP Parallel Temp Grow Wait | sleeptime/senderid | passes | Other | |
10gR1-12cR1 | OLAP Parallel Type Deq | sleeptime/senderid | passes | Other | |
12cR1-12cR1 | ORS: Performance API | Administrative | |||
11gR1-19c | OSD IPC library | rolling mig | Other | ||
19c-19c | PBR logfile IO | File ID | blk | nbytes | System I/O |
19c-19c | PBR logfile block write | File ID | blk | pbridx | System I/O |
12cR2-19c | PCFC: recovery domain valid | Other | |||
12cR2-12cR2 | PDB close abort completion | Other | |||
19c-19c | PDB close/open on another instance | Other | |||
12cR2-19c | PDB lock domain invalidation | Other | |||
12cR2-19c | PDB relocate completion | pdbid | Other | ||
12cR2-19c | PGA memory operation | Other | |||
11gR1-19c | PING | Idle | |||
8i-19c | PL/SQL lock timer | duration | Idle | ||
11gR1-19c | PMON to cleanup detached branches at shutdown | Other | |||
10gR2-19c | PMON to cleanup pseudo-branches at svc stop time | Other | |||
11gR1-19c | PX Deq Credit: Session Stats | sleeptime/senderid | passes | Other | |
8i-19c | PX Deq Credit: free buffer | sleeptime/senderid | passes | qref | Other |
8i-19c | PX Deq Credit: need buffer | sleeptime/senderid | passes | qref | Idle |
8i-19c | PX Deq Credit: send blkd | sleeptime/senderid | passes | qref | Other |
8i-19c | PX Deq: Execute Reply | sleeptime/senderid | passes | Idle | |
8i-19c | PX Deq: Execution Msg | sleeptime/senderid | passes | Idle | |
8i-19c | PX Deq: Index Merge Close | sleeptime/senderid | passes | Idle | |
8i-19c | PX Deq: Index Merge Execute | sleeptime/senderid | passes | Idle | |
8i-19c | PX Deq: Index Merge Reply | sleeptime/senderid | passes | Idle | |
8i-19c | PX Deq: Join ACK | sleeptime/senderid | passes | Other | |
11gR2-19c | PX Deq: Metadata Update | ktelc_wait1s | Idle | ||
8i-19c | PX Deq: Msg Fragment | sleeptime/senderid | passes | Idle | |
9i-19c | PX Deq: OLAP Update Close | sleeptime/senderid | passes | Other | |
9i-19c | PX Deq: OLAP Update Execute | sleeptime/senderid | passes | Other | |
9i-19c | PX Deq: OLAP Update Reply | sleeptime/senderid | passes | Other | |
8i-10gR2 | PX Deq: Par Recov Change Vector | sleeptime/senderid | passes | Idle | |
8i-10gR2 | PX Deq: Par Recov Execute | sleeptime/senderid | passes | Idle | |
8i-10gR2 | PX Deq: Par Recov Reply | sleeptime/senderid | passes | Idle | |
8i-19c | PX Deq: Parse Reply | sleeptime/senderid | passes | Idle | |
8i-10gR2 | PX Deq: Signal ACK | sleeptime/senderid | passes | Other | |
11gR1-19c | PX Deq: Signal ACK EXT | sleeptime/senderid | passes | Other | |
11gR1-19c | PX Deq: Signal ACK RSG | sleeptime/senderid | passes | Other | |
11gR1-19c | PX Deq: Slave Join Frag | sleeptime/senderid | passes | Other | |
11gR1-19c | PX Deq: Slave Session Stats | sleeptime/senderid | passes | Other | |
8i-19c | PX Deq: Table Q Close | sleeptime/senderid | passes | Other | |
8i-19c | PX Deq: Table Q Get Keys | sleeptime/senderid | passes | Other | |
8i-19c | PX Deq: Table Q Normal | sleeptime/senderid | passes | Idle | |
8i-19c | PX Deq: Table Q Sample | sleeptime/senderid | passes | Idle | |
8i-19c | PX Deq: Table Q qref | sleeptime/senderid | passes | Other | |
11gR1-19c | PX Deq: Test for credit | sleeptime/senderid | passes | Other | |
8i-19c | PX Deq: Test for msg | sleeptime/senderid | passes | Other | |
8i-19c | PX Deq: Txn Recovery Reply | sleeptime/senderid | passes | Idle | |
8i-19c | PX Deq: Txn Recovery Start | sleeptime/senderid | passes | Idle | |
10gR1-19c | PX Deq: kdcph_mai | kdcph_mai | Idle | ||
10gR1-19c | PX Deq: kdcphc_ack | kdcphc_ack | Idle | ||
9i-19c | PX Deq: reap credit | Other | |||
8i-19c | PX Deque wait | sleeptime/senderid | passes | Idle | |
8i-19c | PX Idle Wait | sleeptime/senderid | passes | Idle | |
9i-19c | PX Nsq: PQ descriptor query | Other | |||
9i-19c | PX Nsq: PQ load info query | Other | |||
11gR2-19c | PX Queuing: statement queue | sleeptime | passes | Scheduler | |
9i-19c | PX Send Wait | Other | |||
8i-19c | PX create server | nservers | sleeptime | enqueue | Other |
11gR2-19c | PX hash elem being inserted | hashid | element | insert/update | Other |
19c-19c | PX hash key vector cell | sleeptime | passes | Other | |
12cR2-19c | PX hash key vector merge | sleeptime | passes | Other | |
19c-19c | PX key vector create dgk init | sleeptime | passes | Other | |
19c-19c | PX key vector flatten | sleeptime | passes | Other | |
19c-19c | PX key vector use load | sleeptime | passes | Other | |
8i-19c | PX qref latch | function | sleeptime | qref | Other |
8i-19c | PX server shutdown | nalive | sleeptime | loop | Other |
8i-19c | PX signal server | serial | error | nbusy | Other |
9i-19c | PX slave connection | Other | |||
9i-19c | PX slave release | Other | |||
11gR2-19c | Parameter File I/O | blkno | #blks | read/write | User I/O |
12cR1-19c | Pluggable Database file copy | count | intr | timeout | User I/O |
10gR1-10gR1 | Queue Monitor IPC wait | Idle | |||
10gR1-10gR1 | Queue Monitor Shutdown Wait | Idle | |||
10gR1-10gR1 | Queue Monitor Slave Wait | Idle | |||
10gR1-10gR1 | Queue Monitor Task Wait | Other | |||
10gR1-10gR1 | Queue Monitor Wait | Idle | |||
12cR2-19c | RAC reference partitioning descendants lock | maximum attempts | attempt count | Other | |
12cR1-19c | RAC referential constraint parent lock | maximum attempts | attempt count | Other | |
12cR2-19c | RAC: constraint DDL lock | maximum attempts | attempt count | Other | |
19c-19c | RAC: row cache lock nowait retry | stub handle | attempt count | Other | |
12cR1-19c | REPL Apply: apply DDL | 2=>GoldenGate 1=>XStream 0=>Streams | sleep time | Application | |
12cR1-19c | REPL Apply: commit | 2=>GoldenGate 1=>XStream 0=>Streams | Configuration | ||
12cR1-19c | REPL Apply: dependency | 2=>GoldenGate 1=>XStream 0=>Streams | Concurrency | ||
12cR1-19c | REPL Apply: txns | Idle | |||
12cR1-19c | REPL Capture/Apply: RAC AQ qmn coordinator | 1=>MASTER 2=>SLAVE | Idle | ||
12cR1-19c | REPL Capture/Apply: RAC inter-instance ack | 2=>GoldenGate 1=>XStream 0=>Streams | Other | ||
12cR1-19c | REPL Capture/Apply: database startup | 2=>GoldenGate 1=>XStream 0=>Streams | Other | ||
12cR1-19c | REPL Capture/Apply: flow control | 2=>GoldenGate 1=>XStream 0=>Streams | Queueing | ||
12cR1-19c | REPL Capture/Apply: memory | 2=>GoldenGate 1=>XStream 0=>Streams | Queueing | ||
12cR1-19c | REPL Capture/Apply: messages | 2=>GoldenGate 1=>XStream 0=>Streams | Idle | ||
12cR1-19c | REPL Capture/Apply: miscellaneous | 2=>GoldenGate 1=>XStream 0=>Streams | TYPE | Other | |
12cR1-19c | REPL Capture: archive log | 2=>GoldenGate 1=>XStream 0=>Streams | TYPE | Idle | |
12cR1-19c | REPL Capture: filter callback ruleset | 2=>GoldenGate 1=>XStream 0=>Streams | Application | ||
12cR1-19c | REPL Capture: subscribers to catch up | 2=>GoldenGate 1=>XStream 0=>Streams | TYPE | Queueing | |
10gR2-10gR2 | RF - FSFO Wait for Ack | Other | |||
10gR1-19c | RFS announce | Other | |||
10gR1-19c | RFS attach | Other | |||
10gR1-19c | RFS close | Other | |||
10gR1-19c | RFS create | Other | |||
10gR1-19c | RFS detach | Other | |||
10gR1-19c | RFS dispatch | Other | |||
10gR1-19c | RFS ping | Other | |||
9i-19c | RFS random i/o | System I/O | |||
10gR1-19c | RFS register | Other | |||
9i-19c | RFS sequential i/o | System I/O | |||
10gR1-19c | RFS write | System I/O | |||
12cR2-19c | RMA: IPC0 completion sync | send count | Other | ||
12cR2-19c | RMA: RAC reconfig | Other | |||
12cR2-19c | RMA: latch | RMA Latch | Latch Val | Other | |
12cR2-19c | RMA: rlog allocate | State Object | Instance | Other | |
11gR1-19c | RMAN Disk slave I/O | wait count | wait flags | timeout | System I/O |
11gR1-19c | RMAN Tape slave I/O | tape operation | operation flags | timeout | System I/O |
10gR2-19c | RMAN backup & recovery I/O | count | intr | timeout | System I/O |
19c-19c | RMAN lost write reread | count | intr | timeout | System I/O |
12cR2-19c | RMAN wallet access limit | Other | |||
11gR2-19c | RSGA: RAC reconfiguration | Other | |||
10gR1-19c | RVWR wait for flashback copy | copy latch # | Other | ||
12cR1-12cR1 | Recovery Server Comm SGA setup wait | session_id | serial | Idle | |
12cR1-12cR1 | Recovery Server Servlet wait | session_id | serial | Idle | |
12cR1-12cR1 | Recovery Server Surrogate wait | session_id | serial | Idle | |
12cR1-12cR1 | Recovery Server waiting for work | session_id | serial | Idle | |
12cR1-12cR1 | Recovery Server waiting restore start | session_id | serial | Idle | |
12cR2-19c | Recovery: scn growth limit | Other | |||
12cR1-19c | Redo Transport Attach | Other | |||
12cR1-19c | Redo Transport Close | Other | |||
12cR1-19c | Redo Transport Detach | Other | |||
12cR1-19c | Redo Transport MISC | Other | |||
12cR2-19c | Redo Transport Network Throttle | Other | |||
12cR1-19c | Redo Transport Open | Other | |||
12cR1-19c | Redo Transport Ping | Other | |||
12cR1-19c | Redo Transport Slave Shutdown | Other | |||
12cR1-19c | Redo Transport Slave Startup | Other | |||
12cR1-19c | Redo Writer Remote Sync Complete | Other | |||
12cR1-19c | Redo Writer Remote Sync Notify | Other | |||
12cR2-19c | Redo transport testing | Other | |||
12cR1-19c | Remote SYNC Ping | Other | |||
12cR2-19c | Remote Tool Request Free List | Other | |||
12cR2-19c | Remote Tool Request Reply | Other | |||
8i-19c | Replication Dequeue | sleeptime/senderid | passes | Other | |
12cR1-19c | Resolution of in-doubt txns | SCN | Other | ||
19c-19c | Retry DB Audit Record Insertion Delay | Other | |||
19c-19c | Revoke: get object | maximum time | amount of time | Other | |
12cR2-19c | Row cache for Grant or Revoke | maximum time | amount of time | Other | |
12cR2-19c | SCM slave idle | Idle | |||
12cR1-19c | SGA Allocator termination | Other | |||
10gR2-19c | SGA: MMAN sleep for component shrink | component id | current size | target size | Idle |
10gR2-19c | SGA: allocation forcing component growth | Other | |||
10gR2-19c | SGA: sga_target resize | Other | |||
19c-19c | SPA slave messages | Other | |||
8i-19c | SQL*Net break/reset to client | driver id | break? | Application | |
8i-19c | SQL*Net break/reset to dblink | driver id | break? | Application | |
8i-19c | SQL*Net message from client | driver id | #bytes | Idle | |
8i-19c | SQL*Net message from dblink | driver id | #bytes | Network | |
8i-19c | SQL*Net message to client | driver id | #bytes | Network | |
8i-19c | SQL*Net message to dblink | driver id | #bytes | Network | |
8i-19c | SQL*Net more data from client | driver id | #bytes | Network | |
8i-19c | SQL*Net more data from dblink | driver id | #bytes | Network | |
8i-19c | SQL*Net more data to client | driver id | #bytes | Network | |
8i-19c | SQL*Net more data to dblink | driver id | #bytes | Network | |
11gR1-19c | SQL*Net vector data from client | driver id | #bytes | Network | |
11gR1-19c | SQL*Net vector data from dblink | driver id | #bytes | Network | |
11gR1-19c | SQL*Net vector data to client | driver id | #bytes | Network | |
11gR1-19c | SQL*Net vector data to dblink | driver id | #bytes | Network | |
11gR2-19c | SQL*Net vector message from client | driver id | #bytes | Idle | |
11gR2-19c | SQL*Net vector message from dblink | driver id | #bytes | Idle | |
9i-10gR1 | STREAMS apply coord waiting for slave message | Idle | |||
9i-9i | STREAMS apply coord waiting for some work to finish | ||||
10gR1-10gR1 | STREAMS apply slave idle wait | Idle | |||
9i-10gR1 | STREAMS apply slave waiting for coord message | Application | |||
9i-10gR1 | STREAMS capture process filter callback wait for ruleset | Idle | |||
9i-10gR1 | STREAMS capture process waiting for archive log | Other | |||
9i-10gR1 | STREAMS fetch slave waiting for txns | Idle | |||
11gR1-19c | SUPLOG PL wait for inflight pragma-d PL/SQL | session_num | Other | ||
10gR1-10gR1 | SWRF RWM Auto Capture Event | Other | |||
10gR1-10gR1 | SWRF Wait on Flushing | Other | |||
12cR1-19c | SYNC Remote Write | Other | |||
12cR1-19c | SecureFile log buffer | Configuration | |||
11gR2-19c | SecureFile mutex | Concurrency | |||
19c-19c | Securefile Write Gather Cache Yield Process | Other | |||
12cR2-19c | Service operation completion | Cluster | |||
19c-19c | Shadow lost write | Other | |||
12cR1-19c | Sharded Queues : Part Maintenance idle | Idle | |||
12cR2-19c | Sharded Queues : Part Truncate idle | Idle | |||
11gR1-19c | Shared IO Pool IO Completion | User I/O | |||
11gR1-19c | Shared IO Pool Memory | Concurrency | |||
11gR1-19c | Space Manager: slave idle wait | Slave ID | Idle | ||
11gR1-19c | Space Manager: slave messages | Other | |||
10gR2-19c | Standby redo I/O | count | intr | timeout | System I/O |
10gR2-19c | Streams AQ: QueueTable kgl locks | Other | |||
10gR2-11gR2 | Streams AQ: RAC qmn coordinator idle wait | Idle | |||
10gR2-19c | Streams AQ: deallocate messages from Streams Pool | Idle | |||
10gR2-19c | Streams AQ: delete acknowledged messages | Idle | |||
11gR1-19c | Streams AQ: emn coordinator idle wait | Idle | |||
11gR1-11gR2 | Streams AQ: emn coordinator waiting for slave to start | Other | |||
10gR2-19c | Streams AQ: enqueue blocked due to flow control | Queueing | |||
10gR2-19c | Streams AQ: enqueue blocked on low memory | Queueing | |||
12cR2-19c | Streams AQ: index block pin/row lock | Other | Other | ||
12cR1-19c | Streams AQ: load balancer idle | Idle | |||
12cR2-19c | Streams AQ: opt idle | 1=>SLAVE0 2=>SLAVE1 3=>SLAVE2 4=>SLAVE3 5=>MASTER | Idle | ||
10gR2-19c | Streams AQ: qmn coordinator idle wait | Idle | |||
10gR2-11gR2 | Streams AQ: qmn coordinator waiting for slave to start | Other | |||
10gR2-11gR1 | Streams AQ: qmn slave idle wait | Idle | |||
11gR2-19c | Streams AQ: qmn slave idle wait | Type | Idle | ||
10gR2-19c | Streams AQ: waiting for busy instance for instance_name | where | wait_count | Other | |
10gR2-19c | Streams AQ: waiting for messages in the queue | queue id | process# | wait time | Idle |
10gR2-19c | Streams AQ: waiting for time management or cleanup tasks | Idle | |||
11gR1-11gR2 | Streams apply: waiting for dependency | Concurrency | |||
11gR1-11gR2 | Streams apply: waiting to commit | Configuration | |||
10gR2-11gR2 | Streams capture: filter callback waiting for ruleset | Application | |||
10gR2-10gR2 | Streams capture: resolve low memory condition | Configuration | |||
10gR2-11gR2 | Streams capture: waiting for archive log | Other | |||
10gR2-11gR2 | Streams capture: waiting for database startup | Other | |||
10gR2-11gR2 | Streams capture: waiting for subscribers to catch up | Queueing | |||
10gR2-11gR2 | Streams fetch slave: waiting for txns | Idle | |||
10gR2-11gR2 | Streams miscellaneous event | TYPE | Other | ||
10gR2-11gR2 | Streams: RAC waiting for inter instance ack | Other | |||
10gR1-10gR1 | Streams: Wait for inter instance ack | Other | |||
9i-10gR1 | Streams: Wating for DDL to apply | sleep time | Application | ||
10gR2-11gR2 | Streams: apply reader waiting for DDL to apply | sleep time | Application | ||
11gR1-11gR2 | Streams: flow control | Queueing | |||
11gR1-11gR2 | Streams: resolve low memory condition | Queueing | |||
11gR1-11gR2 | Streams: waiting for messages | Idle | |||
12cR2-19c | Supplemental logging roles | role id | Other | ||
12cR1-19c | Sync ASM discovery | Other | |||
10gR1-19c | Sync ASM rebalance | Other | |||
10gR2-19c | TCP Socket (KGAS) | Network | |||
11gR2-19c | TEST: action hang | Other | |||
11gR2-19c | TEST: action sync | Other | |||
12cR1-19c | TEXT: File System I/O | User I/O | |||
10gR2-19c | TEXT: URL_DATASTORE network wait | Network | |||
12cR1-12cR1 | TPZ test process | Other | |||
11gR2-19c | TSE SSO wallet reopen | Other | |||
11gR2-12cR1 | TSE master key rekey | ts# | Other | ||
12cR2-19c | Unpin a recreatable chunk | chunk addr | max attempt | attempted | Concurrency |
11gR2-19c | VKRM Idle | Idle | |||
11gR1-19c | VKTM Init Wait for GSGA | Idle | |||
11gR1-19c | VKTM Logical Idle Wait | Idle | |||
10gR2-19c | WCR: RAC message context busy | Other | |||
11gR1-19c | WCR: Sync context busy | Other | |||
11gR2-19c | WCR: capture file IO write | Other | |||
11gR1-19c | WCR: replay client notify | who am I | Idle | ||
11gR1-12cR1 | WCR: replay clock | wait for scn's hi 4 bytes | wait for scn's lo 4 bytes | Idle | |
12cR2-19c | WCR: replay clock | wait for scn's hi 4 bytes | wait for scn's lo 4 bytes | schedule capture ID | Idle |
11gR1-19c | WCR: replay lock order | wait for scn's hi 4 bytes | wait for scn's lo 4 bytes | Application | |
11gR1-19c | WCR: replay paused | Idle | |||
9i-10gR1 | Wait for Dictionary Build to lock all tables | Other | |||
10gR1-19c | Wait for TT enqueue | tsn | Other | ||
9i-19c | Wait for Table Lock | Application | |||
8i-8i | Wait for a paralle reco to abort | ||||
8i-8i | Wait for a undo record | ||||
10gR1-19c | Wait for shrink lock | object_id | lock_mode | Other | |
10gR1-19c | Wait for shrink lock2 | object_id | lock_mode | Other | |
8i-8i | Wait for stopper event to be increased | ||||
10gR1-12cR1 | Wait on stby instance close | Other | |||
11gR1-19c | XDB SGA initialization | Other | |||
12cR1-19c | ack for a broadcasted res from a remote instance | Other | |||
12cR1-19c | acknowledge over PGA limit | limit | margin | growth | Scheduler |
10gR2-19c | affinity expansion in replay | Other | |||
10gR1-19c | alter rbs offline | Administrative | |||
9i-19c | alter system set dispatcher | waited | Administrative | ||
8i-8i | alter system set mts_dispatcher | waited | |||
9i-9i | async disk IO | count | intr | timeout | |
11gR2-19c | asynch descriptor resize | outstanding #aio | current aio limit | new aio limit | Other |
11gR1-19c | auto-sqltune: wait graph update | Idle | |||
9i-9i | background parameter adjustment | parameter number | |||
10gR1-19c | block change tracking buffer space | Other | |||
12cR2-19c | block compare coord process idle | Idle | |||
11gR1-19c | blocking txn id for DDL | table | scn | only dml | Other |
11gR1-19c | broadcast mesg queue transition | channel handle | message | location | Other |
11gR1-19c | broadcast mesg recovery queue transition | channel handle | message | location | Other |
10gR1-19c | buffer busy | group# | obj# | block# | Other |
8i-8i | buffer busy due to global cache | file# | block# | id | |
9i-9i | buffer busy global CR | file# | block# | id | |
9i-9i | buffer busy global cache | file# | block# | id | |
8i-9i | buffer busy waits | file# | block# | id | |
10gR1-19c | buffer busy waits | file# | block# | class# | Concurrency |
8i-19c | buffer deadlock | dba | class*10+mode | flag | Other |
10gR1-19c | buffer dirty disabled | group# | Other | ||
9i-19c | buffer exterminate | file# | block# | buf_ptr | Other |
10gR1-19c | buffer freelistbusy | group# | obj# | block# | Other |
10gR1-19c | buffer invalidation wait | group# | obj# | block# | Other |
8i-19c | buffer latch | latch addr | chain# | Other | |
9i-11gR1 | buffer pool resize | buffer pool id | current size | new size | Administrative |
8i-19c | buffer read retry | file# | block# | User I/O | |
10gR1-19c | buffer rememberlist busy | group# | obj# | block# | Other |
9i-12cR2 | buffer resize | Other | |||
10gR1-19c | buffer write wait | group# | obj# | block# | Other |
10gR1-19c | buffer writeList full | group# | obj# | block# | Other |
9i-9i | cache simulator heap | ||||
12cR1-19c | call | action | Other | ||
12cR2-19c | cancel media recovery on switchover | Other | |||
12cR2-19c | cell external table smart scan | cellhash# | User I/O | ||
11gR2-19c | cell list of blocks physical read | cellhash# | diskhash# | blocks | User I/O |
12cR2-19c | cell list of blocks read request | cellhash# | diskhash# | blocks | User I/O |
11gR2-19c | cell manager cancel work request | Other | |||
11gR2-19c | cell manager closing cell | cellhash# | System I/O | ||
11gR2-19c | cell manager discovering disks | cellhash# | System I/O | ||
11gR2-19c | cell manager opening cell | cellhash# | System I/O | ||
19c-19c | cell manager: CRS DG start | Other | |||
19c-19c | cell manager: CRS DG unmounted list | Other | |||
11gR1-19c | cell multiblock physical read | cellhash# | diskhash# | bytes | User I/O |
12cR2-19c | cell multiblock read request | cellhash# | diskhash# | bytes | User I/O |
12cR2-19c | cell physical read no I/O | cellhash# | diskhash# | bytes | User I/O |
19c-19c | cell ram cache population | cellhash# | Other | ||
11gR1-19c | cell single block physical read | cellhash# | diskhash# | bytes | User I/O |
12cR2-19c | cell single block read request | cellhash# | diskhash# | bytes | User I/O |
11gR1-19c | cell smart file creation | cellhash# | User I/O | ||
12cR2-19c | cell smart flash keep | cellhash# | Other | ||
11gR2-19c | cell smart flash unkeep | cellhash# | Other | ||
11gR1-19c | cell smart incremental backup | cellhash# | System I/O | ||
11gR1-19c | cell smart index scan | cellhash# | User I/O | ||
11gR1-19c | cell smart restore from backup | cellhash# | System I/O | ||
11gR1-19c | cell smart table scan | cellhash# | User I/O | ||
11gR1-19c | cell statistics gather | cellhash# | User I/O | ||
11gR2-19c | cell worker idle | Idle | |||
11gR2-19c | cell worker online completion | cellhash# | Other | ||
11gR2-19c | cell worker retry | cellhash# | Other | ||
10gR1-19c | change tracking file parallel write | blocks | requests | Other | |
10gR1-19c | change tracking file synchronous read | block# | blocks | Other | |
10gR1-19c | change tracking file synchronous write | block# | blocks | Other | |
10gR1-19c | check CPU wait times | Other | |||
10gR1-19c | checkpoint advanced | group# | Other | ||
8i-19c | checkpoint completed | Configuration | |||
19c-19c | chunk move metadata prefetch | Other | |||
10gR1-19c | class slave wait | slave id | Idle | ||
10gR2-19c | cleanup of aborted process | location | Other | ||
11gR1-19c | cmon timer | sleep time | Idle | ||
11gR2-19c | concurrent I/O completion | Administrative | |||
12cR1-19c | connection broker handoff | connection broker | connection | op | Network |
11gR1-11gR2 | connection pool wait | op | num servers | Administrative | |
12cR1-19c | connection pool wait | op | num procs | Administrative | |
9i-10gR1 | contacting SCN server or SCN lock master | Cluster | |||
12cR1-19c | control file backup creation | Administrative | |||
10gR2-19c | control file diagnostic dump | type | param | Other | |
9i-19c | control file heartbeat | Other | |||
8i-9i | control file parallel write | files | blocks | requests | |
10gR1-19c | control file parallel write | files | block# | requests | System I/O |
8i-19c | control file sequential read | file# | block# | blocks | System I/O |
8i-19c | control file single write | file# | block# | blocks | System I/O |
8i-8i | conversion file read | file# | block# | blocks | |
9i-9i | conversion file read | block# | blocks | ||
9i-19c | cr request retry | file# | block# | Other | |
10gR2-11gR1 | cursor: mutex S | idn | value | where|sleeps | Concurrency |
11gR2-19c | cursor: mutex S | idn | value | where | Concurrency |
10gR2-11gR1 | cursor: mutex X | idn | value | where|sleeps | Concurrency |
11gR2-19c | cursor: mutex X | idn | value | where | Concurrency |
10gR2-11gR1 | cursor: pin S | idn | value | where|sleeps | Other |
11gR2-19c | cursor: pin S | idn | value | where | Concurrency |
10gR2-11gR1 | cursor: pin S wait on X | idn | value | where|sleeps | Concurrency |
11gR2-19c | cursor: pin S wait on X | idn | value | where | Concurrency |
10gR2-11gR1 | cursor: pin X | idn | value | where|sleeps | Other |
11gR2-19c | cursor: pin X | idn | value | where | Concurrency |
12cR2-19c | database open on read-write instance | Other | |||
11gR2-19c | datafile copy range completion | Administrative | |||
11gR2-19c | datafile move cleanup during resize | Other | |||
19c-19c | datafile pre-create | Administrative | |||
11gR2-19c | db file async I/O submit | requests | interrupt | timeout | System I/O |
8i-19c | db file parallel read | files | blocks | requests | User I/O |
8i-8i | db file parallel write | files | blocks | requests | |
9i-19c | db file parallel write | requests | interrupt | timeout | System I/O |
8i-19c | db file scattered read | file# | block# | blocks | User I/O |
8i-19c | db file sequential read | file# | block# | blocks | User I/O |
8i-19c | db file single write | file# | block# | blocks | User I/O |
11gR2-19c | db flash cache dynamic disabling wait | Administrative | |||
11gR2-12cR1 | db flash cache invalidate wait | Concurrency | |||
12cR2-19c | db flash cache invalidate wait | file# | block# | Concurrency | |
11gR2-19c | db flash cache multiblock physical read | User I/O | |||
11gR2-19c | db flash cache single block physical read | User I/O | |||
11gR2-19c | db flash cache write | User I/O | |||
10gR2-19c | dbms_file_transfer I/O | count | intr | timeout | User I/O |
10gR2-19c | dbverify reads | count | intr | timeout | User I/O |
8i-19c | debugger command | Other | |||
10gR1-19c | dedicated server timer | wait event | Network | ||
12cR1-12cR1 | defer SGA allocation slave | num of defer segments | Other | ||
12cR2-19c | defer SGA allocation slave | defer segment index | allocation mode | Other | |
8i-19c | direct path read | file number | first dba | block cnt | User I/O |
8i-9i | direct path read (lob) | file number | first dba | block cnt | |
10gR1-19c | direct path read temp | file number | first dba | block cnt | User I/O |
11gR1-19c | direct path sync | File number | Flags | User I/O | |
8i-19c | direct path write | file number | first dba | block cnt | User I/O |
8i-9i | direct path write (lob) | file number | first dba | block cnt | |
10gR1-19c | direct path write temp | file number | first dba | block cnt | User I/O |
8i-19c | dispatcher listen timer | sleep time | Network | ||
8i-19c | dispatcher shutdown | waited | Other | ||
8i-19c | dispatcher timer | sleep time | Idle | ||
10gR1-19c | dma prepare busy | group | obj# | block# | Other |
8i-19c | dupl. cluster key | dba | Other | ||
11gR2-19c | enq: AB - ABMR process initialized | name|mode | operation | operation parm | Other |
11gR2-19c | enq: AB - ABMR process start/stop | name|mode | operation | operation parm | Other |
12cR1-19c | enq: AC - acquiring partition id | name|mode | 0 | 0 | Other |
10gR1-19c | enq: AD - allocate AU | name|mode | group and disk number | AU number | Other |
10gR1-19c | enq: AD - deallocate AU | name|mode | group and disk number | AU number | Other |
12cR2-19c | enq: AD - flush writes to AU | name|mode | group and disk number | AU number | Other |
11gR1-19c | enq: AD - relocate AU | name|mode | group and disk number | AU number | Other |
11gR1-12cR1 | enq: AE - lock | name|mode | edition obj# | 0 | Other |
12cR2-19c | enq: AE - lock | name|mode | edition obj# | pdbuid | Other |
10gR1-19c | enq: AF - task serialization | name|mode | task id | 0 | Other |
10gR1-19c | enq: AG - contention | name|mode | workspace # | generation | Other |
12cR2-19c | enq: AH - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: AK - contention | type|mode | id1 | id2 | Other |
11gR1-19c | enq: AM - ASM ACD Relocation | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - ASM ATB COD creation | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - ASM ATE conversion | name|mode | id1 | id2 | Other |
11gR2-19c | enq: AM - ASM Amdu Dump | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - ASM Audit file Cleanup | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - ASM Audit file Delete | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - ASM Client Assisted Offline | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - ASM Client Assisted Offline Chk | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - ASM DD update SrRloc | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - ASM Drop Mirror | name|mode | id1 | id2 | Other |
11gR1-19c | enq: AM - ASM File Destroy | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - ASM Grow ACD | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - ASM Mirror Prepare | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - ASM Mirror Split | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - ASM PDB Mirror Split | name|mode | id1 | id2 | Other |
11gR2-19c | enq: AM - ASM Password File Update | name|mode | id1 | id2 | Other |
12cR2-19c | enq: AM - ASM SR Batch Allocation | name|mode | id1 | id2 | Other |
12cR2-19c | enq: AM - ASM SR Segment Reuse | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - ASM SR Segment Reuse Lookup | name|mode | id1 | id2 | Other |
12cR2-19c | enq: AM - ASM SR relocation | name|mode | id1 | id2 | Other |
12cR2-19c | enq: AM - ASM Sparse Disk IOCTL | name|mode | id1 | id2 | Other |
12cR2-12cR2 | enq: AM - ASM Split Mirror DB Prepare | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - ASM Split Mirror File Create | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - ASM Split Mirror File Delete | name|mode | id1 | id2 | Other |
12cR2-12cR2 | enq: AM - ASM Split Mirror File Operation | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - ASM Split Mirror ODM File Crt | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - ASM Split Mirror ODM File Del | name|mode | id1 | id2 | Other |
12cR2-12cR2 | enq: AM - ASM Split Mirror Operation | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - ASM Split Status Read | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - ASM Split Status Write | name|mode | id1 | id2 | Other |
11gR2-19c | enq: AM - ASM User | name|mode | id1 | id2 | Other |
12cR2-19c | enq: AM - ASM VAL cache | name|mode | id1 | id2 | Other |
12cR2-19c | enq: AM - ASM VAM Active | name|mode | id1 | id2 | Other |
12cR2-19c | enq: AM - ASM VAT migration | name|mode | id1 | id2 | Other |
11gR1-19c | enq: AM - ASM cache freeze | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - ASM client check | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - ASM client operation | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - ASM disk based alloc/dealloc | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - ASM file access req | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - ASM file chown | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - ASM file create | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - ASM file descriptor | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - ASM file relocation | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - ASM metadata replication | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - ASM reserved | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - ASM resync from ATE | name|mode | id1 | id2 | Other |
12cR2-19c | enq: AM - ASM: group unblock | name|mode | id1 | id2 | Other |
12cR2-19c | enq: AM - ASMB Renew | name|mode | id1 | id2 | Other |
12cR2-19c | enq: AM - ASMB Startup | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - Change file group redundancy | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - Create Prepare Child file group | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - Create default DG key in OCR | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - Credential creation | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - Credential deletion | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - DB Drop Mirror Copy | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - DB Mirror Prepare | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - DB Mirror Split | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - Disable Remote ASM | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - Enable Remote ASM | name|mode | id1 | id2 | Other |
19c-19c | enq: AM - PDB Mirror Split | name|mode | id1 | id2 | Other |
11gR2-11gR2 | enq: AM - PST split check | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - Register with IOServer | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - SR slice Clear/Mark | name|mode | id1 | id2 | Other |
12cR2-19c | enq: AM - Update SR nomark flag | name|mode | id1 | id2 | Other |
11gR1-19c | enq: AM - background COD reservation | name|mode | id1 | id2 | Other |
12cR1-19c | enq: AM - block repair | name|mode | id1 | id2 | Other |
10gR2-19c | enq: AM - client registration | name|mode | id1 | id2 | Other |
11gR2-19c | enq: AM - disk offline | name|mode | id1 | id2 | Other |
11gR2-19c | enq: AM - group block | name|mode | id1 | id2 | Other |
11gR2-19c | enq: AM - group use | name|mode | id1 | id2 | Other |
10gR2-19c | enq: AM - rollback COD reservation | name|mode | id1 | id2 | Other |
10gR2-19c | enq: AM - shutdown | name|mode | id1 | id2 | Other |
10gR1-19c | enq: AO - contention | name|mode | workspace # | object # | Other |
12cR1-19c | enq: AP - contention | name|mode | 0 | 0 | Other |
12cR1-19c | enq: AQ - QPT fg map dqpt | name|mode | QT_OBJ# | 0 | Other |
12cR1-19c | enq: AQ - QPT fg map qpt | name|mode | QT_OBJ# | 0 | Other |
12cR1-19c | enq: AR - contention | type|mode | id1 | id2 | Other |
10gR1-10gR1 | enq: AS - contention | name|mode | 0 | 0 | Other |
10gR2-10gR2 | enq: AS - modify service | name|mode | 0 | 0 | Other |
10gR2-19c | enq: AS - service activation | name|mode | 0 | 0 | Other |
10gR1-19c | enq: AT - contention | name|mode | 0 | 0 | Other |
12cR2-19c | enq: AU - ADR Purge Operation | name|mode | 0 | 0 | Other |
10gR2-11gR2 | enq: AU - audit index file | name|mode | XML audit index file | 0 | Other |
11gR2-19c | enq: AV - AVD client registration | name|mode | persistent DG number | non-DG number enqs | Other |
11gR2-19c | enq: AV - add/enable first volume in DG | name|mode | persistent DG number | non-DG number enqs | Other |
11gR1-11gR1 | enq: AV - persistent DG number | name|mode | unused | persistent DG number | Other |
11gR2-19c | enq: AV - persistent DG number | name|mode | persistent DG number | non-DG number enqs | Other |
11gR2-19c | enq: AV - volume relocate | name|mode | persistent DG number | non-DG number enqs | Other |
10gR1-19c | enq: AW - AW generation lock | name|mode | operation | workspace # | Other |
10gR1-19c | enq: AW - AW state lock | name|mode | operation | workspace # | Other |
10gR1-19c | enq: AW - AW$ table lock | name|mode | operation | workspace # | Other |
10gR1-19c | enq: AW - user access for AW | name|mode | operation | workspace # | Other |
11gR1-19c | enq: AY - contention | name|mode | Op1 | Op2 | Other |
12cR2-19c | enq: AZ - AQ_SRVNTFN_Q Creation | name|mode | 0 | 0 | Other |
12cR1-19c | enq: BA - SUBBMAP contention | name|mode | 0 | 0 | Other |
11gR1-19c | enq: BB - 2PC across RAC instances | name|mode | gtrid hash value | bqual hash value | Commit |
12cR1-19c | enq: BC - create container | name|mode | container group | container id | Other |
12cR1-19c | enq: BC - drop container | name|mode | container group | container id | Other |
12cR1-19c | enq: BC - drop container group | name|mode | container group | container id | Other |
12cR1-19c | enq: BC - group - create container | name|mode | container group | container id | Other |
12cR1-19c | enq: BC - group - create file | name|mode | container group | container id | Other |
12cR2-19c | enq: BE - Critical Block Allocation | name|mode | tablespace# | block# | Concurrency |
10gR2-19c | enq: BF - PMON Join Filter cleanup | name|mode | node#/parallelizer# | bloom# | Other |
10gR2-19c | enq: BF - allocation contention | name|mode | node#/parallelizer# | bloom# | Other |
12cR1-19c | enq: BI - create file | name|mode | group ID / file ID | file ID | Other |
12cR1-19c | enq: BI - delete file | name|mode | group ID / file ID | file ID | Other |
12cR1-19c | enq: BI - identify file | name|mode | group ID / file ID | file ID | Other |
12cR1-19c | enq: BM - clonedb bitmap file write | name|mode | block number | number of blocks | Other |
12cR2-19c | enq: BO - contention | type|mode | id1 | id2 | Other |
12cR1-12cR1 | enq: BR - RS check quiescence | name|mode | operation | file # | Other |
12cR1-12cR1 | enq: BR - RS invalidate plans | name|mode | operation | file # | Other |
12cR1-12cR1 | enq: BR - RS lock API | name|mode | operation | file # | Other |
12cR1-12cR1 | enq: BR - RS lock db | name|mode | operation | file # | Other |
12cR1-12cR1 | enq: BR - RS lock scheduler | name|mode | operation | file # | Other |
12cR1-12cR1 | enq: BR - RS lock storage loc | name|mode | operation | file # | Other |
12cR1-12cR1 | enq: BR - RS lock timer queue | name|mode | operation | file # | Other |
12cR1-12cR1 | enq: BR - RS protect plans | name|mode | operation | file # | Other |
12cR1-12cR1 | enq: BR - RS purge storage loc | name|mode | operation | file # | Other |
12cR1-12cR1 | enq: BR - RS quiesce storage | name|mode | operation | file # | Other |
12cR1-12cR1 | enq: BR - RS run scheduler | name|mode | operation | file # | Other |
10gR1-19c | enq: BR - file shrink | name|mode | operation | file # | Other |
11gR1-19c | enq: BR - multi-section restore header | name|mode | operation | file # | Other |
11gR1-19c | enq: BR - multi-section restore section | name|mode | operation | file # | Other |
11gR2-19c | enq: BR - perform autobackup | name|mode | operation | file # | Other |
19c-19c | enq: BR - perform catalog recovery area | name|mode | operation | file # | Other |
10gR1-19c | enq: BR - proxy-copy | name|mode | operation | file # | Other |
11gR2-19c | enq: BR - request autobackup | name|mode | operation | file # | Other |
11gR1-19c | enq: BR - space info datafile hdr update | name|mode | operation | file # | Other |
12cR2-19c | enq: BS - Backup spare0 | name|mode | id1 | id2 | Other |
12cR2-19c | enq: BS - Backup spare1 | name|mode | id1 | id2 | Other |
12cR2-19c | enq: BS - Backup spare2 | name|mode | id1 | id2 | Other |
12cR2-19c | enq: BS - Backup spare3 | name|mode | id1 | id2 | Other |
12cR2-19c | enq: BS - Backup spare4 | name|mode | id1 | id2 | Other |
12cR2-19c | enq: BS - Backup spare5 | name|mode | id1 | id2 | Other |
12cR2-19c | enq: BS - Backup spare6 | name|mode | id1 | id2 | Other |
12cR2-19c | enq: BS - Backup spare7 | name|mode | id1 | id2 | Other |
12cR2-19c | enq: BS - Backup spare8 | name|mode | id1 | id2 | Other |
12cR2-19c | enq: BS - Backup spare9 | name|mode | id1 | id2 | Other |
12cR2-19c | enq: BU - recovery set construct | name|mode | 0 | 0 | Other |
12cR2-19c | enq: BU - recovery set takeover | name|mode | 0 | 0 | Other |
12cR1-19c | enq: BV - rebuild/validate group | name|mode | amrv$ key | Other | |
12cR1-19c | enq: BZ - resize file | name|mode | group ID / file ID | file ID | Other |
11gR1-19c | enq: CA - contention | name|mode | 0 | 0 | Other |
12cR1-19c | enq: CB - role operation | name|mode | 0 | 0 | Concurrency |
12cR1-19c | enq: CC - decryption | name|mode | 0 | 0 | Other |
10gR1-19c | enq: CF - contention | name|mode | 0 | operation | Other |
10gR1-19c | enq: CI - contention | name|mode | opcode | type | Other |
10gR1-19c | enq: CL - compare labels | name|mode | object # | 0 | Other |
10gR1-19c | enq: CL - drop label | name|mode | object # | 0 | Other |
12cR1-19c | enq: CM - diskgroup dismount | name|mode | disk group # | type | Other |
10gR1-19c | enq: CM - gate | name|mode | disk group # | type | Other |
10gR1-19c | enq: CM - instance | name|mode | disk group # | type | Other |
10gR2-19c | enq: CN - race with init | name|mode | reg id | 0 | Other |
10gR2-19c | enq: CN - race with reg | name|mode | reg id | 0 | Other |
10gR2-19c | enq: CN - race with txn | name|mode | reg id | 0 | Other |
11gR1-19c | enq: CO - master slave det | name|mode | inst id | 0 | Other |
12cR1-19c | enq: CP - Pluggable database resetlogs | name|mode | Internal | Internal | Other |
11gR1-19c | enq: CQ - contention | name|mode | 0 | 0 | Other |
11gR2-19c | enq: CR - block range reuse ckpt | name|mode | 2 | 0 | Other |
10gR1-19c | enq: CT - CTWR process start/stop | name|mode | operation | operation parm | Other |
10gR1-19c | enq: CT - change stream ownership | name|mode | operation | operation parm | Other |
10gR1-19c | enq: CT - global space management | name|mode | operation | operation parm | Other |
10gR1-19c | enq: CT - local space management | name|mode | operation | operation parm | Other |
10gR1-19c | enq: CT - reading | name|mode | operation | operation parm | Other |
10gR1-19c | enq: CT - state | name|mode | operation | operation parm | Other |
10gR1-19c | enq: CT - state change gate 1 | name|mode | operation | operation parm | Other |
10gR1-19c | enq: CT - state change gate 2 | name|mode | operation | operation parm | Other |
10gR1-19c | enq: CU - contention | name|mode | handle | handle | Other |
12cR1-19c | enq: CX - TEXT: Index Specific Lock | name|mode | Index Id | Partition Id | Other |
19c-19c | enq: DA - Slave Process Array | name|mode | 0 | 0 | Other |
10gR1-19c | enq: DB - contention | name|mode | EnqMode | 0 | Administrative |
10gR1-19c | enq: DD - contention | name|mode | disk group | type | Other |
19c-19c | enq: DE - Update Draining Test | name|mode | 0 | 0 | Other |
10gR1-19c | enq: DF - contention | name|mode | 0 | file # | Other |
10gR1-19c | enq: DG - contention | name|mode | disk group | type | Other |
12cR1-19c | enq: DI - contention | type|mode | id1 | id2 | Other |
10gR1-19c | enq: DL - contention | name|mode | object # | 0 | Other |
12cR2-19c | enq: DM - access control | name|mode | type | type | Other |
10gR1-19c | enq: DM - contention | name|mode | type | type | Other |
10gR1-19c | enq: DN - contention | name|mode | 0 | 0 | Other |
11gR1-19c | enq: DO - Staleness Registry create | name|mode | disk group # | disk # | Other |
11gR1-19c | enq: DO - disk online | name|mode | disk group # | disk # | Other |
11gR1-11gR2 | enq: DO - disk online operation | name|mode | disk group # | disk # | Other |
11gR1-19c | enq: DO - disk online recovery | name|mode | disk group # | disk # | Other |
11gR1-19c | enq: DO - startup of MARK process | name|mode | disk group # | disk # | Other |
10gR1-19c | enq: DP - contention | name|mode | 0 | 0 | Other |
12cR1-19c | enq: DQ - contention | type|mode | id1 | id2 | Other |
10gR1-19c | enq: DR - contention | name|mode | 0 | 0 | Other |
10gR1-19c | enq: DS - contention | name|mode | 0 | 0 | Other |
10gR1-19c | enq: DT - contention | name|mode | 0 | 0 | Other |
10gR1-19c | enq: DV - contention | name|mode | object # | 0 | Other |
11gR1-19c | enq: DW - contention | name|mode | tablespace # | dba | Other |
10gR1-19c | enq: DX - contention | name|mode | transaction entry # | 0 | Other |
12cR1-19c | enq: EA - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EB - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EC - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: ED - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EE - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EF - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EG - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EH - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EI - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EJ - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EK - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EL - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EM - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EN - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EO - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EP - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EQ - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: ER - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: ES - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: ET - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EU - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EV - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EX - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EY - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: EZ - contention | type|mode | id1 | id2 | Other |
10gR1-19c | enq: FA - access file | name|mode | disk group number | file number | Other |
10gR1-19c | enq: FB - contention | name|mode | tablespace # | dba | Other |
10gR1-19c | enq: FC - open an ACD thread | name|mode | disk group | thread | Other |
10gR1-19c | enq: FC - recover an ACD thread | name|mode | disk group | thread | Other |
10gR1-19c | enq: FD - Flashback coordinator | name|mode | Internal | Internal | Other |
11gR2-19c | enq: FD - Flashback logical operations | name|mode | Internal | Internal | Other |
10gR1-19c | enq: FD - Flashback on/off | name|mode | Internal | Internal | Other |
10gR1-19c | enq: FD - Marker generation | name|mode | Internal | Internal | Other |
10gR2-19c | enq: FD - Restore point create/drop | name|mode | Internal | Internal | Other |
10gR1-19c | enq: FD - Tablespace flashback on/off | name|mode | Internal | Internal | Other |
11gR1-19c | enq: FE - contention | name|mode | 0 | 0 | Other |
10gR1-19c | enq: FG - FG redo generation enq race | name|mode | disk group | type | Other |
10gR1-19c | enq: FG - LGWR redo generation enq race | name|mode | disk group | type | Other |
10gR1-19c | enq: FG - serialize ACD relocate | name|mode | disk group | type | Other |
12cR1-19c | enq: FH - contention | name|mode | Instance ID | Other | |
10gR1-19c | enq: FL - Flashback database log | name|mode | Log # | zero | Other |
10gR1-19c | enq: FL - Flashback db command | name|mode | Log # | zero | Other |
10gR1-19c | enq: FM - contention | name|mode | 0 | 0 | Other |
12cR1-19c | enq: FO - file system operation contention | name|mode | 0 | 0 | Other |
10gR2-19c | enq: FP - global fob contention | name|mode | low file obj add | high file obj add | Other |
10gR1-11gR1 | enq: FR - contention | name|mode | disk group | unused | Other |
11gR2-19c | enq: FR - contention | name|mode | disk group | thread | Other |
11gR2-19c | enq: FR - recover the thread | name|mode | disk group | thread | Other |
11gR2-19c | enq: FR - use the thread | name|mode | disk group | thread | Other |
10gR1-12cR1 | enq: FS - contention | name|mode | 0 | type | Other |
12cR2-19c | enq: FS - contention | name|mode | 0 or pdbid | type | Other |
12cR1-12cR1 | enq: FS - online log operation | name|mode | 0 | type | Other |
12cR2-19c | enq: FS - online log operation | name|mode | 0 or pdbid | type | Other |
10gR1-19c | enq: FT - allow LGWR writes | name|mode | disk group | thread | Other |
10gR1-19c | enq: FT - disable LGWR writes | name|mode | disk group | thread | Other |
10gR1-19c | enq: FU - contention | name|mode | 0 | 0 | Other |
12cR1-19c | enq: FW - contention | type|mode | id1 | id2 | Other |
11gR1-19c | enq: FX - issue ACD Xtnt Relocation CIC | name|mode | disk group | unused | Other |
12cR1-19c | enq: FZ - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GA - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GB - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GC - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GD - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GE - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GF - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GG - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GH - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GI - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GJ - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GK - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GL - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GM - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GN - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GO - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GP - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GQ - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GR - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GS - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GT - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GU - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GV - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GX - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GY - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: GZ - contention | type|mode | id1 | id2 | Other |
12cR2-19c | enq: HC - HSM cache read | name|mode | 0 | 0 | Other |
12cR2-19c | enq: HC - HSM cache write | name|mode | 0 | 0 | Other |
10gR1-19c | enq: HD - contention | name|mode | disk group | 0 | Other |
12cR1-19c | enq: HM - contention | type|mode | id1 | id2 | Other |
10gR1-19c | enq: HP - contention | name|mode | tablespace # | dba | Other |
10gR1-19c | enq: HQ - contention | name|mode | object # | hash value | Other |
10gR1-19c | enq: HV - contention | name|mode | object # | 0 | Other |
10gR1-19c | enq: HW - contention | name|mode | table space # | block | Configuration |
10gR1-19c | enq: IA - contention | name|mode | 0 | 0 | Other |
12cR1-19c | enq: IC - IOServer clientID | name|mode | client id | none | Other |
10gR1-19c | enq: ID - contention | name|mode | 0 | 0 | Other |
12cR1-19c | enq: IF - file close | name|mode | client id/group num | File number | Other |
12cR1-19c | enq: IF - file open | name|mode | client id/group num | File number | Other |
12cR2-19c | enq: II - contention | type|mode | id1 | id2 | Other |
12cR2-19c | enq: IK - contention | type|mode | id1 | id2 | Other |
10gR1-19c | enq: IL - contention | name|mode | object # | 0 | Other |
10gR1-19c | enq: IM - contention for blr | name|mode | pool # | 0 | Other |
12cR2-19c | enq: IN - contention | name|mode | tablespace # | dba | Other |
12cR1-12cR1 | enq: IP - open/close PDB | name|mode | 0 | type | Other |
12cR2-19c | enq: IP - open/close PDB | name|mode | type | pdbuid | Other |
12cR1-19c | enq: IR - arbitrate instance recovery | name|mode | 0 | 0/1 | Other |
10gR1-19c | enq: IR - contention | name|mode | 0 | 0/1 | Other |
10gR1-19c | enq: IR - contention2 | name|mode | 0 | 0/1 | Other |
12cR1-19c | enq: IR - global serialization | name|mode | 0 | 0/1 | Other |
12cR1-19c | enq: IR - local serialization | name|mode | 0 | 0/1 | Other |
10gR1-12cR1 | enq: IS - contention | name|mode | 0 | type | Other |
12cR2-19c | enq: IS - contention | name|mode | 0 or pdbid | type | Other |
10gR1-19c | enq: IT - contention | name|mode | object # | 0 | Other |
12cR1-19c | enq: IV - contention | type|mode | id1 | id2 | Other |
19c-19c | enq: IV - cross instance invalidation | lock idx | Concurrency | ||
12cR1-19c | enq: IZ - contention | type|mode | id1 | id2 | Other |
10gR1-19c | enq: JD - contention | name|mode | 0 | 0 | Other |
12cR2-19c | enq: JG - contention | name|mode | service ID | queue type | Other |
12cR2-19c | enq: JG - evt notify | name|mode | service ID | queue type | Other |
12cR2-19c | enq: JG - evtsub add | name|mode | service ID | queue type | Other |
12cR2-19c | enq: JG - evtsub drop | name|mode | service ID | queue type | Other |
12cR2-19c | enq: JG - q mem clnup lck | name|mode | service ID | queue type | Other |
12cR2-19c | enq: JG - queue lock | name|mode | service ID | queue type | Other |
12cR2-19c | enq: JG - sch locl enqs | name|mode | service ID | queue type | Other |
10gR1-19c | enq: JI - contention | name|mode | view object # | 0 | Other |
10gR1-19c | enq: JQ - contention | name|mode | 0 | 0 | Other |
11gR1-19c | enq: JS - aq sync | name|mode | service ID | queue type | Other |
10gR1-12cR1 | enq: JS - contention | name|mode | service ID | queue type | Other |
10gR1-10gR1 | enq: JS - coord post lock | name|mode | service ID | queue type | Other |
10gR1-10gR1 | enq: JS - coord rcv lock | name|mode | service ID | queue type | Other |
10gR2-19c | enq: JS - evt notify | name|mode | service ID | queue type | Other |
10gR2-12cR1 | enq: JS - evtsub add | name|mode | service ID | queue type | Other |
10gR2-12cR1 | enq: JS - evtsub drop | name|mode | service ID | queue type | Other |
10gR1-10gR1 | enq: JS - global wdw lock | name|mode | service ID | queue type | Other |
10gR1-10gR1 | enq: JS - job chain evaluate lock | name|mode | service ID | queue type | Other |
10gR1-19c | enq: JS - job recov lock | name|mode | service ID | queue type | Other |
10gR1-19c | enq: JS - job run lock - synchronize | name|mode | service ID | queue type | Other |
10gR1-12cR1 | enq: JS - q mem clnup lck | name|mode | service ID | queue type | Other |
10gR1-12cR1 | enq: JS - queue lock | name|mode | service ID | queue type | Other |
10gR1-10gR1 | enq: JS - running job cnt lock | name|mode | service ID | queue type | Other |
10gR1-10gR1 | enq: JS - running job cnt lock2 | name|mode | service ID | queue type | Other |
10gR1-10gR1 | enq: JS - running job cnt lock3 | name|mode | service ID | queue type | Other |
10gR2-12cR1 | enq: JS - sch locl enqs | name|mode | service ID | queue type | Other |
10gR1-10gR1 | enq: JS - slave enq get lock1 | name|mode | service ID | queue type | Other |
10gR1-10gR1 | enq: JS - slave enq get lock2 | name|mode | service ID | queue type | Other |
10gR2-19c | enq: JS - wdw op | name|mode | service ID | queue type | Other |
11gR2-19c | enq: JX - SQL statement queue | name|mode | sqlid | execid | Scheduler |
11gR2-19c | enq: JX - cleanup of queue | name|mode | sqlid | execid | Scheduler |
12cR2-19c | enq: JZ - Join group dictionary | name|mode | 0 | 0 | Other |
12cR2-19c | enq: KA - ACL control status | name|mode | 0 | 0 | Other |
11gR2-19c | enq: KD - determine DBRM master | name|mode | 0 | 0 | Other |
12cR1-19c | enq: KE - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: KI - contention | name|mode | client opcode | 0 | Other |
10gR1-10gR2 | enq: KK - context | name|mode | 0 | redo thread | Other |
12cR1-19c | enq: KL - contention | type|mode | id1 | id2 | Other |
10gR1-19c | enq: KM - contention | name|mode | type | type | Other |
10gR2-19c | enq: KO - fast object checkpoint | name|mode | 2 | 0 | Application |
10gR1-19c | enq: KP - contention | name|mode | 0 | 0 | Other |
11gR1-19c | enq: KQ - access ASM attribute | name|mode | group | entry | Other |
19c-19c | enq: KR - Add rule to ruleset | name|mode | R_OBJ# | 0 | Other |
19c-19c | enq: KR - Drop rule force | name|mode | R_OBJ# | 0 | Other |
19c-19c | enq: KR - Remove rule from ruleset | name|mode | R_OBJ# | 0 | Other |
10gR1-19c | enq: KT - contention | name|mode | plan # | 0 | Other |
12cR2-19c | enq: KV - IMA key vector access | name|mode | node#+sess#?Acursor#+kv# | kv # | Concurrency |
12cR1-19c | enq: KZ - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LA - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LB - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LC - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LD - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LE - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LF - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LG - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LH - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LI - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LJ - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LK - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LL - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LM - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LN - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LO - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LP - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LQ - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LR - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LS - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LT - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LU - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LV - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LX - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LY - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: LZ - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: MC - Securefile log | name|mode | 0 | hash(logname) | Other |
10gR1-19c | enq: MD - contention | name|mode | master object # | 0 | Other |
12cR1-19c | enq: MF - creating swap in instance | name|mode | logid | bktId<<16|instid | Other |
12cR1-19c | enq: MF - flush bkgnd periodic | name|mode | logid | bktId<<16|instid | Other |
12cR1-19c | enq: MF - flush client | name|mode | logid | bktId<<16|instid | Other |
12cR1-19c | enq: MF - flush destroy | name|mode | logid | bktId<<16|instid | Other |
12cR1-19c | enq: MF - flush prior error | name|mode | logid | bktId<<16|instid | Other |
12cR1-19c | enq: MF - flush space | name|mode | logid | bktId<<16|instid | Other |
19c-19c | enq: MG - MGA allocation | name|mode | qcserial# | rowsource#/mgacode# | Other |
19c-19c | enq: MG - client shared context allocation | name|mode | qcserial# | rowsource#/mgacode# | Other |
10gR1-19c | enq: MH - contention | name|mode | 0 | 0 | Other |
10gR2-19c | enq: MK - contention | name|mode | 0 | 0 | Other |
10gR1-19c | enq: ML - contention | name|mode | 0 | 0 | Other |
12cR2-12cR2 | enq: MM - AWR reply buffer | name|mode | 0 | 0 | Other |
19c-19c | enq: MM - MMON Autotask scheduling | name|mode | 0 | 0 | Other |
10gR1-19c | enq: MN - contention | name|mode | session ID | 0 | Other |
10gR2-19c | enq: MO - contention | name|mode | 0 | 0 | Other |
12cR1-19c | enq: MR - PDB open | name|mode | 0 or file # | type | Other |
12cR1-19c | enq: MR - adg instance recovery | name|mode | 0 or file # | type | Other |
12cR1-19c | enq: MR - any role transition | name|mode | 0 or file # | type | Other |
10gR1-19c | enq: MR - contention | name|mode | 0 or file # | type | Other |
12cR1-19c | enq: MR - datafile online | name|mode | 0 or file # | type | Other |
19c-19c | enq: MR - datafile pre-create | name|mode | 0 or file # | type | Other |
12cR1-19c | enq: MR - multi instance redo apply | name|mode | 0 or file # | type | Other |
19c-19c | enq: MR - preplugin recovery | name|mode | 0 or file # | type | Other |
11gR2-19c | enq: MR - standby role transition | name|mode | 0 or file # | type | Other |
10gR1-12cR2 | enq: MS - contention | name|mode | master object # | 0 | Other |
19c-19c | enq: MS - contention | name|mode | master object # | purpose | Other |
11gR2-19c | enq: MV - datafile move | name|mode | type | file # | Administrative |
10gR1-19c | enq: MW - contention | name|mode | Schedule Id | 0 | Other |
11gR1-19c | enq: MX - sync storage server info | name|mode | nodeid | instanceid | Other |
12cR1-19c | enq: NA - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NB - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NC - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: ND - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NE - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NF - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NG - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NH - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NI - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NJ - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NK - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NL - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NM - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NN - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NO - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NP - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NQ - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NR - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NS - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NT - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NU - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NV - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NX - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NY - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: NZ - contention | type|mode | id1 | id2 | Other |
10gR1-19c | enq: OC - contention | name|mode | 1 | 2 | Other |
11gR1-19c | enq: OD - Serializing DDLs | name|mode | object # | 0 | Other |
10gR1-19c | enq: OL - contention | name|mode | hash value | 0 | Other |
12cR1-19c | enq: OP - OLS Cleanup unused profiles | name|mode | object # | 0 | Other |
12cR1-19c | enq: OP - OLS Store user entries | name|mode | object # | 0 | Other |
10gR1-19c | enq: OQ - xsoq*histrecb | name|mode | resource id | 0 | Other |
10gR1-19c | enq: OQ - xsoqhiAlloc | name|mode | resource id | 0 | Other |
10gR1-19c | enq: OQ - xsoqhiClose | name|mode | resource id | 0 | Other |
10gR1-19c | enq: OQ - xsoqhiFlush | name|mode | resource id | 0 | Other |
10gR1-19c | enq: OQ - xsoqhistrecb | name|mode | resource id | 0 | Other |
12cR1-19c | enq: OT - TEXT: Generic Lock | name|mode | 0 | 0 | Other |
10gR2-19c | enq: OW - initialization | name|mode | 0 | 0 | Other |
10gR2-19c | enq: OW - termination | name|mode | 0 | 0 | Other |
12cR1-19c | enq: PA - modify a privilege capture | name|mode | 0 | 0 | Other |
12cR1-19c | enq: PA - read a privilege capture | name|mode | 0 | 0 | Other |
12cR1-19c | enq: PB - PDB Lock | name|mode | 0 | type | Other |
12cR2-19c | enq: PC - read privilege capture info | name|mode | 0 | 0 | Other |
12cR2-19c | enq: PC - update privilege capture info | name|mode | 0 | 0 | Other |
10gR1-19c | enq: PD - contention | name|mode | property name | key hash | Other |
10gR1-19c | enq: PE - contention | name|mode | parno | 0 | Other |
10gR1-19c | enq: PF - contention | name|mode | 0 | 0 | Other |
10gR1-19c | enq: PG - contention | name|mode | 0 | 0 | Other |
10gR1-19c | enq: PH - contention | name|mode | 0 | 0 | Other |
10gR1-19c | enq: PI - contention | name|mode | operation | serial # | Other |
12cR2-19c | enq: PJ - modify DV policy | name|mode | 0 | 0 | Other |
12cR2-19c | enq: PJ - read DV policy | name|mode | 0 | 0 | Other |
10gR1-19c | enq: PL - contention | name|mode | 0 | 0 | Other |
12cR1-19c | enq: PM - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: PP - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: PQ - QPT LB Trunc sync | name|mode | QT_OBJ# | 0 | Other |
12cR1-19c | enq: PQ - QPT Trunc | name|mode | QT_OBJ# | 0 | Other |
12cR2-19c | enq: PQ - QPT XSTART Trunc sync | name|mode | QT_OBJ# | 0 | Other |
12cR1-19c | enq: PQ - QPT add dqpt | name|mode | QT_OBJ# | 0 | Other |
12cR1-19c | enq: PQ - QPT add dqpt fg | name|mode | QT_OBJ# | 0 | Other |
12cR1-19c | enq: PQ - QPT add qpt | name|mode | QT_OBJ# | 0 | Other |
12cR1-19c | enq: PQ - QPT add qpt fg | name|mode | QT_OBJ# | 0 | Other |
12cR1-19c | enq: PQ - QPT drop dqpt | name|mode | QT_OBJ# | 0 | Other |
12cR1-19c | enq: PQ - QPT drop qpt | name|mode | QT_OBJ# | 0 | Other |
10gR1-11gR2 | enq: PR - contention | name|mode | 0 | 0 | Other |
12cR1-19c | enq: PR - contention | name|mode | type | dtp | Other |
10gR1-19c | enq: PS - contention | name|mode | instance | slave ID | Other |
12cR2-19c | enq: PT - ASM Storage May Split | name|mode | disk group # | type | Other |
10gR1-19c | enq: PT - contention | name|mode | disk group # | type | Other |
10gR1-11gR2 | enq: PV - syncshut | name|mode | 0 | 0 | Other |
12cR1-19c | enq: PV - syncshut | name|mode | class id | 0 | Other |
10gR1-11gR2 | enq: PV - syncstart | name|mode | 0 | 0 | Other |
12cR1-19c | enq: PV - syncstart | name|mode | class id | 0 | Other |
10gR1-19c | enq: PW - flush prewarm buffers | name|mode | 0 | 0 | Application |
10gR1-19c | enq: PW - perwarm status in dbw0 | name|mode | 0 | 0 | Other |
12cR2-19c | enq: PX - PDB instance recovery | name|mode | 0 or thread# | type | Other |
12cR1-12cR1 | enq: PY - AVM RTA access database | name|mode | dbid | instance | Other |
12cR1-12cR1 | enq: PY - AVM RTA access database 2 | name|mode | dbid | instance | Other |
12cR1-12cR1 | enq: PY - AVM RTA access instance | name|mode | dbid | instance | Other |
19c-19c | enq: PZ - flush passwordfile metadata | name|mode | 0 | 0 | Other |
19c-19c | enq: PZ - load passwordfile metadata | name|mode | 0 | 0 | Other |
12cR1-19c | enq: QA - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QB - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QC - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QD - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QE - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QF - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QG - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QH - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QI - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QJ - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QK - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QL - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QM - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QN - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QO - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QP - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QQ - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QR - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QS - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QT - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QU - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QV - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QX - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QY - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: QZ - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: RA - RT ADDM flood control | name|mode | 0 | 0 | Other |
10gR1-19c | enq: RB - contention | name|mode | disk group | 0 | Other |
11gR1-19c | enq: RC - Result Cache: Contention | name|mode | chunkNo | blockNo | Application |
11gR2-19c | enq: RD - RAC load | name|mode | sqlid | execid | Other |
11gR1-19c | enq: RE - block repair contention | name|mode | File Type or File number | block number | Other |
12cR2-19c | enq: RF - Broker Chief Lock | name|mode | lock operation | lock value | Other |
19c-19c | enq: RF - Broker LSBY FO Lock | name|mode | lock operation | lock value | Other |
12cR2-19c | enq: RF - Broker NSV Lock | name|mode | lock operation | lock value | Other |
12cR1-19c | enq: RF - Broker State Lock | name|mode | lock operation | lock value | Other |
11gR1-19c | enq: RF - DG Broker Current File ID | name|mode | lock operation | lock value | Other |
11gR1-19c | enq: RF - FSFO Observer Heartbeat | name|mode | lock operation | lock value | Other |
12cR1-19c | enq: RF - FSFO Primary Shutdown suspended | name|mode | lock operation | lock value | Other |
12cR1-19c | enq: RF - FSFO string buffer | name|mode | lock operation | lock value | Other |
10gR2-19c | enq: RF - RF - Database Automatic Disable | name|mode | lock operation | lock value | Other |
10gR2-10gR2 | enq: RF - RF - FSFO Observed | name|mode | lock operation | lock value | Other |
10gR2-10gR2 | enq: RF - RF - FSFO connectivity | name|mode | lock operation | lock value | Other |
10gR2-10gR2 | enq: RF - RF - FSFO state | name|mode | lock operation | lock value | Other |
10gR2-10gR2 | enq: RF - RF - FSFO synchronization | name|mode | lock operation | lock value | Other |
10gR2-10gR2 | enq: RF - RF - FSFO wait | name|mode | lock operation | lock value | Other |
10gR1-19c | enq: RF - atomicity | name|mode | lock operation | lock value | Other |
10gR1-19c | enq: RF - new AI | name|mode | lock operation | lock value | Other |
10gR2-19c | enq: RF - synch: DG Broker metadata | name|mode | lock operation | lock value | Other |
10gR1-10gR1 | enq: RF - synch: per-SGA Broker metadata | name|mode | lock operation | lock value | Other |
10gR1-10gR2 | enq: RF - synchronization: HC master | name|mode | lock operation | lock value | Other |
10gR1-19c | enq: RF - synchronization: aifo master | name|mode | lock operation | lock value | Other |
10gR1-10gR2 | enq: RF - synchronization: chief | name|mode | lock operation | lock value | Other |
10gR1-19c | enq: RF - synchronization: critical ai | name|mode | lock operation | lock value | Other |
12cR2-19c | enq: RG - Apply coord start/stop | name|mode | 0 | 0 | Other |
19c-19c | enq: RH - quarantine | name|mode | 0 | 0 | Other |
19c-19c | enq: RI - Reader Farm SQL Isolation | name|mode | 0 | 0 | Concurrency |
12cR2-19c | enq: RK - queue wallet and TS keys | name|mode | 0 | 0 | Other |
11gR2-19c | enq: RK - set key | name|mode | 0 | 0 | Other |
11gR2-19c | enq: RL - RAC wallet lock | name|mode | 0 | 0 | Other |
12cR1-19c | enq: RM - contention | type|mode | id1 | id2 | Other |
10gR1-19c | enq: RN - contention | name|mode | thread number | log number | Other |
10gR1-10gR1 | enq: RO - contention | name|mode | 1 | 0 | Application |
10gR2-19c | enq: RO - contention | name|mode | 2 | 0 | Application |
10gR1-10gR1 | enq: RO - fast object reuse | name|mode | 1 | 0 | Application |
10gR2-19c | enq: RO - fast object reuse | name|mode | 2 | 0 | Application |
10gR1-19c | enq: RP - contention | name|mode | file # | 1 or block | Other |
12cR2-19c | enq: RQ - AQ Cross Shard mem free | name|mode | Q_OBJ# | shard:mode | Other |
12cR2-19c | enq: RQ - AQ Cross update scn for delay | name|mode | Q_OBJ# | shard:mode | Other |
12cR2-19c | enq: RQ - AQ Dq Ptn Mapping | name|mode | Q_OBJ# | shard:mode | Other |
12cR2-19c | enq: RQ - AQ Enq commit block truncate | name|mode | Q_OBJ# | shard:mode | Other |
12cR2-19c | enq: RQ - AQ Enq commit incarnation wrap | name|mode | Q_OBJ# | shard:mode | Other |
12cR2-19c | enq: RQ - AQ Eq Ptn Mapping | name|mode | Q_OBJ# | shard:mode | Other |
12cR2-19c | enq: RQ - AQ Evict: block truncate | name|mode | Q_OBJ# | shard:mode | Other |
12cR2-19c | enq: RQ - AQ Rule evaluation segment load | name|mode | Q_OBJ# | shard:mode | Other |
12cR2-19c | enq: RQ - AQ Shid Gen | name|mode | Q_OBJ# | shard:mode | Other |
12cR2-19c | enq: RQ - AQ Trnc mem free | name|mode | Q_OBJ# | shard:mode | Other |
12cR2-19c | enq: RQ - AQ Trnc mem free by CP | name|mode | Q_OBJ# | shard:mode | Other |
12cR2-19c | enq: RQ - AQ Trnc mem free by LB | name|mode | Q_OBJ# | shard:mode | Other |
12cR2-19c | enq: RQ - AQ Trnc mem free remote | name|mode | Q_OBJ# | shard:mode | Other |
12cR2-19c | enq: RQ - AQ Unevict PGA: Queue View | name|mode | Q_OBJ# | shard:mode | Other |
12cR2-19c | enq: RQ - AQ Unevict PGA: setup subscriber | name|mode | Q_OBJ# | shard:mode | Other |
12cR2-19c | enq: RQ - AQ cached commit WM update | name|mode | Q_OBJ# | shard:mode | Other |
12cR2-19c | enq: RQ - AQ cached dequeue by condition | name|mode | Q_OBJ# | shard:mode | Other |
12cR1-19c | enq: RQ - AQ indexed cached commit | name|mode | Q_OBJ# | shard:mode | Other |
12cR2-19c | enq: RQ - AQ rollback retry count update | name|mode | Q_OBJ# | shard:mode | Other |
12cR1-19c | enq: RQ - AQ uncached commit WM update | name|mode | Q_OBJ# | shard:mode | Other |
12cR1-19c | enq: RQ - AQ uncached dequeue | name|mode | Q_OBJ# | shard:mode | Other |
12cR1-19c | enq: RQ - Cross export subshard | name|mode | Q_OBJ# | shard:mode | Other |
12cR1-19c | enq: RQ - Cross import subshard | name|mode | Q_OBJ# | shard:mode | Other |
12cR1-19c | enq: RQ - Cross update scn | name|mode | Q_OBJ# | shard:mode | Other |
12cR1-19c | enq: RQ - Dequeue update scn | name|mode | Q_OBJ# | shard:mode | Other |
12cR1-19c | enq: RQ - Enqueue commit cached | name|mode | Q_OBJ# | shard:mode | Other |
12cR1-19c | enq: RQ - Enqueue commit uncached | name|mode | Q_OBJ# | shard:mode | Other |
12cR1-19c | enq: RQ - Free shadow shard | name|mode | Q_OBJ# | shard:mode | Other |
12cR1-19c | enq: RQ - Parallel cross update scn | name|mode | Q_OBJ# | shard:mode | Other |
12cR1-19c | enq: RQ - Trucate subshard | name|mode | Q_OBJ# | shard:mode | Other |
10gR2-19c | enq: RR - contention | name|mode | lock# | not used | Other |
10gR1-19c | enq: RS - file delete | name|mode | record type | record id | Other |
10gR1-19c | enq: RS - persist alert level | name|mode | record type | record id | Other |
10gR1-19c | enq: RS - prevent aging list update | name|mode | record type | record id | Other |
10gR1-19c | enq: RS - prevent file delete | name|mode | record type | record id | Other |
10gR1-19c | enq: RS - read alert level | name|mode | record type | record id | Other |
10gR1-19c | enq: RS - record reuse | name|mode | record type | record id | Other |
10gR1-19c | enq: RS - write alert level | name|mode | record type | record id | Other |
10gR1-19c | enq: RT - contention | name|mode | redo thread | type | Other |
11gR2-19c | enq: RT - thread internal enable/disable | name|mode | redo thread | type | Other |
10gR2-19c | enq: RU - contention | name|mode | 0 | 0 | Other |
10gR2-19c | enq: RU - waiting | name|mode | 0 | 0 | Other |
10gR2-19c | enq: RW - MV metadata contention | name|mode | table obj# | 0 | Other |
11gR1-19c | enq: RX - relocate extent | name|mode | disk group #:file # | virtual extent number | Other |
12cR1-19c | enq: RX - unlock extent | name|mode | disk group #:file # | virtual extent number | Other |
12cR1-19c | enq: RZ - add element | name|mode | 0 | 0 | Other |
12cR1-19c | enq: RZ - remove element | name|mode | 0 | 0 | Other |
12cR2-19c | enq: SA - MRP SRL access | name|mode | 0 | 0 | Other |
12cR2-19c | enq: SA - standby redo logfiles | name|mode | 0 | 0 | Other |
10gR1-11gR2 | enq: SB - contention | name|mode | 0 | 0 | Other |
12cR1-19c | enq: SB - logical standby metadata | name|mode | 0 | 0 | Other |
12cR1-19c | enq: SB - table instantiation | name|mode | 0 | 0 | Other |
12cR1-19c | enq: SC - contention | type|mode | id1 | id2 | Other |
10gR2-19c | enq: SE - contention | name|mode | Session-id | Serial# | Other |
10gR1-19c | enq: SF - contention | name|mode | 0 | 0 | Other |
12cR1-19c | enq: SG - OLS Add Group | name|mode | object # | 0 | Other |
12cR1-19c | enq: SG - OLS Alter Group Parent | name|mode | object # | 0 | Other |
12cR1-19c | enq: SG - OLS Create Group | name|mode | object # | 0 | Other |
12cR1-19c | enq: SG - OLS Drop Group | name|mode | object # | 0 | Other |
10gR1-19c | enq: SH - contention | name|mode | 0 | 0 | Other |
10gR1-19c | enq: SI - contention | name|mode | object # | 0 | Other |
11gR1-19c | enq: SJ - Slave Task Cancel | name|mode | Slave process id | task id | Other |
10gR1-19c | enq: SK - contention | name|mode | tablespace # | dba | Other |
11gR1-19c | enq: SL - escalate lock | name|mode | kdlw lobid first half | kdlw lobid sec half | Other |
11gR1-19c | enq: SL - get lock | name|mode | kdlw lobid first half | kdlw lobid sec half | Other |
11gR1-19c | enq: SL - get lock for undo | name|mode | kdlw lobid first half | kdlw lobid sec half | Other |
12cR1-19c | enq: SM - contention | type|mode | id1 | id2 | Other |
12cR2-12cR2 | enq: SN - PDB SGA allocation | name|mode | 0 | 0 | Other |
19c-19c | enq: SN - PDB SGA allocation | name|mode | pdbid | 0 | Other |
12cR2-12cR2 | enq: SN - PDB SGA free | name|mode | 0 | 0 | Other |
19c-19c | enq: SN - PDB SGA free | name|mode | pdbid | 0 | Other |
12cR2-12cR2 | enq: SN - PDB SGA protection | name|mode | 0 | 0 | Other |
19c-19c | enq: SN - PDB SGA protection | name|mode | pdbid | 0 | Other |
11gR1-19c | enq: SO - contention | name|mode | object # | 0 | Other |
11gR2-11gR2 | enq: SP - contention | name|mode | id1 | id2 | Other |
12cR1-19c | enq: SP - contention 1 | name|mode | id1 | id2 | Other |
11gR2-19c | enq: SP - contention 2 | name|mode | id1 | id2 | Other |
11gR2-19c | enq: SP - contention 3 | name|mode | id1 | id2 | Other |
11gR2-19c | enq: SP - contention 4 | name|mode | id1 | id2 | Other |
10gR1-19c | enq: SQ - contention | name|mode | object # | 0 | Configuration |
10gR1-19c | enq: SR - contention | name|mode | operation | sequence # / apply # | Other |
10gR1-19c | enq: SS - contention | name|mode | tablespace # | dba | Other |
10gR1-19c | enq: ST - contention | name|mode | 0 | 0 | Configuration |
10gR1-19c | enq: SU - contention | name|mode | table space # | 0 | Other |
12cR1-19c | enq: SV - contention | type|mode | id1 | id2 | Other |
10gR1-19c | enq: SW - contention | name|mode | 0 | 0 | Other |
12cR2-19c | enq: SX - contention 5 | name|mode | id1 | id2 | Other |
12cR2-19c | enq: SX - contention 6 | name|mode | id1 | id2 | Other |
12cR2-19c | enq: SY - IM populate by other session | name|mode | tablespace # & objd | rdba | Other |
12cR2-19c | enq: SZ - contention | name|mode | tablespace # | rdba | Other |
10gR1-19c | enq: TA - contention | name|mode | operation | undo segment # / other | Other |
10gR1-19c | enq: TB - SQL Tuning Base Cache Load | name|mode | 1 | 2 | Other |
10gR1-19c | enq: TB - SQL Tuning Base Cache Update | name|mode | 1 | 2 | Other |
10gR1-19c | enq: TC - contention | name|mode | checkpoint ID | 0 | Other |
10gR1-19c | enq: TC - contention2 | name|mode | checkpoint ID | 0 | Other |
10gR1-19c | enq: TD - KTF dump entries | name|mode | 0 | 0 | Other |
10gR1-19c | enq: TE - KTF broadcast | name|mode | 0 | 0 | Other |
10gR1-12cR2 | enq: TF - contention | name|mode | tablespace # | relative file # | Other |
19c-19c | enq: TF - contention | name|mode | PDB ID & tablespace # | relative file # | Other |
12cR2-19c | enq: TG - IMCDT global resource | name|mode | container id # | 0 | Concurrency |
11gR1-19c | enq: TH - metric threshold evaluation | name|mode | 0 | 0 | Other |
12cR2-19c | enq: TI - IMCDT object HT | name|mode | query exec id # | qc session id # | Concurrency |
11gR1-19c | enq: TK - Auto Task Serialization | name|mode | 0-MMON?A 1-MMON Slave | 0 | Other |
11gR1-19c | enq: TK - Auto Task Slave Lockout | name|mode | 0-MMON?A 1-MMON Slave | 0 | Other |
10gR1-19c | enq: TL - contention | name|mode | 0 | 0 | Other |
10gR1-19c | enq: TM - contention | name|mode | object # | table/partition | Application |
10gR1-19c | enq: TO - contention | name|mode | object # | 1 | Other |
11gR2-19c | enq: TP - contention | name|mode | 0 | 0 | Other |
12cR1-12cR2 | enq: TQ - sq TM contention | name|mode | QT_OBJ# | 0 | Other |
19c-19c | enq: TQ - sq TM contention | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other |
10gR1-12cR2 | enq: TQ - DDL contention | name|mode | QT_OBJ# | 0 | Other |
19c-19c | enq: TQ - DDL contention | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other |
11gR1-12cR2 | enq: TQ - DDL-INI contention | name|mode | QT_OBJ# | 0 | Other |
19c-19c | enq: TQ - DDL-INI contention | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other |
10gR1-12cR2 | enq: TQ - INI contention | name|mode | QT_OBJ# | 0 | Other |
19c-19c | enq: TQ - INI contention | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other |
12cR1-12cR2 | enq: TQ - INI sq contention | name|mode | QT_OBJ# | 0 | Other |
19c-19c | enq: TQ - INI sq contention | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other |
19c-19c | enq: TQ - LB drop volatile shard | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other |
12cR2-12cR2 | enq: TQ - MC free sync at cross job end | name|mode | QT_OBJ# | 0 | Other |
19c-19c | enq: TQ - MC free sync at cross job end | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other |
12cR2-12cR2 | enq: TQ - MC free sync at cross job start | name|mode | QT_OBJ# | 0 | Other |
19c-19c | enq: TQ - MC free sync at cross job start | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other |
12cR2-12cR2 | enq: TQ - MC free sync at cross job stop | name|mode | QT_OBJ# | 0 | Other |
19c-19c | enq: TQ - MC free sync at cross job stop | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other |
12cR2-12cR2 | enq: TQ - MC free sync at export subshard | name|mode | QT_OBJ# | 0 | Other |
19c-19c | enq: TQ - MC free sync at export subshard | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other |
19c-19c | enq: TQ - TM Job cache initialization | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other |
19c-19c | enq: TQ - TM Job cache use | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other |
10gR1-12cR2 | enq: TQ - TM contention | name|mode | QT_OBJ# | 0 | Other |
19c-19c | enq: TQ - TM contention | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other |
12cR2-12cR2 | enq: TQ - create eviction table | name|mode | QT_OBJ# | 0 | Other |
19c-19c | enq: TQ - create eviction table | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other |
12cR2-19c | enq: TR - database key open check | name|mode | pdbid | ts# | Other |
12cR2-19c | enq: TR - serialize TS rekeys | name|mode | pdbid | ts# | Other |
12cR2-19c | enq: TR - serialize system rekeys | name|mode | pdbid | ts# | Other |
10gR1-19c | enq: TS - contention | name|mode | tablespace ID | dba | Other |
10gR1-19c | enq: TT - contention | name|mode | tablespace ID | operation | Other |
12cR2-19c | enq: TU - UMF topology | name|mode | 0 | 0 | Other |
10gR1-19c | enq: TW - contention | name|mode | 0 | operation | Administrative |
10gR1-19c | enq: TX - allocate ITL entry | name|mode | usn<<16 | slot | sequence | Configuration |
10gR1-19c | enq: TX - contention | name|mode | usn<<16 | slot | sequence | Other |
10gR1-19c | enq: TX - index contention | name|mode | usn<<16 | slot | sequence | Concurrency |
10gR1-19c | enq: TX - row lock contention | name|mode | usn<<16 | slot | sequence | Application |
12cR2-19c | enq: TZ - contention | name|mode | tablespace # | dba | Other |
12cR2-19c | enq: UF - undo stat flush per PDB | name|mode | 0 | 0 | Other |
10gR1-19c | enq: UL - contention | name|mode | id | 0 | Application |
12cR2-12cR2 | enq: UM - UMF task pool | name|mode | 0 | 0 | Other |
10gR1-19c | enq: US - contention | name|mode | undo segment # | 0 | Other |
12cR2-19c | enq: UT - transfer audit records | name|mode | TRANSFER AUDIT RECORDS | 0 | Other |
12cR1-19c | enq: VA - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VB - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VC - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VD - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VE - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VF - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VG - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VH - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VI - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VJ - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VK - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VL - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VM - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VN - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VO - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VP - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VQ - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VR - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VS - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VT - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VU - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VV - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VX - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VY - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: VZ - contention | type|mode | id1 | id2 | Other |
10gR1-19c | enq: WA - contention | name|mode | 0 | 0 | Other |
19c-19c | enq: WD - AWR mail package retrieval | name|mode | 0 | 0 | Other |
19c-19c | enq: WE - AWR auto-export | name|mode | 0 | 0 | Other |
10gR1-19c | enq: WF - contention | name|mode | 0 | 0 | Other |
11gR1-19c | enq: WG - delete fso | name|mode | kdlw lobid first half | kdlw lobid sec half | Other |
11gR1-19c | enq: WG - lock fso | name|mode | kdlw lobid first half | kdlw lobid sec half | Concurrency |
19c-19c | enq: WI - AWR import | name|mode | 0 | 0 | Other |
12cR1-19c | enq: WL - Far Sync Fail Over | name|mode | log # / thread id # | sequence # | Other |
12cR2-19c | enq: WL - Network Throttle | name|mode | log # / thread id # | sequence # | Other |
11gR2-12cR1 | enq: WL - RAC-wide SGA contention | name|mode | log # / thread id # | sequence # | Other |
12cR2-19c | enq: WL - RAC-wide SGA dump | name|mode | log # / thread id # | sequence # | Other |
12cR2-19c | enq: WL - RAC-wide SGA initialize | name|mode | log # / thread id # | sequence # | Other |
12cR2-19c | enq: WL - RAC-wide SGA write | name|mode | log # / thread id # | sequence # | Other |
11gR2-19c | enq: WL - RFS global state contention | name|mode | log # / thread id # | sequence # | Other |
12cR2-19c | enq: WL - SNA access/locking | name|mode | log # / thread id # | sequence # | Other |
12cR1-19c | enq: WL - Switchover To Primary | name|mode | log # / thread id # | sequence # | Other |
11gR2-19c | enq: WL - Test access/locking | name|mode | log # / thread id # | sequence # | Other |
10gR1-19c | enq: WL - contention | name|mode | log # / thread id # | sequence # | Other |
12cR1-12cR1 | enq: WL - redo_db table query | name|mode | log # / thread id # | sequence # | Other |
12cR1-19c | enq: WL - redo_db table update | name|mode | log # / thread id # | sequence # | Other |
12cR1-12cR1 | enq: WL - redo_log table query | name|mode | log # / thread id # | sequence # | Other |
12cR1-19c | enq: WL - redo_log table update | name|mode | log # / thread id # | sequence # | Other |
12cR1-12cR1 | enq: WL - redo_rta table query | name|mode | log # / thread id # | sequence # | Other |
12cR1-12cR1 | enq: WL - redo_rta table update | name|mode | log # / thread id # | sequence # | Other |
11gR1-19c | enq: WM - WLM Plan activation | name|mode | 0 | 0 | Other |
19c-19c | enq: WN - rw snapshot synchronization | name|mode | pluggable database id | snapshot name | Other |
10gR1-19c | enq: WP - contention | name|mode | 0 | 0 | Other |
10gR2-19c | enq: WR - contention | name|mode | thread id # | sequence # | Other |
12cR1-19c | enq: WS - contention | type|mode | id1 | id2 | Other |
12cR2-19c | enq: WT - contention | name|mode | 0 | 0 | Other |
12cR1-19c | enq: XB - contention | type|mode | id1 | id2 | Other |
11gR1-19c | enq: XC - XDB Configuration | name|mode | Other | ||
12cR1-19c | enq: XD - ASM disk OFFLINE | name|mode | opcode | notused | Other |
12cR1-19c | enq: XD - ASM disk ONLINE | name|mode | opcode | notused | Other |
11gR2-19c | enq: XD - ASM disk drop/add | name|mode | opcode | notused | Other |
10gR1-19c | enq: XH - contention | name|mode | 0 | 0 | Other |
12cR1-19c | enq: XK - contention | type|mode | id1 | id2 | Other |
11gR1-19c | enq: XL - fault extent map | name|mode | map id | nothing | Other |
12cR1-19c | enq: XM - contention | type|mode | id1 | id2 | Other |
11gR2-19c | enq: XQ - purification | name|mode | disk group # | unused | Other |
10gR2-19c | enq: XQ - recovery | name|mode | disk group # | unused | Other |
10gR2-19c | enq: XQ - relocation | name|mode | disk group # | unused | Other |
10gR1-19c | enq: XR - database force logging | name|mode | operation | 0 | Other |
10gR1-19c | enq: XR - quiesce database | name|mode | operation | 0 | Other |
10gR1-19c | enq: XY - contention | name|mode | id1 | id2 | Other |
12cR1-19c | enq: YA - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YB - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YC - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YD - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YE - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YF - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YG - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YH - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YI - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YJ - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YK - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YL - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YM - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YN - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YO - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YP - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YQ - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YR - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YS - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YT - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YU - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YV - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YX - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YY - contention | type|mode | id1 | id2 | Other |
12cR1-19c | enq: YZ - contention | type|mode | id1 | id2 | Other |
11gR1-19c | enq: ZA - add std audit table partition | name|mode | KZAM Aud Partition | 0 | Other |
12cR2-19c | enq: ZB - contention | name|mode | tablespace # | dba | Other |
12cR2-19c | enq: ZC - FS Seg contention | name|mode | tsn# | objd# | Other |
12cR2-19c | enq: ZD - FS CU mod | name|mode | segid | startdba | Other |
11gR1-19c | enq: ZF - add fga audit table partition | name|mode | KZAM Fga Partition | 0 | Other |
10gR2-19c | enq: ZG - contention | name|mode | file group id | version id | Administrative |
11gR2-19c | enq: ZH - compression analysis | name|mode | obj# | ulevel | Other |
12cR2-19c | enq: ZL - LogMiner foreign log metadata | name|mode | session ID | 0 | Other |
19c-19c | enq: ZP - Private Temporary Table | name|mode | sess# | ser# | Other |
12cR2-19c | enq: ZQ - quiesce | name|mode | ts# | dba | Other |
12cR2-19c | enq: ZQ - register | name|mode | ts# | dba | Other |
12cR2-19c | enq: ZR - ZDLRA check quiesce tasks | name|mode | operation | id | Other |
12cR2-19c | enq: ZR - ZDLRA check servlet quiescence | name|mode | operation | id | Other |
12cR2-19c | enq: ZR - ZDLRA invalidate plans | name|mode | operation | id | Other |
12cR2-19c | enq: ZR - ZDLRA lock API | name|mode | operation | id | Other |
12cR2-19c | enq: ZR - ZDLRA lock db | name|mode | operation | id | Other |
12cR2-19c | enq: ZR - ZDLRA lock scheduler | name|mode | operation | id | Other |
12cR2-19c | enq: ZR - ZDLRA lock storage loc | name|mode | operation | id | Other |
12cR2-19c | enq: ZR - ZDLRA lock timer queue | name|mode | operation | id | Other |
12cR2-19c | enq: ZR - ZDLRA protect plans | name|mode | operation | id | Other |
12cR2-19c | enq: ZR - ZDLRA purge storage loc | name|mode | operation | id | Other |
12cR2-19c | enq: ZR - ZDLRA quiesce servlets | name|mode | operation | id | Other |
12cR2-19c | enq: ZR - ZDLRA quiesce tasks | name|mode | operation | id | Other |
12cR2-19c | enq: ZR - ZDLRA run scheduler | name|mode | operation | id | Other |
12cR2-19c | enq: ZR - ZDLRA serialize unregister db | name|mode | operation | id | Other |
12cR2-19c | enq: ZR - ZDLRA spare enq 10 | name|mode | operation | id | Other |
12cR1-19c | enq: ZS - excl access to spill audit file | name|mode | Spillover audit file | 0 | Other |
12cR2-19c | enq: ZX - repopulation file write | name|mode | filename | block number | Other |
11gR2-19c | enq: ZZ - update hash tables | name|mode | KSBXIC Action | 0 | Other |
8i-9i | enqueue | name|mode | id1 | id2 | |
10gR2-19c | events in waitclass Other | Other | |||
10gR1-19c | extent map load/unlock | group | file | extent | Other |
12cR2-19c | extent map locked | mid | Other | ||
11gR1-19c | external table misc IO | filectx | iocode | P3 | User I/O |
12cR1-19c | external table open | filectx | file# | User I/O | |
11gR1-19c | external table read | filectx | file# | size | User I/O |
12cR1-19c | external table seek | filectx | file# | pos | User I/O |
11gR1-19c | external table write | filectx | file# | size | User I/O |
11gR1-19c | fbar timer | sleep time | failed | Idle | |
9i-9i | fib/fob latch | ||||
8i-9i | file identify | fib | file name | opcode | |
8i-9i | file open | fib | iov | 0 | |
12cR1-19c | first spare wait event | p1 | p2 | p3 | Other |
10gR1-19c | flashback buf free by RVWR | Other | |||
10gR1-19c | flashback free VI log | Other | |||
11gR2-19c | flashback log file read | log# | block# | Bytes | System I/O |
11gR2-19c | flashback log file sync | User I/O | |||
11gR2-19c | flashback log file write | log# | block# | Bytes | System I/O |
10gR1-19c | flashback log switch | Other | |||
12cR2-19c | force-cr-override flush | file# | block# | Other | |
10gR1-10gR1 | foreground creation: start | Other | |||
10gR1-10gR1 | foreground creation: wait | Other | |||
8i-19c | free buffer waits | file# | block# | set-id# | Configuration |
8i-19c | free global transaction table entry | tries | Other | ||
8i-19c | free process state object | Other | |||
10gR1-19c | gc assume | le | Cluster | ||
10gR1-19c | gc block recovery request | file# | block# | class# | Cluster |
10gR1-10gR2 | gc buffer busy | file# | block# | id# | Cluster |
11gR1-19c | gc buffer busy acquire | file# | block# | class# | Cluster |
11gR1-19c | gc buffer busy release | file# | block# | class# | Cluster |
11gR1-19c | gc cancel retry | Cluster | |||
10gR1-12cR1 | gc claim | Cluster | |||
12cR2-19c | gc claim | file# | block# | class# | Cluster |
10gR1-19c | gc cr block 2-way | Cluster | |||
10gR1-19c | gc cr block 3-way | Cluster | |||
10gR1-19c | gc cr block busy | Cluster | |||
10gR1-19c | gc cr block congested | Cluster | |||
10gR2-19c | gc cr block lost | Cluster | |||
19c-19c | gc cr block remote read | file# | block# | class# | Cluster |
10gR1-12cR1 | gc cr block unknown | Cluster | |||
10gR1-19c | gc cr cancel | le | Cluster | ||
12cR2-19c | gc cr cluster flash cache read | Cluster | |||
10gR1-19c | gc cr disk read | Cluster | |||
10gR1-19c | gc cr disk request | file# | block# | class# | Cluster |
10gR1-19c | gc cr failure | Cluster | |||
12cR2-19c | gc cr flash cache copy | Cluster | |||
10gR1-19c | gc cr grant 2-way | Cluster | |||
12cR2-19c | gc cr grant 3-way | Cluster | |||
10gR1-19c | gc cr grant busy | Cluster | |||
12cR2-19c | gc cr grant cluster flash cache read | Cluster | |||
10gR1-19c | gc cr grant congested | Cluster | |||
12cR1-19c | gc cr grant ka | Cluster | |||
19c-19c | gc cr grant read-mostly invalidation | Cluster | |||
19c-19c | gc cr grant read-only instance invalidation | Cluster | |||
10gR1-12cR1 | gc cr grant unknown | Cluster | |||
12cR2-19c | gc cr multi block grant | Cluster | |||
12cR2-19c | gc cr multi block mixed | Cluster | |||
10gR1-19c | gc cr multi block request | file# | block# | class# | Cluster |
10gR1-19c | gc cr request | file# | block# | class# | Cluster |
10gR1-19c | gc current block 2-way | Cluster | |||
10gR1-19c | gc current block 3-way | Cluster | |||
10gR1-19c | gc current block busy | Cluster | |||
10gR1-19c | gc current block congested | Cluster | |||
10gR2-19c | gc current block lost | Cluster | |||
10gR1-12cR1 | gc current block unknown | Cluster | |||
10gR1-19c | gc current cancel | le | Cluster | ||
10gR1-19c | gc current grant 2-way | Cluster | |||
12cR2-19c | gc current grant 3-way | Cluster | |||
10gR1-19c | gc current grant busy | Cluster | |||
12cR2-19c | gc current grant cluster flash cache read | Cluster | |||
10gR1-19c | gc current grant congested | Cluster | |||
12cR1-19c | gc current grant ka | Cluster | |||
19c-19c | gc current grant read-mostly invalidation | Cluster | |||
19c-19c | gc current grant read-only instance invalidation | Cluster | |||
10gR1-12cR1 | gc current grant unknown | Cluster | |||
12cR2-19c | gc current index split | le | Cluster | ||
10gR1-19c | gc current multi block request | file# | block# | id# | Cluster |
10gR1-19c | gc current request | file# | block# | id# | Cluster |
10gR1-19c | gc current retry | Cluster | |||
10gR1-19c | gc current split | Cluster | |||
10gR1-10gR1 | gc domain validation | Cluster | |||
10gR2-19c | gc domain validation | file# | block# | class# | Cluster |
11gR2-19c | gc flushed buffer | Cluster | |||
10gR1-19c | gc freelist | Cluster | |||
12cR2-19c | gc imc multi block quiesce | file# | block# | Cluster | |
12cR2-19c | gc imc multi block request | file# | block# | Cluster | |
12cR2-19c | gc index operation | usn# | slot# | seq# | Cluster |
10gR2-12cR1 | gc object scan | Cluster | |||
10gR1-10gR2 | gc prepare | Cluster | |||
10gR2-19c | gc quiesce | Cluster | |||
10gR1-10gR1 | gc quiesce wait | Cluster | |||
11gR1-19c | gc recovery | Cluster | |||
10gR1-19c | gc recovery free | Cluster | |||
10gR1-10gR2 | gc recovery quiesce | Cluster | |||
11gR1-19c | gc recovery quiesce | file# | block# | class# | Cluster |
10gR1-10gR1 | gc remaster | Cluster | |||
10gR2-19c | gc remaster | file# | block# | class# | Cluster |
12cR2-19c | gc send complete | Cluster | |||
12cR2-19c | gc transaction table | count | Cluster | ||
10gR1-19c | gcs ddet enter server mode | Other | |||
9i-19c | gcs domain validation | cluinc | rcvinc | Other | |
10gR1-19c | gcs drm freeze begin | Other | |||
10gR1-19c | gcs drm freeze in enter server mode | Other | |||
10gR1-19c | gcs enter server mode | Other | |||
9i-9i | gcs for action | ||||
11gR2-19c | gcs lmon dirtydetach step completion | domain id | location | Other | |
10gR1-19c | gcs log flush sync | waittime | poll | event | Other |
10gR1-12cR2 | gcs remastering wait for read latch | Other | |||
19c-19c | gcs remastering wait for read latch | flags | idx1 | idx2 | Other |
10gR1-11gR1 | gcs remastering wait for write latch | Other | |||
9i-9i | gcs remote message | waittime | poll | p3 | |
10gR1-19c | gcs remote message | waittime | poll | event | Idle |
10gR1-19c | gcs resource directory to be unfrozen | Other | |||
11gR2-19c | gcs retry nowait latch get | location | Other | ||
9i-19c | gcs to be enabled | Other | |||
19c-19c | gcs yield cpu | Idle | |||
11gR1-19c | ges DFS hang analysis phase 2 acks | Other | |||
9i-19c | ges LMD suspend for testing event | Other | |||
9i-19c | ges LMD to inherit communication channels | Other | |||
9i-12cR1 | ges LMD to shutdown | Other | |||
9i-9i | ges LMON for send buffers to be empty | ||||
9i-19c | ges LMON for send queues | Other | |||
9i-19c | ges LMON to get to FTDONE | Other | |||
9i-19c | ges LMON to join CGS group | Other | |||
9i-9i | ges LMS suspend for testing event | ||||
11gR1-19c | ges RMS0 retry add redo log | Other | |||
9i-19c | ges cached resource cleanup | waittime | Other | ||
9i-19c | ges cancel | Other | |||
9i-9i | ges cgs de-registration | ||||
9i-9i | ges cgs registration | ||||
10gR1-19c | ges cgs registration | where | Other | ||
11gR2-19c | ges client process to exit | Other | |||
9i-9i | ges drm deferred close | ||||
9i-9i | ges drm freeze begin | ||||
9i-19c | ges enter server mode | Other | |||
9i-19c | ges generic event | Other | |||
9i-11gR1 | ges global resource directory to be frozen | Other | |||
11gR2-19c | ges global resource directory to be frozen | location | Other | ||
9i-9i | ges global resource directory to be unfrozen | ||||
9i-10gR1 | ges inquiry response | type|mode | id1 | id2 | Other |
10gR2-19c | ges inquiry response | type|mode|where | id1 | id2 | Other |
12cR2-19c | ges instance reconfig name entry query | retry | inst | Other | |
19c-19c | ges ipc enter server mode | Other | |||
9i-19c | ges lmd and pmon to attach | Other | |||
11gR2-19c | ges lmd sync during reconfig | location | Other | ||
11gR2-19c | ges lmd/lmses to freeze in rcfg | lmd/lms id | Other | ||
9i-11gR1 | ges lmd/lmses to freeze in rcfg - mrcvr | Other | |||
9i-9i | ges lmd/lmses to freeze in rcfg - srcvr | ||||
11gR2-19c | ges lmd/lmses to unfreeze in rcfg | lmd/lms id | Other | ||
9i-11gR1 | ges lmd/lmses to unfreeze in rcfg - mrcvr | Other | |||
9i-9i | ges lmd/lmses to unfreeze in rcfg - srcvr | ||||
11gR2-19c | ges lms sync during dynamic remastering and reconfig | location | lms id | Other | |
9i-19c | ges master to get established for SCN op | Other | |||
11gR2-19c | ges message buffer allocation | pool | request | allocated | Other |
9i-19c | ges performance test completion | Other | |||
9i-19c | ges pmon to exit | Other | |||
9i-9i | ges proc table latch - kjdrptref | ||||
9i-9i | ges process allocation | ||||
9i-19c | ges process with outstanding i/o | pid | Other | ||
9i-11gR1 | ges reconfiguration to start | Other | |||
9i-19c | ges remote message | waittime | loop | p3 | Idle |
9i-19c | ges resource cleanout during enqueue open | Other | |||
9i-19c | ges resource cleanout during enqueue open-cvt | Other | |||
10gR1-19c | ges resource directory to be unfrozen | Other | |||
12cR1-19c | ges resource enqueue open retry sleep | Other | |||
10gR1-12cR1 | ges retry query node | Other | |||
9i-19c | ges reusing os pid | pid | count | Other | |
12cR2-19c | ges server process to shutdown | type | Other | ||
9i-9i | ges server qs to be empty - kjbrrit | ||||
10gR1-19c | ges user error | error | Other | ||
10gR1-19c | ges wait for lmon to be ready | Other | |||
11gR2-19c | ges yield cpu in reconfig | location | Other | ||
11gR1-19c | ges/gcs diag dump | location | Other | ||
9i-9i | ges1 LMON to wake up LMD | ||||
9i-19c | ges1 LMON to wake up LMD - mrcvr | Other | |||
9i-19c | ges2 LMON to wake up LMD - mrcvr | Other | |||
9i-9i | ges2 LMON to wake up LMD - srcvr | ||||
9i-19c | ges2 LMON to wake up lms - mrcvr 2 | Other | |||
10gR1-19c | ges2 LMON to wake up lms - mrcvr 3 | Other | |||
9i-19c | ges2 proc latch in rm latch get 1 | Other | |||
9i-19c | ges2 proc latch in rm latch get 2 | Other | |||
12cR2-19c | get branch/thread/sequence enqueue | Other | |||
9i-9i | global cache assume wait | le | |||
8i-9i | global cache bg acks | count | loops | ||
9i-9i | global cache busy | file# | block# | id | |
10gR1-19c | global cache busy | group | file# | block# | Other |
9i-9i | global cache cancel wait | le | |||
9i-9i | global cache claim wait | ||||
9i-9i | global cache cr cancel wait | le | |||
9i-9i | global cache cr disk request | file# | block# | le | |
8i-8i | global cache cr request | file# | block# | lenum | |
9i-9i | global cache cr request | file# | block# | le | |
9i-9i | global cache domain validation | ||||
8i-9i | global cache freelist wait | ||||
8i-8i | global cache lock busy | file# | block# | lenum | |
8i-8i | global cache lock cleanup | file# | block# | lenum | |
8i-8i | global cache lock null to s | file# | block# | lenum | |
8i-8i | global cache lock null to x | file# | block# | lenum | |
8i-8i | global cache lock open s | file# | block# | lenum | |
8i-8i | global cache lock open x | file# | block# | lenum | |
8i-8i | global cache lock s to x | file# | block# | lenum | |
8i-8i | global cache multiple locks | file# | block# | lenum | |
9i-9i | global cache null to s | file# | block# | le | |
9i-9i | global cache null to x | file# | block# | le | |
9i-9i | global cache open s | file# | block# | le | |
9i-9i | global cache open x | file# | block# | le | |
8i-8i | global cache pending ast | lenum | |||
9i-9i | global cache pending ast | le | |||
8i-8i | global cache pending asts | count | |||
9i-9i | global cache pred cancel wait | le | |||
9i-9i | global cache quiesce wait | le | |||
9i-9i | global cache recovery free wait | ||||
9i-9i | global cache recovery quiesce wait | le | |||
9i-9i | global cache remastering wait | ||||
8i-9i | global cache retry prepare | file# | block# | ||
8i-8i | global cache retry request | file# | block# | ||
9i-9i | global cache s to x | file# | block# | le | |
10gR1-19c | global enqueue expand wait | Other | |||
11gR2-19c | global plug and play automatic resource creation | where | Other | ||
12cR1-19c | gopp msg | gopp id | Idle | ||
11gR2-19c | heartbeat monitor sleep | Idle | |||
12cR1-19c | heartbeat redo informer | Idle | |||
9i-19c | i/o slave wait | msg ptr | Other | ||
12cR2-19c | imco timer | sleep time | failed | Idle | |
8i-19c | imm op | msg ptr | Other | ||
8i-10gR2 | inactive session | session# | waited | Other | |
11gR1-12cR1 | inactive session | session# | waited | instance|serial | Other |
12cR2-19c | inactive session | session# | serial | instance | Other |
8i-19c | inactive transaction branch | branch# | waited | Other | |
19c-19c | index (re)build lock or pin object | namespace | lock_mode | pin_mode | Administrative |
9i-19c | index (re)build online cleanup | object | mode | wait | Administrative |
9i-19c | index (re)build online merge | object | mode | wait | Administrative |
9i-19c | index (re)build online start | object | mode | wait | Administrative |
8i-19c | index block split | rootdba | level | childdba | Other |
12cR2-19c | influx scn | file# | block# | class# | Other |
8i-9i | instance recovery | undo segment# | |||
8i-19c | instance state change | layer | value | waited | Other |
19c-19c | internal test event (index merge) | Other | |||
19c-19c | internal test event (index split branch) | Other | |||
19c-19c | internal test event (index split leaf) | Other | |||
8i-19c | io done | msg ptr | System I/O | ||
12cR1-19c | ioctl to cell offload device | cellhash# | Other | ||
12cR1-19c | iowp file id | iowp id | Idle | ||
12cR1-19c | iowp io | count | intr | timeout | System I/O |
12cR1-19c | iowp msg | iowp id | Idle | ||
10gR1-19c | job scheduler coordinator slave wait | Other | |||
10gR2-19c | jobq slave TJ process wait | Other | |||
10gR2-19c | jobq slave shutdown wait | Other | |||
9i-19c | jobq slave wait | Idle | |||
19c-19c | kcbw: cache protect wait | Other | |||
9i-19c | kcbzps | Other | |||
9i-11gR1 | kcrrrcp | Other | |||
10gR2-19c | kdblil wait before retrying ORA-54 | Other | |||
9i-12cR2 | kdic_do_merge | Other | |||
10gR1-19c | kfcl: instance recovery | group | obj# | block# | Other |
10gR1-11gR2 | kfk: async disk IO | count | intr | timeout | System I/O |
12cR1-19c | kfk: async disk IO | count | where | timeout | System I/O |
9i-19c | kgltwait | Other | |||
12cR2-19c | kill all read-only instances in cluster | Other | |||
10gR1-19c | kjbdomalc allocate recovery domain - retry | Other | |||
10gR1-11gR1 | kjbdrmcvtq lmon drm quiesce: ping completion | Other | |||
11gR2-19c | kjbdrmcvtq lmon drm quiesce: ping completion | location | lms id | Other | |
10gR1-19c | kjbopen wait for recovery domain attach | Other | |||
9i-12cR2 | kjctcisnd: Queue/Send client message | Other | |||
9i-19c | kjctssqmg: quick message send wait | Other | |||
10gR1-19c | kjudomatt wait for recovery domain attach | Other | |||
10gR1-19c | kjudomdet wait for recovery domain detach | Other | |||
9i-12cR2 | kjxgrtest | Other | |||
9i-19c | kkdlgon | Other | |||
9i-19c | kkdlhpon | Other | |||
9i-19c | kkdlsipon | Other | |||
9i-19c | kksfbc child completion | Other | |||
9i-19c | kksfbc research | Other | |||
9i-19c | kkshgnc reloop | Other | |||
9i-19c | kksscl hash split | Other | |||
9i-10gR1 | knlWaitForStartup | Other | |||
9i-10gR1 | knlqdeq | Other | |||
9i-19c | knpc_acwm_AwaitChangedWaterMark | Other | |||
9i-19c | knpc_anq_AwaitNonemptyQueue | Other | |||
9i-19c | knpsmai | Other | |||
10gR2-19c | kpodplck wait before retrying ORA-54 | Other | |||
9i-19c | ksbcic | Other | |||
9i-19c | ksbsrv | Other | |||
9i-12cR2 | ksdxexeother | Other | |||
9i-12cR2 | ksdxexeotherwait | Other | |||
10gR1-11gR1 | ksfd: async disk IO | count | intr | timeout | System I/O |
10gR1-10gR1 | ksfd: fib/fob latch | Other | |||
10gR1-19c | ksim generic wait event | where | wait_count | Other | |
9i-9i | ksimret is busy in recovery | wait_count | |||
11gR1-19c | kslwait unit test event 1 | p1 | p2 | p3 | Scheduler |
11gR1-19c | kslwait unit test event 2 | p1 | p2 | p3 | Other |
11gR1-19c | kslwait unit test event 3 | p1 | p2 | p3 | Other |
9i-10gR2 | ksqded | Other | |||
10gR2-10gR2 | kst: async disk IO | count | intr | timeout | System I/O |
9i-9i | ksu process alloc latch yield | ||||
10gR1-19c | ksv slave avail wait | Other | |||
9i-19c | ksxr poll remote instances | Other | |||
10gR2-19c | ksxr wait for mount shared | Other | |||
10gR1-19c | ktfbtgex | tsn | Other | ||
10gR1-19c | ktm: instance recovery | undo segment# | Other | ||
9i-19c | ktsambl | Other | |||
9i-19c | kttm2d | Other | |||
10gR1-19c | kupp process wait | Other | |||
9i-19c | kxfxse | kxfxse debug wait: stalling for slave 0 | Other | ||
9i-19c | kxfxsp | kxfxsp debug wait: stalling for slave 0 | Other | ||
8i-19c | latch activity | address | number | process# | Other |
8i-12cR1 | latch free | address | number | tries | Other |
12cR2-19c | latch free | address | number | why | Other |
12cR2-19c | latch: AQ OPT Background Master Latch | address | number | why | Other |
12cR2-19c | latch: AQ Sharded subscriber statistics latch | address | number | why | Other |
10gR2-12cR1 | latch: Change Notification Hash table latch | address | number | tries | Other |
12cR2-19c | latch: Change Notification Hash table latch | address | number | why | Other |
12cR2-19c | latch: Column stats entry latch | address | number | why | Other |
12cR2-19c | latch: GCS logfile block | address | number | why | Other |
12cR2-19c | latch: GCS logfile write queue | address | number | why | Other |
12cR1-12cR1 | latch: ILM access tracking extent | address | number | tries | Other |
12cR2-19c | latch: ILM access tracking extent | address | number | why | Other |
12cR1-12cR1 | latch: ILM activity tracking latch | address | number | tries | Other |
12cR2-19c | latch: ILM activity tracking latch | address | number | why | Other |
12cR2-19c | latch: IM area sb latch | address | number | why | Other |
12cR2-19c | latch: IM area scb latch | address | number | why | Other |
12cR2-19c | latch: IM emb latch | address | number | why | Other |
12cR2-19c | latch: IM seg hdr latch | address | number | why | Other |
12cR2-19c | latch: IMFS defer write list | address | number | why | Other |
10gR1-12cR1 | latch: In memory undo latch | address | number | tries | Concurrency |
12cR2-19c | latch: In memory undo latch | address | number | why | Concurrency |
10gR1-10gR2 | latch: KCL gc element parent latch | address | number | tries | Other |
19c-19c | latch: MGA asr alloc latch | address | number | why | Concurrency |
19c-19c | latch: MGA heap latch | address | number | why | Concurrency |
19c-19c | latch: MGA pid alloc latch | address | number | why | Concurrency |
19c-19c | latch: MGA shared context latch | address | number | why | Concurrency |
19c-19c | latch: MGA shared context root latch | address | number | why | Concurrency |
10gR1-12cR1 | latch: MQL Tracking Latch | address | number | tries | Concurrency |
12cR2-19c | latch: MQL Tracking Latch | address | number | why | Concurrency |
11gR2-12cR1 | latch: PX hash array latch | address | number | tries | Other |
12cR2-19c | latch: PX hash array latch | address | number | why | Other |
12cR1-12cR1 | latch: SGA Logging Bkt Latch | address | number | tries | Other |
12cR2-19c | latch: SGA Logging Bkt Latch | address | number | why | Other |
12cR1-12cR1 | latch: SGA Logging Log Latch | address | number | tries | Other |
12cR2-19c | latch: SGA Logging Log Latch | address | number | why | Other |
10gR2-12cR1 | latch: Undo Hint Latch | address | number | tries | Concurrency |
12cR2-19c | latch: Undo Hint Latch | address | number | why | Concurrency |
11gR2-12cR1 | latch: WCR: processes HT | address | number | tries | Other |
12cR2-19c | latch: WCR: processes HT | address | number | why | Other |
11gR2-12cR1 | latch: WCR: sync | address | number | tries | Other |
12cR2-19c | latch: WCR: sync | address | number | why | Other |
12cR1-12cR1 | latch: active service list | address | number | tries | Other |
12cR2-19c | latch: active service list | address | number | why | Other |
10gR1-12cR1 | latch: cache buffer handles | address | number | tries | Other |
12cR2-19c | latch: cache buffer handles | address | number | why | Other |
10gR1-12cR1 | latch: cache buffers chains | address | number | tries | Concurrency |
12cR2-19c | latch: cache buffers chains | address | number | why | Concurrency |
10gR1-12cR1 | latch: cache buffers lru chain | address | number | tries | Other |
12cR2-19c | latch: cache buffers lru chain | address | number | why | Other |
11gR2-12cR1 | latch: call allocation | address | number | tries | Other |
12cR2-19c | latch: call allocation | address | number | why | Other |
11gR1-12cR1 | latch: change notification client cache latch | address | number | tries | Other |
12cR2-19c | latch: change notification client cache latch | address | number | why | Other |
10gR1-12cR1 | latch: checkpoint queue latch | address | number | tries | Other |
12cR2-19c | latch: checkpoint queue latch | address | number | why | Other |
10gR1-12cR1 | latch: enqueue hash chains | address | number | tries | Other |
12cR2-19c | latch: enqueue hash chains | address | number | why | Other |
11gR1-12cR1 | latch: gc element | address | number | tries | Other |
12cR2-19c | latch: gc element | address | number | why | Other |
10gR1-12cR1 | latch: gcs resource hash | address | number | tries | Other |
12cR2-19c | latch: gcs resource hash | address | number | why | Other |
10gR1-12cR1 | latch: ges resource hash list | address | number | tries | Other |
12cR2-19c | latch: ges resource hash list | address | number | why | Other |
19c-19c | latch: java patching | address | number | why | Other |
12cR1-12cR1 | latch: kjci process context latch | address | number | tries | Other |
12cR2-19c | latch: kjci process context latch | address | number | why | Other |
12cR1-12cR1 | latch: kjci request sequence latch | address | number | tries | Other |
12cR2-19c | latch: kjci request sequence latch | address | number | why | Other |
12cR1-12cR1 | latch: kjoeq omni enqueue hash bucket latch | address | number | tries | Other |
12cR2-19c | latch: kjoeq omni enqueue hash bucket latch | address | number | why | Other |
12cR1-12cR1 | latch: kjoer owner hash bucket | address | number | tries | Other |
12cR2-19c | latch: kjoer owner hash bucket | address | number | why | Other |
12cR1-12cR1 | latch: ksm sga alloc latch | address | number | tries | Other |
12cR2-19c | latch: ksm sga alloc latch | address | number | why | Other |
12cR1-12cR1 | latch: ksolt alloc | address | number | tries | Other |
12cR2-19c | latch: ksolt lwth alloc | address | number | why | Other |
19c-19c | latch: last service list | address | number | why | Other |
10gR1-10gR1 | latch: latch wait list | address | number | tries | Other |
10gR1-10gR2 | latch: library cache | address | number | tries | Concurrency |
10gR1-10gR2 | latch: library cache lock | address | number | tries | Concurrency |
10gR1-10gR2 | latch: library cache pin | address | number | tries | Concurrency |
11gR1-12cR1 | latch: lob segment dispenser latch | address | number | tries | Other |
12cR2-19c | latch: lob segment dispenser latch | address | number | why | Other |
11gR1-12cR1 | latch: lob segment hash table latch | address | number | tries | Other |
12cR2-19c | latch: lob segment hash table latch | address | number | why | Other |
11gR1-12cR1 | latch: lob segment query latch | address | number | tries | Other |
12cR2-19c | latch: lob segment query latch | address | number | why | Other |
10gR1-12cR1 | latch: messages | address | number | tries | Other |
12cR2-19c | latch: messages | address | number | why | Other |
19c-19c | latch: obj/range reuse redo processing | address | number | why | Other |
10gR1-10gR2 | latch: object queue header heap | address | number | tries | Other |
10gR1-12cR1 | latch: object queue header operation | address | number | tries | Other |
12cR2-19c | latch: object queue header operation | address | number | why | Other |
10gR1-12cR1 | latch: parallel query alloc buffer | address | number | tries | Other |
12cR2-19c | latch: parallel query alloc buffer | address | number | why | Other |
12cR2-19c | latch: pdb enqueue hash chains | address | number | why | Other |
10gR1-12cR1 | latch: redo allocation | address | number | tries | Other |
12cR2-19c | latch: redo allocation | address | number | why | Other |
10gR1-12cR1 | latch: redo copy | address | number | tries | Configuration |
12cR2-19c | latch: redo copy | address | number | why | Configuration |
10gR1-12cR1 | latch: redo writing | address | number | tries | Configuration |
12cR2-19c | latch: redo writing | address | number | why | Configuration |
10gR1-12cR1 | latch: row cache objects | address | number | tries | Other |
12cR2-19c | latch: row cache objects | address | number | why | Concurrency |
12cR2-19c | latch: service drain list | address | number | why | Other |
10gR1-12cR1 | latch: session allocation | address | number | tries | Other |
12cR2-19c | latch: session allocation | address | number | why | Other |
10gR1-12cR1 | latch: shared pool | address | number | tries | Configuration |
12cR2-19c | latch: shared pool | address | number | why | Concurrency |
10gR1-12cR1 | latch: undo global data | address | number | tries | Other |
12cR2-19c | latch: undo global data | address | number | why | Other |
10gR1-12cR1 | latch: virtual circuit queues | address | number | tries | Other |
12cR2-19c | latch: virtual circuit queues | address | number | why | Other |
12cR1-19c | libcache interrupt action by LCK | location | Concurrency | ||
8i-8i | library cache load lock | object address | lock address | 10*mask+namespace | |
9i-19c | library cache load lock | object address | lock address | 100*mask+namespace | Concurrency |
8i-8i | library cache lock | handle address | lock address | 10*mode+namespace | |
9i-19c | library cache lock | handle address | lock address | 100*mode+namespace | Concurrency |
8i-8i | library cache pin | handle address | pin address | 10*mode+namespace | |
9i-19c | library cache pin | handle address | pin address | 100*mode+namespace | Concurrency |
10gR1-19c | library cache revalidation | Other | |||
10gR2-19c | library cache shutdown | Other | |||
12cR2-19c | library cache: bucket mutex X | idn | value | where | Concurrency |
12cR2-19c | library cache: dependency mutex X | idn | value | where | Concurrency |
11gR1-19c | library cache: mutex S | idn | value | where | Concurrency |
11gR1-19c | library cache: mutex X | idn | value | where | Concurrency |
12cR1-12cR1 | lightweight thread operation | PURPOSE | LTHREAD TYPE | Other | |
12cR2-19c | lightweight thread operation | PURPOSE | ARG1 | ARG2 | Other |
12cR2-19c | lightweight thread task completion | Tasks left | task_count | ARG3 | Other |
8i-19c | listen endpoint status | end-point# | status | Other | |
11gR1-19c | listener registration dump | dump | Other | ||
10gR2-11gR1 | lms flush message acks | loc | tries | Other | |
11gR2-19c | lms flush message acks | id | Other | ||
8i-19c | local write wait | file# | block# | User I/O | |
10gR1-19c | lock close | group | lms# | Other | |
9i-19c | lock deadlock retry | Other | |||
9i-19c | lock escalate retry | Other | |||
8i-8i | lock manager wait for dlmd to shutdown | ||||
8i-8i | lock manager wait for remote message | waittime | |||
10gR1-19c | lock release pending | group | file# | block# | Other |
10gR1-19c | lock remastering | Cluster | |||
8i-19c | log buffer space | Configuration | |||
8i-19c | log file parallel write | files | blocks | requests | System I/O |
19c-19c | log file pmem persist read | thread | group | member | System I/O |
19c-19c | log file pmem persist write | thread | group | member | System I/O |
8i-19c | log file sequential read | log# | block# | blocks | System I/O |
8i-19c | log file single write | log# | block# | blocks | System I/O |
8i-19c | log file switch (archiving needed) | Configuration | |||
8i-19c | log file switch (checkpoint incomplete) | Configuration | |||
8i-19c | log file switch (clearing log file) | Other | |||
10gR2-19c | log file switch (private strand flush incomplete) | Configuration | |||
8i-19c | log file switch completion | Configuration | |||
8i-11gR1 | log file sync | buffer# | Commit | ||
11gR2-19c | log file sync | buffer# | sync scn | Commit | |
12cR2-19c | log file sync: PDB shutdown abort | sync scn | Other | ||
12cR1-19c | log file sync: SCN ordering | buffer# | sync scn | Concurrency | |
8i-19c | log switch/archive | thread# | Other | ||
10gR1-19c | log write(even) | group# | Other | ||
10gR1-19c | log write(odd) | group# | Other | ||
9i-19c | logout restrictor | Concurrency | |||
12cR1-19c | lreg timer | succ | wait | fail | Idle |
12cR1-19c | master diskmon read | Other | |||
11gR1-19c | master diskmon startup | Other | |||
10gR1-19c | master exit | alive slaves | Other | ||
19c-19c | memoptimize write buffer get | Configuration | |||
19c-19c | memoptimize write drain idle | Idle | |||
19c-19c | move audit tablespace delay | Other | |||
8i-19c | multiple dbwriter suspend/resume for file offline | Administrative | |||
9i-9i | name service busy | ||||
8i-12cR2 | name-service call wait | waittime | Other | ||
19c-19c | name-service call wait | waittime | op | loc | Other |
12cR1-19c | netp network | netp id | Idle | ||
10gR1-19c | no free buffers | group# | obj# | block# | Other |
10gR1-19c | no free locks | Other | |||
12cR2-19c | nologging fetch slave idle | Idle | |||
12cR1-19c | nologging range consumption list | Configuration | |||
12cR1-19c | nologging standby txn commit | Commit | |||
9i-19c | null event | Other | |||
12cR1-19c | opening cell offload device | cellhash# | Other | ||
9i-19c | opishd | Other | |||
10gR2-19c | optimizer stats update retry | Other | |||
12cR1-19c | oracle thread bootstrap | pname | Other | ||
19c-19c | oradebug request completion | Other | |||
19c-19c | oradebug request slot | Other | |||
12cR1-19c | os thread creation | pname | is_process | Other | |
10gR2-11gR2 | os thread startup | Concurrency | |||
11gR1-19c | parallel recovery change buffer free | Other | |||
11gR1-19c | parallel recovery control message reply | Other | |||
11gR1-19c | parallel recovery coord send blocked | Other | |||
11gR1-19c | parallel recovery coord wait for reply | Other | |||
12cR1-19c | parallel recovery coord: all replies | Other | |||
12cR1-19c | parallel recovery coordinator idle wait | Idle | |||
9i-10gR2 | parallel recovery coordinator waits for cleanup of slaves | Idle | |||
11gR1-19c | parallel recovery coordinator waits for slave cleanup | Idle | |||
19c-19c | parallel recovery push change | Other | |||
11gR1-19c | parallel recovery read buffer free | Other | |||
12cR2-19c | parallel recovery redo cache buffer free | Other | |||
11gR1-19c | parallel recovery slave idle wait | Idle | |||
11gR1-19c | parallel recovery slave next change | Idle | |||
11gR1-19c | parallel recovery slave wait for change | Other | |||
8i-19c | pending global transaction(s) | scans | Other | ||
9i-19c | pi renounce write complete | file# | block# | Cluster | |
8i-19c | pipe get | handle address | buffer length | timeout | Idle |
8i-19c | pipe put | handle address | record length | timeout | Concurrency |
12cR2-19c | pman timer | Idle | |||
12cR2-19c | pmon cleanup | op | Other | ||
12cR1-12cR1 | pmon cleanup on exit | op | Other | ||
11gR2-19c | pmon dblkr tst event | index | Other | ||
8i-8i | pmon rdomain attach | ||||
12cR2-19c | pmon shutdown | type | num | Other | |
8i-19c | pmon timer | duration | Idle | ||
11gR1-19c | pool server timer | sleep time | Idle | ||
12cR1-19c | prefetch warmup block being transferred | file# | block# | id# | Other |
10gR2-11gR2 | prewarm transfer retry | Other | |||
10gR2-19c | prior spawner clean up | process_pid | process_sno | Other | |
12cR2-19c | process allocation slot | Other | |||
11gR1-19c | process diagnostic dump | Other | |||
12cR2-19c | process in prespawned state | Idle | |||
10gR1-11gR2 | process shutdown | type | process# | waited | Other |
12cR1-19c | process shutdown | type | process# | Other | |
8i-11gR2 | process startup | type | process# | waited | Other |
12cR1-19c | process startup | type | process# | Other | |
10gR2-19c | process terminate | Other | |||
10gR1-19c | qerex_gdml | Other | |||
8i-10gR1 | queue messages | queue id | process# | wait time | Idle |
10gR1-11gR2 | queue slave messages | Other | |||
9i-9i | qxdid_gdml | ||||
8i-19c | rdbms ipc message | timeout | Idle | ||
8i-19c | rdbms ipc message block | Other | |||
8i-11gR2 | rdbms ipc reply | from_process | timeout | Other | |
12cR1-19c | rdbms ipc reply | from_process | Other | ||
10gR1-19c | read by other session | file# | block# | class# | User I/O |
19c-19c | read/write snapshot completion | file object handle | snapshot scn | pluggable database id | Other |
11gR1-19c | readable standby redo apply remastering | Other | |||
12cR1-19c | reap block level offload operations | slowcellhash# | Other | ||
12cR2-19c | recovery active instance mapping setup | Other | |||
12cR2-19c | recovery apply pending | Other | |||
10gR1-19c | recovery area: computing applied logs | Other | |||
10gR1-19c | recovery area: computing backed up files | Other | |||
10gR1-19c | recovery area: computing dropped files | Other | |||
10gR1-10gR2 | recovery area: computing identical files | Other | |||
10gR1-19c | recovery area: computing obsolete files | Other | |||
11gR1-19c | recovery buffer pinned | file# | block# | Other | |
12cR2-19c | recovery cancel | Other | |||
12cR2-19c | recovery checkpoint | Other | |||
12cR2-19c | recovery coordinator apply pending | Other | |||
12cR2-19c | recovery coordinator idle | Idle | |||
12cR2-19c | recovery coordinator marker apply | Other | |||
12cR2-19c | recovery coordinator message | Other | |||
12cR2-19c | recovery file header update for checkpoint | Other | |||
12cR2-19c | recovery file header update for fuzziness | Other | |||
12cR2-19c | recovery fuzzy update | Other | |||
11gR2-19c | recovery instance recovery completion | Other | |||
12cR2-19c | recovery logmerger idle | Idle | |||
12cR2-19c | recovery marker apply | Other | |||
12cR2-19c | recovery merge pending | Other | |||
12cR1-12cR1 | recovery merger idle wait | Idle | |||
12cR2-19c | recovery message | Other | |||
12cR2-19c | recovery metadata latch | Other | |||
12cR2-19c | recovery move influx buffers | Other | |||
12cR2-19c | recovery new thread enable | Other | |||
9i-19c | recovery read | System I/O | |||
12cR1-19c | recovery receive buffer free | Other | |||
12cR2-19c | recovery receiver idle | Idle | |||
12cR1-12cR1 | recovery receiver idle wait | Idle | |||
12cR2-19c | recovery remote file verification | Other | |||
12cR1-19c | recovery send buffer free | Other | |||
12cR2-19c | recovery sender idle | Idle | |||
12cR1-12cR1 | recovery sender idle wait | Idle | |||
12cR2-19c | recovery shutdown | Other | |||
12cR2-19c | recovery slaves to be informed | Other | |||
12cR2-19c | recovery timestamp | Other | |||
12cR2-19c | redo log switch request completion | Other | |||
8i-10gR1 | refresh controlfile command | Administrative | |||
8i-19c | reliable message | channel context | channel handle | broadcast message | Other |
11gR1-19c | remote db file read | clientid | count | intr | Network |
11gR1-19c | remote db file write | clientid | count | intr | Network |
11gR1-19c | remote db operation | clientid | operation | timeout | Network |
12cR2-19c | remote log force - SCN range | file# | block# | class# | Cluster |
12cR1-19c | remote log force - buffer read | file# | block# | class# | Cluster |
12cR1-12cR1 | remote log force - buffer send | file# | block# | class# | Cluster |
12cR1-19c | remote log force - buffer update | file# | block# | class# | Cluster |
12cR1-12cR1 | remote log force - commit | Commit | |||
12cR2-19c | remote log force - commit | thread# | thread scn | session scn | Commit |
12cR1-12cR1 | remote log force - log switch/recovery | force SCN | Cluster | ||
12cR2-19c | remote log force - log switch/recovery | thread# | thread SCN | force SCN | Cluster |
12cR2-19c | remote log force - session cleanout | thread# | thread scn | session scn | Cluster |
12cR2-19c | resmgr: I/O rate limit | location | Scheduler | ||
12cR2-19c | resmgr: redo throttle | Scheduler | |||
11gR1-11gR1 | resmgr:I/O prioritization | location | Scheduler | ||
10gR1-19c | resmgr:become active | location | Scheduler | ||
10gR1-11gR2 | resmgr:cpu quantum | location | Scheduler | ||
12cR1-19c | resmgr:cpu quantum | location | consumer group id | Scheduler | |
10gR1-19c | resmgr:internal state change | location | Concurrency | ||
10gR1-19c | resmgr:internal state cleanup | location | Other | ||
11gR2-19c | resmgr:large I/O queued | location | Scheduler | ||
12cR2-19c | resmgr:plan change | con_id | Other | ||
12cR1-19c | resmgr:pq queued | location | Scheduler | ||
10gR1-19c | resmgr:sessions to exit | location | Concurrency | ||
11gR2-12cR1 | resmgr:small I/O queued | location | Scheduler | ||
8i-9i | resmgr:wait in actses run | ||||
9i-9i | resmgr:waiting for cschlat1 | ||||
9i-9i | resmgr:waiting for cschlat2 | ||||
9i-9i | resmgr:waiting for cschlat3 | ||||
9i-9i | resmgr:waiting for cschlat4 | ||||
8i-9i | resmgr:waiting in check | ||||
8i-9i | resmgr:waiting in check2 | ||||
8i-9i | resmgr:waiting in end wait | ||||
8i-9i | resmgr:waiting in end wait2 | ||||
8i-9i | resmgr:waiting in enter | ||||
8i-9i | resmgr:waiting in enter2 | ||||
8i-9i | resmgr:waiting in run (queued) | ||||
8i-9i | resmgr:waiting in shutdown | ||||
8i-9i | resmgr:waiting in system stop | ||||
12cR2-19c | result cache lock wait | object no | Concurrency | ||
19c-19c | retry CFTXN during close | Other | |||
12cR2-12cR2 | retry cftxn during close | Other | |||
8i-19c | retry contact SCN lock master | Cluster | |||
10gR1-10gR1 | rfc_open_retry | DMON waiting to retry configuration file open | Other | ||
10gR1-10gR2 | rfi_drcx_site_del | DRCX waiting for site to delete metadata | Other | ||
10gR1-10gR2 | rfi_insv_shut | wait for INSV to shutdown | Other | ||
10gR1-10gR2 | rfi_insv_start | wait for INSV to start | Other | ||
10gR1-10gR2 | rfi_nsv_deldef | NSVx to defer delete response message post to DMON | Other | ||
10gR1-10gR2 | rfi_nsv_md_close | NSVx metadata file close wait | Other | ||
10gR1-10gR2 | rfi_nsv_md_write | NSVx metadata file write wait | Other | ||
10gR1-10gR2 | rfi_nsv_postdef | NSVx to defer message post to DMON | Other | ||
10gR1-10gR2 | rfi_nsv_shut | wait for NSVx to shutdown | Other | ||
10gR1-10gR2 | rfi_nsv_start | wait for NSVx to start | Other | ||
10gR1-10gR2 | rfi_recon1 | letting site register with its local listener before connect ret | Other | ||
10gR1-10gR2 | rfi_recon2 | retrying connection for sending to remote DRCX | Other | ||
10gR1-10gR2 | rfm_dmon_last_gasp | DMON waiting on the last gasp event | Other | ||
10gR1-10gR2 | rfm_dmon_pdefer | DMON phase deferral wait | Other | ||
10gR1-10gR2 | rfm_dmon_shut | wait for DMON to shutdown | Other | ||
10gR1-10gR2 | rfm_dmon_timeout_op | DMON waiting to timeout an operation | Other | ||
10gR1-10gR2 | rfm_pmon_dso_stall | PMON delete state object stall | Other | ||
10gR1-10gR2 | rfrdb_dbop | waiting for database to be opened | Other | ||
10gR1-10gR2 | rfrdb_recon1 | reconnecting back to new primary site during standby viability c | Other | ||
10gR1-10gR2 | rfrdb_recon2 | waiting for standby database to be mounted | Other | ||
10gR1-10gR2 | rfrdb_try235 | waiting for retrying the query to mask ORA-235 error | Other | ||
10gR1-10gR2 | rfrla_lapp1 | waiting for logical apply engine to initialize | Other | ||
10gR1-10gR2 | rfrla_lapp2 | checking for logical apply engine run-down progress | Other | ||
10gR1-10gR2 | rfrla_lapp3 | waiting for new primary to initialize tables | Other | ||
10gR1-10gR2 | rfrla_lapp4 | waiting for v$logstdby_stats view to be initialized | Other | ||
10gR1-10gR2 | rfrla_lapp5 | waiting to reconnect to primary that is in BUILD_UP | Other | ||
10gR2-10gR2 | rfrld_rhmrpwait | waiting for MRP0 to stop while reinstating old primary to logica | Other | ||
10gR1-10gR2 | rfrm_dbcl | RSM notifier: waiting for sql latch on db close | Other | ||
10gR1-10gR2 | rfrm_dbop | RSM notifier: waiting for sql latch on db open | Other | ||
10gR1-10gR2 | rfrm_nonzero_sub_count | wait for subscriber count to become nonzero | Other | ||
10gR1-10gR2 | rfrm_rsm_shut | wait for RSMx processes to shutdown | Other | ||
10gR1-10gR2 | rfrm_rsm_so_attach | wait for RSMx to attach to state object | Other | ||
10gR1-10gR2 | rfrm_rsm_start | wait for RSMx processes to start | Other | ||
10gR1-10gR2 | rfrm_stall | RSM stall due to event RSM_STALL | Other | ||
10gR1-10gR2 | rfrm_zero_sub_count | wait for subscriber count to become zero | Other | ||
10gR1-10gR2 | rfrpa_mrpdn | waiting for MRP0 to stop while bringing physical apply engine of | Other | ||
10gR1-10gR2 | rfrpa_mrpup | waiting for MRP0 to start while bringing physical apply engine o | Other | ||
10gR1-10gR2 | rfrxpt_pdl | waiting for retrying potential dataloss calculation before switc | Other | ||
9i-10gR2 | rfrxptarcurlog | waiting for logical apply engine to finish initialization | Other | ||
10gR1-19c | rollback operations active | operation count | Other | ||
10gR1-19c | rollback operations block full | max operations | Other | ||
10gR2-19c | rolling migration: cluster quiesce | location | waits | Other | |
19c-19c | rolling migration: orphans detected | Other | |||
12cR1-19c | row cache cleanup | Other | |||
8i-19c | row cache lock | cache id | mode | request | Concurrency |
12cR2-19c | row cache mutex | cache id | where requested | Concurrency | |
12cR1-19c | row cache process | location | Other | ||
9i-11gR2 | row cache read | cache id | address | times | Concurrency |
12cR1-19c | row cache read | cache id | Concurrency | ||
9i-9i | sbtbackup | ||||
9i-9i | sbtclose | ||||
9i-9i | sbtclose2 | ||||
9i-9i | sbtcommand | ||||
9i-9i | sbtend | ||||
9i-9i | sbterror | ||||
9i-9i | sbtinfo | ||||
9i-9i | sbtinfo2 | ||||
9i-9i | sbtinit | ||||
9i-9i | sbtinit2 | ||||
9i-9i | sbtopen | ||||
9i-9i | sbtpcbackup | ||||
9i-9i | sbtpccancel | ||||
9i-9i | sbtpccommit | ||||
9i-9i | sbtpcend | ||||
9i-9i | sbtpcquerybackup | ||||
9i-9i | sbtpcqueryrestore | ||||
9i-9i | sbtpcrestore | ||||
9i-9i | sbtpcstart | ||||
9i-9i | sbtpcstatus | ||||
9i-9i | sbtpcvalidate | ||||
9i-9i | sbtread | ||||
9i-9i | sbtread2 | ||||
9i-9i | sbtremove | ||||
9i-9i | sbtremove2 | ||||
9i-9i | sbtrestore | ||||
9i-9i | sbtwrite | ||||
9i-9i | sbtwrite2 | ||||
12cR1-19c | second spare wait event | p1 | p2 | p3 | Other |
8i-19c | secondary event | event # | wait time | Other | |
19c-19c | secure protocol error delay | Other | |||
11gR1-19c | securefile chain update | seghdr | fsb | Concurrency | |
11gR1-19c | securefile direct-read completion | User I/O | |||
11gR1-19c | securefile direct-write completion | User I/O | |||
9i-19c | select wait | Other | |||
12cR2-19c | service monitor: inst recovery completion | Cluster | |||
19c-19c | session allocation inc count | Other | |||
10gR2-12cR1 | set director factor wait | Other | |||
11gR1-19c | shared server idle wait | Idle | |||
12cR1-19c | shutdown after switchover to standby | Other | |||
10gR1-19c | simulated log write delay | Other | |||
8i-19c | single-task message | Idle | |||
9i-10gR1 | slave TJ process wait | Other | |||
8i-19c | slave exit | nalive | sleeptime | loop | Other |
9i-10gR1 | slave shutdown wait | Other | |||
8i-8i | slave wait | msg ptr | |||
8i-19c | smon timer | sleep time | failed | Idle | |
8i-19c | sort segment request | Configuration | |||
11gR1-19c | standby query scn advance | Other | |||
9i-19c | statement suspended | wait error to be cleared | |||
8i-19c | switch logfile command | Administrative | |||
9i-19c | switch undo - offline | Administrative | |||
12cR2-19c | tablespace key change | pdb# | ts# | file# | Other |
12cR1-19c | target log write size | Other | |||
10gR1-19c | test long ops | Other | |||
8i-10gR1 | trace continue | delay time | Other | ||
8i-10gR1 | trace unfreeze | Other | |||
8i-10gR1 | trace writer I/O | Other | |||
8i-10gR1 | trace writer flush | Other | |||
8i-19c | transaction | undo seg#|slot# | wrap# | count | Other |
10gR2-19c | tsm with timeout | Other | |||
12cR2-19c | txn cache read version | Other | |||
9i-19c | txn to complete | Other | |||
8i-19c | unbound tx | Other | |||
8i-19c | undo segment extension | segment# | Configuration | ||
8i-19c | undo segment recovery | segment# | tx flags | Other | |
8i-19c | undo segment tx slot | segment# | Configuration | ||
10gR2-19c | undo_retention publish retry | where | retry_count | Other | |
8i-8i | unread message | channel context | channel handle count | ||
8i-8i | unread message | channel context | channel handle | ||
9i-9i | unspecified event | ||||
10gR1-19c | unspecified wait event | Other | |||
11gR2-19c | utl_file I/O | User I/O | |||
12cR1-19c | virtual circuit next request | circuit# | type | Idle | |
8i-10gR2 | virtual circuit status | circuit# | status | Idle | |
11gR1-19c | virtual circuit wait | circuit# | type | Network | |
10gR1-19c | wait active processes | Other | |||
8i-8i | wait for DLM latch | latchtype | gets | immediate | |
8i-8i | wait for DLM process allocation | ||||
8i-8i | wait for DLM reconfiguration to complete | ||||
10gR1-10gR2 | wait for EMON to die | Other | |||
10gR1-19c | wait for EMON to process ntfns | Configuration | |||
8i-19c | wait for EMON to spawn | Other | |||
9i-19c | wait for FMON to come up | Other | |||
11gR1-11gR1 | wait for IMR CSS join retry | retry count | Other | ||
8i-8i | wait for LMON to get to FTDONE | ||||
9i-10gR1 | wait for Logical Standby Apply shutdown | Other | |||
9i-19c | wait for MTTR advisory state object | Other | |||
10gR1-10gR1 | wait for SGA component shrink | component id | current size | target size | Other |
9i-19c | wait for a paralle reco to abort | Other | |||
9i-19c | wait for a undo record | Other | |||
9i-10gR1 | wait for activate message | Idle | |||
9i-19c | wait for another txn - rollback to savepoint | Other | |||
9i-19c | wait for another txn - txn abort | Other | |||
9i-19c | wait for another txn - undo rcv abort | Other | |||
9i-19c | wait for assert messages to be sent | Other | |||
8i-8i | wait for cached resource cleanup by LMON | waittime | |||
10gR1-19c | wait for change | Other | |||
8i-8i | wait for checking DLM domain | ||||
8i-8i | wait for gms de-registration | ||||
8i-8i | wait for gms registration | ||||
8i-8i | wait for influx DLM latch | latchtype | latchaddr | ||
8i-8i | wait for inquiry response | type|mode | id1 | id2 | |
11gR1-19c | wait for kkpo ref-partitioning *TEST EVENT* | where | Other | ||
8i-8i | wait for lmd and pmon to attach DLM | ||||
8i-8i | wait for lock db to become frozen | ||||
8i-8i | wait for lock db to unfreeze | ||||
9i-9i | wait for master scn | waittime | |||
10gR1-19c | wait for master scn | waittime | startscn | ackscn | Other |
8i-8i | wait for master to get estableshed for SCN op | ||||
9i-9i | wait for membership change | ||||
9i-11gR1 | wait for membership synchronization | Other | |||
9i-11gR1 | wait for message ack | Other | |||
8i-8i | wait for ownership of group-owned lock | ||||
8i-8i | wait for pmon to exit | ||||
9i-19c | wait for possible quiesce finish | Administrative | |||
8i-8i | wait for process with outstanding i/o | pid | |||
8i-8i | wait for reconfiguration to start | ||||
9i-11gR1 | wait for record update | Other | |||
8i-8i | wait for recovery domain attach | ||||
8i-8i | wait for recovery domain latch in kjpr | ||||
8i-8i | wait for recovery validate to complete | ||||
8i-8i | wait for register recovery to complete | ||||
8i-8i | wait for res latch in recovery | ||||
10gR1-10gR1 | wait for resize request completion | Other | |||
8i-8i | wait for resource cleanout during lock open | ||||
8i-8i | wait for resource cleanout during lock open-cvt | ||||
8i-8i | wait for reusing os pid | pid | count | ||
9i-11gR1 | wait for rr lock release | Other | |||
10gR1-12cR1 | wait for scn ack | pending_nd | scnwrp | scnbas | Other |
12cR2-19c | wait for scn ack | pending_nd | scn | Other | |
9i-9i | wait for scn from all nodes | waittime | |||
8i-8i | wait for send buffers to send DLM message | ||||
10gR1-10gR1 | wait for sga_target resize | Other | |||
9i-11gR1 | wait for split-brain resolution | Other | |||
9i-19c | wait for stopper event to be increased | Other | |||
9i-19c | wait for sync ack | cluinc | pending_nd | Other | |
8i-8i | wait for tickets to send DLM message | ||||
9i-11gR1 | wait for tmc2 to complete | Other | |||
9i-10gR1 | wait for transaction | Idle | |||
9i-19c | wait for unread message on broadcast channel | channel context | channel handle | Idle | |
9i-19c | wait for unread message on multiple broadcast channels | channel context | channel handle count | Idle | |
9i-19c | wait for verification ack | cluinc | pending_insts | Other | |
9i-11gR1 | wait for votes | Other | |||
8i-8i | wait in DLM enter server mode | ||||
8i-8i | wait in DLM lock cancel | ||||
9i-12cR2 | wait list latch activity | address | number | process# | Other |
9i-12cR1 | wait list latch free | address | number | tries | Other |
12cR2-19c | wait list latch free | address | number | Other | |
10gR1-10gR1 | waiting for low memory condition to be resolved | Idle | |||
10gR1-10gR1 | waiting for subscribers to catch up | Idle | |||
8i-12cR1 | waiting to get CAS latch | Other | |||
9i-12cR1 | waiting to get RM CAS latch | Other | |||
10gR1-10gR1 | wakeup blocked enqueuers | Other | |||
9i-10gR1 | wakeup event for builder | Idle | |||
9i-10gR1 | wakeup event for preparer | Idle | |||
9i-10gR1 | wakeup event for reader | Idle | |||
8i-10gR1 | wakeup time manager | Idle | |||
10gR2-19c | watchdog main loop | Idle | |||
8i-19c | write complete waits | file# | block# | Configuration | |
11gR2-19c | write complete waits: flash cache | file# | block# | Configuration | |
8i-19c | writes stopped by instance recovery or database suspension | by thread# | our thread# | Other | |
10gR2-19c | xdb schema cache initialization | Other |