It's here mostly for my easy lookup. As I had to start my sandbox twice (on a Sunday) to check some uncommon waits, this is worth for me.
| EVENT_ID | NAME | PARAMETER1 | PARAMETER2 | PARAMETER3 | WAIT CLASS | DISPLAY_NAME |
|---|---|---|---|---|---|---|
| 2516578839 | null event | Other | <- name | |||
| 3934444552 | logout restrictor | Concurrency | <- name | |||
| 939791390 | VKTM Logical Idle Wait | Idle | <- name | |||
| 1513856046 | VKTM Init Wait for GSGA | Idle | <- name | |||
| 1421578053 | IORM Scheduler Slave Idle Wait | Idle | <- name | |||
| 3767648750 | acknowledge over PGA limit | limit | margin | growth | Scheduler | <- name |
| 1179235204 | Parameter File I/O | blkno | #blks | read/write | User I/O | <- name |
| 866018717 | rdbms ipc message | timeout | Idle | <- name | ||
| 3222461937 | remote db operation | clientid | operation | timeout | Network | <- name |
| 2171045634 | remote db file read | clientid | count | intr | Network | <- name |
| 538064841 | remote db file write | clientid | count | intr | Network | <- name |
| 1867721841 | io done | msg ptr | System I/O | <- name | ||
| 4259433894 | i/o slave wait | msg ptr | Idle | <- name | ||
| 4120085931 | RMAN Disk slave I/O | wait count | wait flags | timeout | System I/O | <- name |
| 2828390964 | RMAN Tape slave I/O | tape operation | operation flags | timeout | System I/O | <- name |
| 3671110102 | DBWR slave I/O | wait count | wait flags | timeout | System I/O | <- name |
| 1180269184 | LGWR slave I/O | wait count | wait flags | timeout | System I/O | <- name |
| 1260687889 | Archiver slave I/O | wait count | wait flags | timeout | System I/O | <- name |
| 166678035 | Disk file operations I/O | FileOperation | fileno | filetype | User I/O | <- name |
| 2215689832 | Disk file I/O Calibration | count | User I/O | <- name | ||
| 13102552 | Disk file Mirror Read | fileno | blkno | filetype | User I/O | <- name |
| 2577606720 | Disk file Mirror/Media Repair Write | fileno | blkno | filetype | User I/O | <- name |
| 2093619153 | direct path sync | File number | Flags | User I/O | <- name | |
| 2006672057 | Clonedb bitmap file write | blkno | size | System I/O | <- name | |
| 4155572307 | Datapump dump file I/O | count | intr | timeout | User I/O | <- name |
| 1791724291 | dbms_file_transfer I/O | count | intr | timeout | User I/O | <- name |
| 432473858 | DG Broker configuration file I/O | count | intr | timeout | User I/O | <- name |
| 2326919048 | Data file init write | count | intr | timeout | User I/O | <- name |
| 3992632846 | Log file init write | count | intr | timeout | User I/O | <- name |
| 2089793129 | Log archive I/O | count | intr | timeout | System I/O | <- name |
| 3107297351 | RMAN backup & recovery I/O | count | intr | timeout | System I/O | <- name |
| 2431534215 | RMAN lost write reread | count | intr | timeout | System I/O | <- name |
| 3511162007 | Standby redo I/O | count | intr | timeout | System I/O | <- name |
| 2907891391 | Network file transfer | count | intr | timeout | System I/O | <- name |
| 171909448 | Pluggable Database file copy | count | intr | timeout | User I/O | <- name |
| 4053220855 | File Copy | count | intr | timeout | User I/O | <- name |
| 708427085 | Backup: MML initialization | Administrative | <- name | |||
| 90799346 | Backup: MML v1 open backup piece | Administrative | <- name | |||
| 1699816995 | Backup: MML v1 read backup piece | Administrative | <- name | |||
| 2733564901 | Backup: MML v1 write backup piece | Administrative | <- name | |||
| 3963262976 | Backup: MML v1 close backup piece | Administrative | <- name | |||
| 4157057748 | Backup: MML v1 query backup piece | Administrative | <- name | |||
| 4019590666 | Backup: MML v1 delete backup piece | Administrative | <- name | |||
| 1895924988 | Backup: MML create a backup piece | Administrative | <- name | |||
| 3051341818 | Backup: MML commit backup piece | Administrative | <- name | |||
| 3102084144 | Backup: MML command to channel | Administrative | <- name | |||
| 2388692075 | Backup: MML shutdown | Administrative | <- name | |||
| 1926582779 | Backup: MML obtain textual error | Administrative | <- name | |||
| 2632503569 | Backup: MML query backup piece | Administrative | <- name | |||
| 2690859083 | Backup: MML extended initialization | Administrative | <- name | |||
| 1533823139 | Backup: MML read backup piece | Administrative | <- name | |||
| 2524600641 | Backup: MML delete backup piece | Administrative | <- name | |||
| 2275421618 | Backup: MML restore backup piece | Administrative | <- name | |||
| 3388241768 | Backup: MML write backup piece | Administrative | <- name | |||
| 3815526880 | Backup: MML proxy initialize backup | Administrative | <- name | |||
| 2642609849 | Backup: MML proxy cancel | Administrative | <- name | |||
| 2960327623 | Backup: MML proxy commit backup piece | Administrative | <- name | |||
| 1156967028 | Backup: MML proxy session end | Administrative | <- name | |||
| 583062335 | Backup: MML datafile proxy backup? | Administrative | <- name | |||
| 3346425666 | Backup: MML datafile proxy restore? | Administrative | <- name | |||
| 585335785 | Backup: MML proxy initialize restore | Administrative | <- name | |||
| 2701284369 | Backup: MML proxy start data movement | Administrative | <- name | |||
| 216701082 | Backup: MML data movement done? | Administrative | <- name | |||
| 4278597786 | Backup: MML proxy prepare to start | Administrative | <- name | |||
| 2139086251 | Backup: MML obtain a direct buffer | Administrative | <- name | |||
| 2070697616 | Backup: MML release a direct buffer | Administrative | <- name | |||
| 531815827 | Backup: MML get base address | Administrative | <- name | |||
| 3181276243 | Backup: MML query for direct buffers | Administrative | <- name | |||
| 3421583815 | OFS Receive Queue | Idle | <- name | |||
| 303766224 | OFS operation completion | Administrative | <- name | |||
| 1048659203 | OFS idle | Idle | <- name | |||
| 58311103 | VKRM Idle | Idle | <- name | |||
| 1601747446 | resmgr: redo throttle | Scheduler | <- name | |||
| 218649935 | wait for unread message on broadcast channel | channel context | channel handle | Idle | <- name | |
| 3224768590 | wait for unread message on multiple broadcast channels | channel context | channel handle count | Idle | <- name | |
| 1055154682 | class slave wait | slave id | Idle | <- name | ||
| 739096548 | RMA: IPC0 completion sync | send count | Idle | <- name | ||
| 2966135248 | IPC group service call | function id | Network | <- name | ||
| 900394413 | PING | Idle | <- name | |||
| 1668213210 | Service operation completion | Cluster | <- name | |||
| 3615400802 | service monitor: inst recovery completion | Cluster | <- name | |||
| 2748706322 | watchdog main loop | Idle | <- name | |||
| 3939514704 | process in prespawned state | Idle | <- name | |||
| 2656070573 | BA: Performance API | Administrative | <- name | |||
| 565450542 | File Repopulation Write | filename_hash | blkno | System I/O | <- name | |
| 3539483025 | pmon timer | duration | Idle | <- name | ||
| 635602798 | pman timer | Idle | <- name | |||
| 1233153647 | latch: MGA shared context root latch | address | number | why | Concurrency | <- name |
| 2598281784 | latch: MGA shared context latch | address | number | why | Concurrency | <- name |
| 500901621 | latch: MGA heap latch | address | number | why | Concurrency | <- name |
| 975995734 | latch: MGA pid alloc latch | address | number | why | Concurrency | <- name |
| 4082766567 | latch: MGA asr alloc latch | address | number | why | Concurrency | <- name |
| 1275333778 | DNFS disp IO slave idle | Idle | <- name | |||
| 3176176482 | DIAG idle wait | component | where | wait time(millisec) | Idle | <- name |
| 317011907 | ges remote message | waittime | loop | p3 | Idle | <- name |
| 2269002043 | enq: RI - Reader Farm SQL Isolation | name|mode | 0 | 0 | Concurrency | <- name |
| 338940857 | SCM slave idle | Idle | <- name | |||
| 3416399148 | LMS CR slave timer | type | Idle | <- name | ||
| 2910564005 | gcs remote message | waittime | poll | event | Idle | <- name |
| 332747553 | gcs yield cpu | Idle | <- name | |||
| 2619295687 | heartbeat monitor sleep | Idle | <- name | |||
| 341609523 | GCR sleep | Idle | <- name | |||
| 3650619114 | PBR logfile IO | File ID | blk | nbytes | System I/O | <- name |
| 1197131876 | PBR logfile block write | File ID | blk | pbridx | System I/O | <- name |
| 1989349184 | SGA: MMAN sleep for component shrink | component id | current size | target size | Idle | <- name |
| 863929674 | retry contact SCN lock master | Cluster | <- name | |||
| 3213517201 | control file sequential read | file# | block# | blocks | System I/O | control file read |
| 2383414886 | control file single write | file# | block# | blocks | System I/O | control file write |
| 4078387448 | control file parallel write | files | block# | requests | System I/O | <- name |
| 2365673131 | control file backup creation | Administrative | <- name | |||
| 2970185817 | Shared IO Pool Memory | Concurrency | <- name | |||
| 1959037329 | Shared IO Pool IO Completion | User I/O | <- name | |||
| 3141712284 | enq: PW - flush prewarm buffers | name|mode | 0 | 0 | Application | <- name |
| 2779959231 | latch: cache buffers chains | address | number | why | Concurrency | <- name |
| 2701153470 | free buffer waits | file# | block# | set-id# | Configuration | <- name |
| 1570123276 | local write wait | file# | block# | User I/O | <- name | |
| 1181827162 | checkpoint completed | Configuration | <- name | |||
| 4229542060 | write complete waits | file# | block# | Configuration | <- name | |
| 2451603592 | write complete waits: flash cache | file# | block# | Configuration | <- name | |
| 3761122497 | buffer read retry | file# | block# | User I/O | <- name | |
| 2161531084 | buffer busy waits | file# | block# | class# | Concurrency | <- name |
| 1912606394 | gc buffer busy acquire | file# | block# | class# | Cluster | <- name |
| 105117041 | gc buffer busy release | file# | block# | class# | Cluster | <- name |
| 3056446529 | read by other session | file# | block# | class# | User I/O | <- name |
| 1176352510 | multiple dbwriter suspend/resume for file offline | Administrative | <- name | |||
| 765902655 | recovery read | System I/O | <- name | |||
| 1387386639 | pi renounce write complete | file# | block# | Cluster | <- name | |
| 1963118444 | db flash cache single block physical read | User I/O | <- name | |||
| 2070455916 | db flash cache multiblock physical read | User I/O | <- name | |||
| 1153916164 | db flash cache write | User I/O | <- name | |||
| 1055954476 | db flash cache invalidate wait | file# | block# | Concurrency | <- name | |
| 1847602198 | db flash cache dynamic disabling wait | Administrative | <- name | |||
| 23293667 | remote log force - commit | thread# | thread scn | session scn | Commit | <- name |
| 2057720172 | remote log force - buffer update | file# | block# | class# | Cluster | <- name |
| 1073104909 | remote log force - buffer read | file# | block# | class# | Cluster | <- name |
| 2849107610 | remote log force - SCN range | file# | block# | class# | Cluster | <- name |
| 3387973199 | remote log force - session cleanout | thread# | thread scn | session scn | Cluster | <- name |
| 427932892 | DBWR timer | Idle | <- name | |||
| 3500532018 | enq: RO - contention | name|mode | 2 | 0 | Application | <- name |
| 143262751 | enq: RO - fast object reuse | name|mode | 2 | 0 | Application | <- name |
| 4205197519 | enq: KO - fast object checkpoint | name|mode | 2 | 0 | Application | <- name |
| 1198921735 | Data Guard network buffer stall reap | Network | <- name | |||
| 2369083111 | Data Guard: Gap Manager | Idle | <- name | |||
| 3183521032 | Data Guard: controlfile update | Idle | <- name | |||
| 1460436880 | MRP redo arrival | Idle | <- name | |||
| 3134783330 | RFS sequential i/o | System I/O | <- name | |||
| 3089862638 | RFS random i/o | System I/O | <- name | |||
| 2009048728 | RFS write | System I/O | <- name | |||
| 1799268421 | Data Guard: Timer | Idle | <- name | |||
| 1959287235 | ARCH wait for net re-connect | Network | <- name | |||
| 4051103488 | ARCH wait for netserver start | Network | <- name | |||
| 1304409668 | LNS wait on LGWR | Network | <- name | |||
| 2949988816 | LGWR wait on LNS | Network | <- name | |||
| 406979416 | ARCH wait for netserver init 2 | Network | <- name | |||
| 3411133732 | ARCH wait for flow-control | Network | <- name | |||
| 2731366464 | ARCH wait for netserver detach | Network | <- name | |||
| 2836458162 | LNS ASYNC archive log | Idle | <- name | |||
| 3599169768 | LNS ASYNC dest activation | Idle | <- name | |||
| 3378470826 | LNS ASYNC end of log | Idle | <- name | |||
| 549236675 | log file sequential read | log# | block# | blocks | System I/O | log file multiblock read |
| 215477332 | log file single write | log# | block# | blocks | System I/O | log file header write |
| 3999721902 | log file parallel write | files | blocks | requests | System I/O | log file redo write |
| 400279894 | log file pmem persist write | thread | group | member | System I/O | <- name |
| 2650776430 | log file pmem persist read | thread | group | member | System I/O | <- name |
| 2539661515 | latch: redo writing | address | number | why | Configuration | <- name |
| 2107275157 | latch: redo copy | address | number | why | Configuration | <- name |
| 3357856061 | log buffer space | Configuration | log buffer full - LGWR bottleneck |
|||
| 2867289651 | log file switch (checkpoint incomplete) | Configuration | <- name | |||
| 114164561 | log file switch (private strand flush incomplete) | Configuration | <- name | |||
| 681532028 | log file switch (archiving needed) | Configuration | <- name | |||
| 3845123846 | switch logfile command | Administrative | <- name | |||
| 3834950329 | log file switch completion | Configuration | <- name | |||
| 1328744198 | log file sync | buffer# | sync scn | Commit | commit: log file sync | |
| 1243695914 | log file sync: SCN ordering | buffer# | sync scn | Concurrency | <- name | |
| 2915106572 | simulated log write delay | Idle | <- name | |||
| 4233989021 | heartbeat redo informer | Idle | <- name | |||
| 1278638045 | LGWR real time apply sync | Idle | standby apply advance notification |
|||
| 91842589 | LGWR worker group idle | group_id | slave_id | Idle | <- name | |
| 159901149 | remote log force - log switch/recovery | thread# | thread SCN | force SCN | Cluster | <- name |
| 2652584166 | db file sequential read | file# | block# | blocks | User I/O | db single block read |
| 506183215 | db file scattered read | file# | block# | blocks | User I/O | db multiblock read |
| 1307477558 | db file single write | file# | block# | blocks | User I/O | db single block write |
| 1620694733 | db file parallel write | requests | interrupt | timeout | System I/O | db list of blocks write |
| 133155944 | db file async I/O submit | requests | interrupt | timeout | System I/O | <- name |
| 834992820 | db file parallel read | files | blocks | requests | User I/O | db list of blocks read |
| 1567037747 | enq: MV - datafile move | name|mode | type | file # | Administrative | <- name |
| 3905407295 | gc current request | file# | block# | id# | Cluster | <- name |
| 512320954 | gc cr request | file# | block# | class# | Cluster | <- name |
| 1136317622 | gc cr disk request | file# | block# | class# | Cluster | <- name |
| 661121159 | gc cr multi block request | file# | block# | class# | Cluster | <- name |
| 2272899030 | gc cr multi block mixed | Cluster | <- name | |||
| 2774151265 | gc cr multi block grant | Cluster | <- name | |||
| 3897775868 | gc current multi block request | file# | block# | id# | Cluster | <- name |
| 1627043053 | gc block recovery request | file# | block# | class# | Cluster | <- name |
| 310416032 | gc imc multi block request | file# | block# | Cluster | <- name | |
| 2628845780 | gc imc multi block quiesce | file# | block# | Cluster | <- name | |
| 3035277123 | gc cr block remote read | file# | block# | class# | Cluster | <- name |
| 737661873 | gc cr block 2-way | Cluster | <- name | |||
| 3046984244 | gc cr block 3-way | Cluster | <- name | |||
| 1520064534 | gc cr block busy | Cluster | <- name | |||
| 2705335821 | gc cr block congested | Cluster | <- name | |||
| 2375802695 | gc cr failure | Cluster | <- name | |||
| 3151901526 | gc cr block lost | Cluster | <- name | |||
| 111015833 | gc current block 2-way | Cluster | <- name | |||
| 3570184881 | gc current block 3-way | Cluster | <- name | |||
| 2701629120 | gc current block busy | Cluster | <- name | |||
| 3785617759 | gc current block congested | Cluster | <- name | |||
| 1742950045 | gc current retry | Cluster | <- name | |||
| 957917679 | gc current block lost | Cluster | <- name | |||
| 1457266432 | gc current split | Cluster | <- name | |||
| 3201690383 | gc cr grant 2-way | Cluster | <- name | |||
| 3666253819 | gc cr grant 3-way | Cluster | <- name | |||
| 3261528052 | gc cr grant busy | Cluster | <- name | |||
| 3794703642 | gc cr grant congested | Cluster | <- name | |||
| 1445598276 | gc cr disk read | Cluster | <- name | |||
| 690277170 | gc cr grant ka | Cluster | <- name | |||
| 1341316678 | gc cr grant cluster flash cache read | Cluster | <- name | |||
| 3015759224 | gc cr cluster flash cache read | Cluster | <- name | |||
| 1236598300 | gc cr flash cache copy | Cluster | <- name | |||
| 3609908235 | gc cr grant read-mostly invalidation | Cluster | <- name | |||
| 1577027000 | gc cr grant read-only instance invalidation | Cluster | <- name | |||
| 2685450749 | gc current grant 2-way | Cluster | <- name | |||
| 1094886395 | gc current grant 3-way | Cluster | <- name | |||
| 2277737081 | gc current grant busy | Cluster | <- name | |||
| 667696377 | gc current grant congested | Cluster | <- name | |||
| 4071646426 | gc current grant ka | Cluster | <- name | |||
| 1301716097 | gc current grant cluster flash cache read | Cluster | <- name | |||
| 1116778291 | gc current grant read-mostly invalidation | Cluster | <- name | |||
| 2183032747 | gc current grant read-only instance invalidation | Cluster | <- name | |||
| 1188530765 | gc transaction table | count | Cluster | <- name | ||
| 4185841437 | gc index operation | usn# | slot# | seq# | Cluster | <- name |
| 297486966 | gc freelist | Cluster | <- name | |||
| 75296820 | gc remaster | file# | block# | class# | Cluster | <- name |
| 758475196 | gc quiesce | Cluster | <- name | |||
| 3612069565 | gc recovery | Cluster | <- name | |||
| 3726007083 | gc flushed buffer | Cluster | <- name | |||
| 3708514396 | gc send complete | Cluster | <- name | |||
| 3415121734 | gc current cancel | le | Cluster | <- name | ||
| 3289120169 | gc cr cancel | le | Cluster | <- name | ||
| 2369255784 | gc assume | le | Cluster | <- name | ||
| 3893928311 | gc current index split | le | Cluster | <- name | ||
| 3571931909 | gc domain validation | file# | block# | class# | Cluster | <- name |
| 2961011386 | gc recovery free | Cluster | <- name | |||
| 3106959643 | gc recovery quiesce | file# | block# | class# | Cluster | <- name |
| 830518988 | gc claim | file# | block# | class# | Cluster | <- name |
| 3723089570 | gc cancel retry | Cluster | <- name | |||
| 3926164927 | direct path read | file number | first dba | block cnt | User I/O | <- name |
| 861319509 | direct path read temp | file number | first dba | block cnt | User I/O | <- name |
| 885859547 | direct path write | file number | first dba | block cnt | User I/O | <- name |
| 38438084 | direct path write temp | file number | first dba | block cnt | User I/O | <- name |
| 428700550 | datafile pre-create | Administrative | <- name | |||
| 2328740855 | parallel recovery slave idle wait | Idle | <- name | |||
| 3230901260 | Backup Appliance waiting for work | session_id | serial | Idle | <- name | |
| 1629412133 | Backup Appliance waiting restore start | session_id | serial | Idle | <- name | |
| 1911215282 | Backup Appliance Surrogate wait | session_id | serial | Idle | <- name | |
| 3411526999 | Backup Appliance Servlet wait | session_id | serial | Idle | <- name | |
| 614344865 | Backup Appliance Comm SGA setup wait | session_id | serial | Idle | <- name | |
| 1221077576 | LogMiner builder: idle | Session ID | Idle | <- name | ||
| 2130278899 | LogMiner builder: memory | Session ID | Queueing | <- name | ||
| 3993953808 | LogMiner builder: DDL | Session ID | Queueing | <- name | ||
| 3650510895 | LogMiner builder: branch | Session ID | Idle | <- name | ||
| 37490450 | LogMiner preparer: idle | Session ID | Idle | <- name | ||
| 4176490272 | LogMiner preparer: memory | Session ID | Queueing | <- name | ||
| 2969107883 | LogMiner reader: buffer | Session ID | Queueing | <- name | ||
| 3314391977 | LogMiner reader: log (idle) | Session ID | Thread | Sequence | Idle | <- name |
| 1534896503 | LogMiner reader: redo (idle) | Session ID | Thread | Sequence | Idle | <- name |
| 3214539112 | LogMiner merger: idle | Session ID | Thread | Idle | <- name | |
| 2858596797 | LogMiner client: transaction | Session ID | Idle | <- name | ||
| 3893525907 | LogMiner: other | Session ID | Idle | <- name | ||
| 3685504676 | LogMiner: activate | Session ID | Idle | <- name | ||
| 3979031729 | LogMiner: reset | Caller ID | Idle | <- name | ||
| 2694966712 | LogMiner: find session | Session ID | Idle | <- name | ||
| 2989610564 | LogMiner: internal | Caller ID | Idle | <- name | ||
| 226544737 | Logical Standby Apply Delay | Idle | <- name | |||
| 3525876136 | wait for possible quiesce finish | Administrative | quiesce database completion |
|||
| 2842195073 | parallel recovery coordinator waits for slave cleanup | Idle | <- name | |||
| 3487232407 | flashback log file write | log# | block# | Bytes | System I/O | <- name |
| 2769438501 | flashback log file read | log# | block# | Bytes | System I/O | <- name |
| 1760381182 | flashback buf free by RVWR | Configuration | <- name | |||
| 157547587 | flashback log file sync | User I/O | <- name | |||
| 2032998565 | parallel recovery coordinator idle wait | Idle | <- name | |||
| 722766223 | parallel recovery control message reply | Idle | <- name | |||
| 2314562763 | cell smart table scan | cellhash# | User I/O | <- name | ||
| 601047792 | cell smart index scan | cellhash# | User I/O | <- name | ||
| 186581379 | cell external table smart scan | cellhash# | User I/O | <- name | ||
| 447002770 | cell statistics gather | cellhash# | User I/O | <- name | ||
| 2705202413 | cell smart incremental backup | cellhash# | System I/O | <- name | ||
| 2569366771 | cell smart file creation | cellhash# | User I/O | <- name | ||
| 3260626027 | cell smart restore from backup | cellhash# | System I/O | <- name | ||
| 572448743 | parallel recovery slave next change | Idle | <- name | |||
| 4031319789 | concurrent I/O completion | Administrative | online move datafile IO completion |
|||
| 1845020027 | datafile copy range completion | Administrative | online move datafile copy range completion |
|||
| 1226277798 | nologging fetch slave idle | Idle | <- name | |||
| 445146538 | Nologging standby progress | Primary client SCN | Max wait in centi-seconds | Commit | <- name | |
| 354850594 | nologging standby txn commit | Commit | <- name | |||
| 2506001814 | nologging range consumption list | Configuration | <- name | |||
| 3669067250 | recovery sender idle | Idle | <- name | |||
| 1872203966 | recovery receiver idle | Idle | <- name | |||
| 3286605538 | recovery coordinator idle | Idle | <- name | |||
| 3619482101 | recovery logmerger idle | Idle | <- name | |||
| 4138829642 | block compare coord process idle | Idle | <- name | |||
| 668627480 | enq: TM - contention | name|mode | object # | table/partition | Application | <- name |
| 1649608974 | enq: ST - contention | name|mode | 0 | 0 | Configuration | <- name |
| 1781586680 | undo segment extension | segment# | Configuration | <- name | ||
| 2539132690 | undo segment tx slot | segment# | Configuration | <- name | ||
| 1107691084 | switch undo - offline | Administrative | <- name | |||
| 1005272400 | alter rbs offline | Administrative | <- name | |||
| 310662678 | enq: TX - row lock contention | name|mode | usn<<16 | slot | sequence | Application | <- name |
| 281768874 | enq: TX - allocate ITL entry | name|mode | usn<<16 | slot | sequence | Configuration | <- name |
| 1035026728 | enq: TX - index contention | name|mode | usn<<16 | slot | sequence | Concurrency | <- name |
| 1435178951 | enq: TW - contention | name|mode | 0 | operation | Administrative | <- name |
| 1817260038 | PX Deq: Txn Recovery Start | sleeptime/senderid | passes | Idle | <- name | |
| 1029371363 | PX Deq: Txn Recovery Reply | sleeptime/senderid | passes | Idle | <- name | |
| 1574097577 | latch: Undo Hint Latch | address | number | why | Concurrency | <- name |
| 680822103 | statement suspended, wait error to be cleared | Configuration | <- name | |||
| 1394127552 | latch: In memory undo latch | address | number | why | Concurrency | <- name |
| 1286443595 | latch: MQL Tracking Latch | address | number | why | Concurrency | <- name |
| 2729944181 | fbar timer | sleep time | failed | Idle | <- name | |
| 1832903562 | Archive Manager file transfer I/O | count | intr | timeout | User I/O | <- name |
| 3886663633 | SecureFile log buffer | Configuration | <- name | |||
| 822361323 | IM buffer busy | Concurrency | <- name | |||
| 2468447540 | IM buffer busy TXN | Concurrency | <- name | |||
| 3258151131 | IM buffer busy SHR | Concurrency | <- name | |||
| 1606606310 | securefile chain update | seghdr | fsb | Concurrency | <- name | |
| 1645217925 | enq: HW - contention | name|mode | table space # | block | Configuration | <- name |
| 206780098 | enq: BE - Critical Block Allocation | name|mode | tablespace# | block# | Concurrency | <- name |
| 3890744969 | enq: SS - contention | name|mode | tablespace # | dba | Configuration | <- name |
| 2672479943 | sort segment request | Configuration | <- name | |||
| 1403232821 | smon timer | sleep time | failed | Idle | <- name | |
| 3431783400 | PX Deq: Metadata Update | ktelc_wait1s | Idle | <- name | ||
| 2942611488 | Space Manager: slave idle wait | Slave ID | Idle | <- name | ||
| 2322460838 | enq: SQ - contention | name|mode | object # | 0 | Configuration | <- name |
| 818518977 | enq: SV - contention | type|mode | id1 | id2 | Configuration | <- name |
| 2288901790 | PX Deq: Index Merge Reply | sleeptime/senderid | passes | Idle | <- name | |
| 2881101577 | PX Deq: Index Merge Execute | sleeptime/senderid | passes | Idle | <- name | |
| 259094851 | PX Deq: Index Merge Close | sleeptime/senderid | passes | Idle | <- name | |
| 2908893972 | enq: HV - contention | name|mode | object # | 0 | Concurrency | <- name |
| 1775596922 | PX Deq: kdcph_mai | kdcph_mai | Idle | <- name | ||
| 3388026088 | PX Deq: kdcphc_ack | kdcphc_ack | Idle | <- name | ||
| 3311157317 | index (re)build online start | object | mode | wait | Administrative | <- name |
| 3507172204 | index (re)build online cleanup | object | mode | wait | Administrative | <- name |
| 459595925 | index (re)build online merge | object | mode | wait | Administrative | <- name |
| 3347698104 | index (re)build lock or pin object | namespace | lock_mode | pin_mode | Administrative | <- name |
| 3999678875 | securefile direct-read completion | User I/O | <- name | |||
| 3535858375 | securefile direct-write completion | User I/O | <- name | |||
| 39333034 | SecureFile mutex | Concurrency | <- name | |||
| 122034066 | enq: WG - lock fso | name|mode | kdlw lobid first half | kdlw lobid sec half | Concurrency | <- name |
| 3185393509 | imco timer | sleep time | failed | Idle | <- name | |
| 542160597 | Inmemory Populate: get loadscn | Concurrency | <- name | |||
| 238930206 | IMFS defer writes scheduler | Idle | <- name | |||
| 1318477709 | memoptimize write buffer get | Configuration | <- name | |||
| 2299584621 | memoptimize write drain idle | Idle | <- name | |||
| 1117386924 | latch: row cache objects | address | number | why | Concurrency | <- name |
| 306610566 | row cache mutex | cache id | where requested | Concurrency | <- name | |
| 1714089451 | row cache lock | cache id | mode | request | Concurrency | <- name |
| 3733770256 | row cache read | cache id | Concurrency | <- name | ||
| 670556006 | libcache interrupt action by LCK | location | Concurrency | <- name | ||
| 2563317866 | enq: IV - cross instance invalidation | lock idx | Concurrency | <- name | ||
| 877525844 | cursor: mutex X | idn | value | where | Concurrency | <- name |
| 1575214430 | cursor: mutex S | idn | value | where | Concurrency | <- name |
| 3085815766 | cursor: pin X | idn | value | where | Concurrency | <- name |
| 352301881 | cursor: pin S | idn | value | where | Concurrency | <- name |
| 1729366244 | cursor: pin S wait on X | idn | value | where | Concurrency | <- name |
| 3015879322 | enq: CB - role operation | name|mode | 0 | 0 | Concurrency | <- name |
| 850477422 | Global transaction acquire instance locks | retries | Configuration | <- name | ||
| 3304404527 | enq: BB - 2PC across RAC instances | name|mode | gtrid hash value | bqual hash value | Commit | <- name |
| 2696347763 | latch: shared pool | address | number | why | Concurrency | <- name |
| 2142653731 | LCK0 row cache object free | heap ds | min_size | clatch | Concurrency | <- name |
| 2405459892 | Unpin a recreatable chunk | chunk addr | max attempt | attempted | Concurrency | <- name |
| 2802704141 | library cache pin | handle address | pin address | 100*mode+namespace | Concurrency | <- name |
| 916468430 | library cache lock | handle address | lock address | 100*mode+namespace | Concurrency | <- name |
| 2952162927 | library cache load lock | object address | lock address | 100*mask+namespace | Concurrency | <- name |
| 1646780882 | library cache: mutex X | idn | value | where | Concurrency | <- name |
| 2601513493 | library cache: bucket mutex X | idn | value | where | Concurrency | <- name |
| 2382371857 | library cache: dependency mutex X | idn | value | where | Concurrency | <- name |
| 2446268751 | library cache: mutex S | idn | value | where | Concurrency | <- name |
| 1241467722 | BFILE read | User I/O | <- name | |||
| 1452455426 | resmgr:cpu quantum | location | consumer group id | Scheduler | <- name | |
| 3911289767 | resmgr:large I/O queued | location | Scheduler | <- name | ||
| 2027842284 | resmgr: I/O rate limit | location | Scheduler | <- name | ||
| 4043670897 | resmgr:internal state change | location | Concurrency | <- name | ||
| 3942551365 | resmgr:sessions to exit | location | Concurrency | <- name | ||
| 1861259087 | resmgr:become active | location | Scheduler | <- name | ||
| 1724186970 | resmgr:pq queued | location | Scheduler | <- name | ||
| 3680756349 | TCP Socket (KGAS) | Network | <- name | |||
| 2804400934 | utl_file I/O | User I/O | <- name | |||
| 639905136 | DNFS disp IO slave completion | pnum | User I/O | <- name | ||
| 4219255068 | alter system set dispatcher | waited | Administrative | <- name | ||
| 2900469894 | virtual circuit wait | circuit# | type | Network | <- name | |
| 1091942974 | virtual circuit next request | circuit# | type | Idle | <- name | |
| 1786390478 | shared server idle wait | Idle | <- name | |||
| 4090013609 | dispatcher timer | sleep time | Idle | <- name | ||
| 4195517431 | dispatcher listen timer | sleep time | Network | <- name | ||
| 660387499 | dedicated server timer | wait event | Network | <- name | ||
| 963656759 | cmon timer | sleep time | Idle | <- name | ||
| 3775760766 | pool server timer | sleep time | Idle | <- name | ||
| 1524501944 | connection pool wait | op | num procs | Administrative | <- name | |
| 604512360 | connection broker handoff | connection broker | connection | op | Network | <- name |
| 3113908805 | lreg timer | succ | wait | fail | Idle | <- name |
| 2173075130 | JOX Jit Process Sleep | Idle | <- name | |||
| 782339817 | jobq slave wait | Idle | <- name | |||
| 775793103 | Wait for Table Lock | Application | <- name | |||
| 160773985 | pipe get | handle address | buffer length | timeout | Idle | <- name |
| 3479211658 | pipe put | handle address | record length | timeout | Concurrency | <- name |
| 3835660459 | enq: DB - contention | name|mode | EnqMode | 0 | Administrative | <- name |
| 961027629 | PX Deque wait | sleeptime/senderid | passes | Idle | <- name | |
| 3382828453 | PX Idle Wait | sleeptime/senderid | passes | Idle | <- name | |
| 2267953574 | PX Deq Credit: need buffer | sleeptime/senderid | passes | qref | Idle | <- name |
| 2610814049 | PX Deq Credit: send blkd | sleeptime/senderid | passes | qref | Idle | <- name |
| 77145095 | PX Deq: Msg Fragment | sleeptime/senderid | passes | Idle | <- name | |
| 4255662421 | PX Deq: Parse Reply | sleeptime/senderid | passes | Idle | <- name | |
| 2599037852 | PX Deq: Execute Reply | sleeptime/senderid | passes | Idle | <- name | |
| 98582416 | PX Deq: Execution Msg | sleeptime/senderid | passes | Idle | <- name | |
| 799271425 | PX Deq: Table Q Normal | sleeptime/senderid | passes | Idle | <- name | |
| 1062854067 | PX Deq: Table Q Sample | sleeptime/senderid | passes | Idle | <- name | |
| 3600835498 | enq: TG - IMCDT global resource | name|mode | container id # | 0 | Concurrency | <- name |
| 4196504577 | enq: TI - IMCDT object HT | name|mode | query exec id # | qc session id # | Concurrency | <- name |
| 1850448852 | external table read | filectx | file# | size | User I/O | <- name |
| 2573156426 | external table write | filectx | file# | size | User I/O | <- name |
| 332943844 | external table open | filectx | file# | User I/O | <- name | |
| 2580575859 | external table seek | filectx | file# | pos | User I/O | <- name |
| 4284613698 | external table misc IO | filectx | iocode | P3 | User I/O | <- name |
| 2649722911 | enq: RC - Result Cache: Contention | name|mode | chunkNo | blockNo | Application | <- name |
| 3225147589 | result cache lock wait | object no | Concurrency | <- name | ||
| 1636695715 | enq: JX - SQL statement queue | name|mode | sqlid | execid | Scheduler | <- name |
| 3822543692 | enq: JX - cleanup of queue | name|mode | sqlid | execid | Scheduler | <- name |
| 3419368467 | PX Queuing: statement queue | sleeptime | passes | Scheduler | <- name | |
| 3042070696 | enq: KV - IMA key vector access | name|mode | node#+sess#, cursor#+kv# |
kv # | Concurrency | <- name |
| 892389094 | dbverify reads | count | intr | timeout | User I/O | <- name |
| 938380620 | REPL Apply: txns | Idle | <- name | |||
| 463459266 | REPL Capture: subscribers to catch up | 2=>GoldenGate 1=>XStream 0=>Streams | TYPE | Queueing | <- name | |
| 249067227 | REPL Capture/Apply: memory | 2=>GoldenGate 1=>XStream 0=>Streams |
Queueing | <- name | ||
| 188497226 | REPL Apply: commit | 2=>GoldenGate 1=>XStream 0=>Streams |
Configuration | <- name | ||
| 2757875356 | REPL Apply: dependency | 2=>GoldenGate 1=>XStream 0=>Streams |
Concurrency | <- name | ||
| 2524336375 | REPL Capture/Apply: flow control | 2=>GoldenGate 1=>XStream 0=>Streams |
Queueing | <- name | ||
| 3941979276 | REPL Capture/Apply: messages | 2=>GoldenGate 1=>XStream 0=>Streams |
Idle | <- name | ||
| 1684328492 | REPL Capture: archive log | 2=>GoldenGate 1=>XStream 0=>Streams |
TYPE | Idle | <- name | |
| 1421698562 | REPL Capture: filter callback ruleset | 2=>GoldenGate 1=>XStream 0=>Streams |
Application | <- name | ||
| 2362278079 | REPL Apply: apply DDL | 2=>GoldenGate 1=>XStream 0=>Streams |
sleep time | Application | <- name | |
| 845337552 | enq: ZG - contention | name|mode | file group id | version id | Administrative | <- name |
| 2254800293 | single-task message | Idle | <- name | |||
| 2067390145 | SQL*Net message to client | driver id | #bytes | Network | <- name | |
| 3655533736 | SQL*Net message to dblink | driver id | #bytes | Network | <- name | |
| 554161347 | SQL*Net more data to client | driver id | #bytes | Network | <- name | |
| 1958556342 | SQL*Net more data to dblink | driver id | #bytes | Network | <- name | |
| 1421975091 | SQL*Net message from client | driver id | #bytes | Idle | <- name | |
| 3530226808 | SQL*Net more data from client | driver id | #bytes | Network | <- name | |
| 4093028837 | SQL*Net message from dblink | driver id | #bytes | Network | <- name | |
| 1136294303 | SQL*Net more data from dblink | driver id | #bytes | Network | <- name | |
| 483818214 | SQL*Net vector message from client | driver id | #bytes | Idle | <- name | |
| 599122182 | SQL*Net vector message from dblink | driver id | #bytes | Idle | <- name | |
| 3957226286 | SQL*Net vector data to client | driver id | #bytes | Network | <- name | |
| 524447658 | SQL*Net vector data from client | driver id | #bytes | Network | <- name | |
| 380483207 | SQL*Net vector data to dblink | driver id | #bytes | Network | <- name | |
| 1970154257 | SQL*Net vector data from dblink | driver id | #bytes | Network | <- name | |
| 1963888671 | SQL*Net break/reset to client | driver id | break? | Application | <- name | |
| 634664853 | SQL*Net break/reset to dblink | driver id | break? | Application | <- name | |
| 3879957351 | External Procedure initial connection | Application | <- name | |||
| 1909653202 | External Procedure call | HS_SESSION_ID | Application | <- name | ||
| 818280116 | PL/SQL lock timer | duration | Idle | <- name | ||
| 1564641971 | wait for EMON to process ntfns | Configuration | <- name | |||
| 1053768773 | Streams AQ: emn coordinator idle wait | Idle | <- name | |||
| 1034167112 | EMON slave idle wait | Idle | <- name | |||
| 2249606771 | Emon coordinator main loop | Idle | <- name | |||
| 928709037 | Emon slave main loop | Idle | <- name | |||
| 738183602 | enq: UL - contention | name|mode | id | 0 | Application | <- name |
| 3955192389 | Streams AQ: waiting for messages in the queue | queue id | process# | wait time | Idle | <- name |
| 3702640206 | Streams AQ: waiting for time management or cleanup tasks | Idle | <- name | |||
| 2461999423 | Streams AQ: enqueue blocked on low memory | Queueing | <- name | |||
| 764740284 | Streams AQ: enqueue blocked due to flow control | Queueing | <- name | |||
| 1755736138 | Streams AQ: delete acknowledged messages | Idle | <- name | |||
| 1133197228 | Streams AQ: deallocate messages from Streams Pool | Idle | <- name | |||
| 989870553 | Streams AQ: qmn coordinator idle wait | Idle | <- name | |||
| 1830121438 | Streams AQ: qmn slave idle wait | Type | Idle | <- name | ||
| 3888265502 | AQ: 12c message cache init wait | Idle | <- name | |||
| 3013878596 | AQ Cross Master idle | Idle | <- name | |||
| 3367618326 | AQPC idle | Idle | <- name | |||
| 1646312927 | Streams AQ: load balancer idle | Idle | <- name | |||
| 1402142990 | Sharded Queues : Part Maintenance idle | Idle | <- name | |||
| 759460378 | Sharded Queues : Part Truncate idle | Idle | <- name | |||
| 3846605265 | REPL Capture/Apply: RAC AQ qmn coordinator | 1=>MASTER 2=>SLAVE |
Idle | <- name | ||
| 2874621763 | Streams AQ: opt idle | 1=>SLAVE0 2=>SLAVE1 3=>SLAVE2 4=>SLAVE3 5=>MASTER |
Idle | <- name | ||
| 255548015 | HS message to agent | Idle | <- name | |||
| 2904668353 | TEXT: URL_DATASTORE network wait | Network | <- name | |||
| 1267930770 | TEXT: File System I/O | User I/O | <- name | |||
| 867069076 | OLAP DML Sleep | duration | Application | <- name | ||
| 2908122354 | Cube Build Master Wait for Jobs | Concurrency | <- name | |||
| 604179256 | ASM sync cache disk read | group | obj | block | User I/O | <- name |
| 178886535 | ASM sync relocation I/O | count | where | file | System I/O | <- name |
| 1271689928 | ASM async relocation I/O | count | where | file | System I/O | <- name |
| 1049283008 | ASM COD rollback operation completion | dismount force | Administrative | <- name | ||
| 1568594048 | kfk: async disk IO | count | where | timeout | System I/O | <- name |
| 3288045901 | ASM IO for non-blocking poll | count | where | timeout | User I/O | <- name |
| 3423355190 | ASM remote SQL | Network | <- name | |||
| 2042354203 | ASM background timer | Idle | <- name | |||
| 2317972841 | ASM cluster membership changes | Idle | <- name | |||
| 1835713968 | iowp io | count | intr | timeout | System I/O | <- name |
| 1931000598 | iowp msg | iowp id | Idle | <- name | ||
| 2213525889 | iowp file id | iowp id | Idle | <- name | ||
| 3936513851 | netp network | netp id | Idle | <- name | ||
| 3193337724 | gopp msg | gopp id | Idle | <- name | ||
| 3800093324 | ASM Fixed Package I/O | blkno | bytes | filetype | User I/O | <- name |
| 1299431751 | ASM mount : wait for heartbeat | Administrative | <- name | |||
| 2619540468 | ASM PST query : wait for [PM][grp][0] grant | Cluster | <- name | |||
| 3491398912 | lock remastering | Cluster | <- name | |||
| 3166130 | ASM Staleness File I/O | blkno | #blks | diskno | User I/O | <- name |
| 769429583 | ASM File Group Sync | op | gn | pdbid | User I/O | <- name |
| 3066824253 | auto-sqltune: wait graph update | Idle | <- name | |||
| 277762365 | WCR: replay client notify | who am I | Idle | <- name | ||
| 1481930431 | WCR: replay clock | wait for scn's hi 4 bytes |
wait for scn's lo 4 bytes |
schedule capture ID | Idle | <- name |
| 3833657348 | WCR: replay lock order | wait for scn's hi 4 bytes |
wait for scn's lo 4 bytes |
Application | <- name | |
| 4280671222 | WCR: replay paused | Idle | <- name | |||
| 1955925289 | JS kgl get object wait | Administrative | <- name | |||
| 1045742593 | JS external job | Idle | <- name | |||
| 1371173112 | JS kill job wait | Administrative | <- name | |||
| 2190647165 | JS coord start wait | Administrative | <- name | |||
| 2614864156 | cell single block physical read | cellhash# | diskhash# | bytes | User I/O | <- name |
| 443865681 | cell multiblock physical read | cellhash# | diskhash# | bytes | User I/O | <- name |
| 3975960017 | cell list of blocks physical read | cellhash# | diskhash# | blocks | User I/O | <- name |
| 213372979 | cell physical read no I/O | cellhash# | diskhash# | bytes | User I/O | <- name |
| 1963099394 | cell single block read request | cellhash# | diskhash# | bytes | User I/O | <- name |
| 631446859 | cell multiblock read request | cellhash# | diskhash# | bytes | User I/O | <- name |
| 4067812586 | cell list of blocks read request | cellhash# | diskhash# | blocks | User I/O | <- name |
| 1946591843 | cell manager opening cell | cellhash# | System I/O | <- name | ||
| 1617821548 | cell manager closing cell | cellhash# | System I/O | <- name | ||
| 4026210594 | cell manager discovering disks | cellhash# | System I/O | <- name | ||
| 1693614820 | cell worker idle | Idle | <- name | |||
| 1736664284 | events in waitclass Other | Other | <- name | |||
| 2390244800 | enq: WM - WLM Plan activation | name|mode | 0 | 0 | Other | <- name |
| 3474287957 | latch free | address | number | why | Other | <- name |
| 2701202185 | latch activity | address | number | process# | Other | <- name |
| 2530878290 | wait list latch free | address | number | Other | <- name | |
| 2680091115 | kslwait unit test event 1 | p1 | p2 | p3 | Other | <- name |
| 2424426032 | kslwait unit test event 2 | p1 | p2 | p3 | Other | <- name |
| 2025755259 | kslwait unit test event 3 | p1 | p2 | p3 | Other | <- name |
| 2971802445 | unspecified wait event | Other | <- name | |||
| 3498297576 | global enqueue expand wait | Other | <- name | |||
| 2917886901 | free process state object | Other | <- name | |||
| 3757863830 | inactive session | session# | serial | instance | Other | <- name |
| 1812220754 | process terminate | Other | <- name | |||
| 139039345 | latch: call allocation | address | number | why | Other | <- name |
| 2900750527 | latch: session allocation | address | number | why | Other | <- name |
| 1945768837 | check CPU wait times | Other | <- name | |||
| 327222633 | ADG switchover completion | pdbid | Other | <- name | ||
| 1947980297 | process allocation slot | Other | <- name | |||
| 2915720968 | session allocation inc count | Other | <- name | |||
| 1760863753 | enq: CI - contention | name|mode | opcode | type | Other | <- name |
| 3733307663 | enq: PR - contention | name|mode | type | dtp | Other | <- name |
| 3155844579 | enq: AK - contention | type|mode | id1 | id2 | Other | <- name |
| 2921505296 | enq: XK - contention | type|mode | id1 | id2 | Other | <- name |
| 1210775251 | enq: DI - contention | type|mode | id1 | id2 | Other | <- name |
| 3710671834 | enq: RM - contention | type|mode | id1 | id2 | Other | <- name |
| 3226762304 | enq: BO - contention | type|mode | id1 | id2 | Other | <- name |
| 2383012730 | ges resource enqueue open retry sleep | Other | <- name | |||
| 2151749845 | ksim generic wait event | where | wait_count | Other | <- name | |
| 1981266442 | enq: DE - Update Draining Test | name|mode | 0 | 0 | Other | <- name |
| 2030748592 | debugger command | Other | <- name | |||
| 2530266680 | oradebug request slot | Other | <- name | |||
| 367999153 | oradebug request completion | Other | <- name | |||
| 4013410966 | latch: ksm sga alloc latch | address | number | why | Other | <- name |
| 1732444908 | defer SGA allocation slave | defer segment index |
allocation mode | Other | <- name | |
| 1785376945 | SGA Allocator termination | Other | <- name | |||
| 1800992443 | PGA memory operation | Other | <- name | |||
| 4129138703 | enq: PE - contention | name|mode | parno | 0 | Other | <- name |
| 925144608 | enq: PG - contention | name|mode | 0 | 0 | Other | <- name |
| 3228065868 | ksbsrv | Other | <- name | |||
| 3024348788 | ksbcic | Other | <- name | |||
| 875419734 | process startup | type | process# | Other | <- name | |
| 2726125541 | process shutdown | type | process# | Other | <- name | |
| 1060877110 | prior spawner clean up | process_pid | process_sno | Other | <- name | |
| 1973577887 | latch: messages | address | number | why | Other | <- name |
| 2616562781 | rdbms ipc message block | Other | <- name | |||
| 2587381521 | rdbms ipc reply | from_process | Other | <- name | ||
| 3999387466 | latch: pdb enqueue hash chains | address | number | why | Other | <- name |
| 1847483002 | latch: enqueue hash chains | address | number | why | Other | <- name |
| 880740118 | imm op | msg ptr | Other | <- name | ||
| 2914969843 | slave exit | nalive | sleeptime | loop | Other | <- name |
| 3750685624 | enq: FP - global fob contention | name|mode | low file obj add | high file obj add | Other | <- name |
| 1272752883 | enq: RE - block repair contention | name|mode | File Type or File number |
block number | Other | <- name |
| 3396302007 | enq: BM - clonedb bitmap file write | name|mode | block number | number of blocks | Other | <- name |
| 2505166323 | asynch descriptor resize | outstanding #aio | current aio limit | new aio limit | Other | <- name |
| 534373369 | OFS interrupted req not found | Other | <- name | |||
| 2004679423 | enq: FO - file system operation contention | name|mode | 0 | 0 | Other | <- name |
| 3804628168 | resmgr:plan change | con_id | Other | <- name | ||
| 1504129838 | enq: KM - contention | name|mode | type | type | Other | <- name |
| 1301289702 | enq: KT - contention | name|mode | plan # | 0 | Other | <- name |
| 2962754459 | enq: CA - contention | name|mode | 0 | 0 | Other | <- name |
| 2775294757 | enq: KD - determine DBRM master | name|mode | 0 | 0 | Other | <- name |
| 906644781 | reliable message | channel context | channel handle | broadcast message | Other | <- name |
| 973988003 | broadcast mesg queue transition | channel handle | message | location | Other | <- name |
| 1519436045 | broadcast mesg recovery queue transition | channel handle | message | location | Other | <- name |
| 1510356050 | KSV master wait | indicator | Other | <- name | ||
| 1628776795 | master exit | alive slaves | Other | <- name | ||
| 1361925913 | ksv slave avail wait | Other | <- name | |||
| 3063016909 | enq: PV - syncstart | name|mode | class id | 0 | Other | <- name |
| 2894614381 | enq: PV - syncshut | name|mode | class id | 0 | Other | <- name |
| 980653535 | enq: SP - contention 1 | name|mode | id1 | id2 | Other | <- name |
| 351221043 | enq: SP - contention 2 | name|mode | id1 | id2 | Other | <- name |
| 839059449 | enq: SP - contention 3 | name|mode | id1 | id2 | Other | <- name |
| 1340803846 | enq: SP - contention 4 | name|mode | id1 | id2 | Other | <- name |
| 3678823943 | enq: SX - contention 5 | name|mode | id1 | id2 | Other | <- name |
| 2086036097 | enq: SX - contention 6 | name|mode | id1 | id2 | Other | <- name |
| 2607158008 | first spare wait event | p1 | p2 | p3 | Other | <- name |
| 889843531 | second spare wait event | p1 | p2 | p3 | Other | <- name |
| 237562822 | Memory: Reg/Dereg | ksmsq context | address | length | Other | <- name |
| 2795431108 | IPC send completion sync | send count | Other | <- name | ||
| 710749070 | OSD IPC library | rolling mig | Other | <- name | ||
| 3327525223 | IPC wait for name service busy | Other | <- name | |||
| 1961805585 | IPC busy async request | Other | <- name | |||
| 429189883 | IPC waiting for OSD resources | Other | <- name | |||
| 3586266983 | ksxr poll remote instances | Other | <- name | |||
| 3974056937 | ksxr wait for mount shared | Other | <- name | |||
| 2278252783 | DBMS_LDAP: LDAP operation | Other | <- name | |||
| 97018265 | wait for FMON to come up | Other | <- name | |||
| 1830645796 | enq: FM - contention | name|mode | 0 | 0 | Other | <- name |
| 107371275 | enq: XY - contention | name|mode | id1 | id2 | Other | <- name |
| 2767884586 | latch: active service list | address | number | why | Other | <- name |
| 2022747370 | latch: service drain list | address | number | why | Other | <- name |
| 1086558492 | latch: last service list | address | number | why | Other | <- name |
| 753553155 | latch: java patching | address | number | why | Other | <- name |
| 2558928434 | enq: AS - service activation | name|mode | 0 | 0 | Other | <- name |
| 626337999 | JAVA patching | Other | <- name | |||
| 245034220 | enq: PD - contention | name|mode | property name | key hash | Other | <- name |
| 4097944222 | oracle thread bootstrap | pname | Other | <- name | ||
| 2423447952 | os thread creation | pname | is_process | Other | <- name | |
| 2192866519 | cleanup of aborted process | location | Other | <- name | ||
| 4131775738 | enq: XM - contention | type|mode | id1 | id2 | Other | <- name |
| 3530171172 | enq: RU - contention | name|mode | 0 | 0 | Other | <- name |
| 2020359573 | enq: RU - waiting | name|mode | 0 | 0 | Other | <- name |
| 2107633232 | rolling migration: cluster quiesce | location | waits | Other | <- name | |
| 2464601005 | LMON global data update | Other | <- name | |||
| 202883655 | rolling migration: orphans detected | Other | <- name | |||
| 2682948634 | process diagnostic dump | Other | <- name | |||
| 1933295843 | enq: MX - sync storage server info | name|mode | nodeid | instanceid | Other | <- name |
| 1992784715 | master diskmon startup | Other | <- name | |||
| 2421679227 | master diskmon read | Other | <- name | |||
| 1624113736 | DSKM to complete cell health check | Other | <- name | |||
| 616694188 | pmon dblkr tst event | index | Other | <- name | ||
| 2329324816 | latch: ksolt lwth alloc | address | number | why | Other | <- name |
| 3025569338 | lightweight thread operation | PURPOSE | ARG1 | ARG2 | Other | <- name |
| 219323361 | lightweight thread task completion | Tasks left | task_count | ARG3 | Other | <- name |
| 2347021890 | enq: WN - rw snapshot synchronization | name|mode | pluggable database id | snapshot name | Other | <- name |
| 1218217082 | read/write snapshot completion | file object handle | snapshot scn | pluggable database id |
Other | <- name |
| 1570927321 | enq: ZX - repopulation file write | name|mode | filename | block number | Other | <- name |
| 3466817607 | pmon cleanup | op | Other | <- name | ||
| 937324971 | pmon shutdown | type | num | Other | <- name | |
| 3765978937 | GL: cross instance latch free | Other | <- name | |||
| 1029869674 | RMA: rlog allocate | State Object | Instance | Other | <- name | |
| 1166502110 | RMA: RAC reconfig | Other | <- name | |||
| 1511705394 | RMA: latch | RMA Latch | Latch Val | Other | <- name | |
| 4031831034 | DNFS disp IO slave cleanup | clmn pnum | Other | <- name | ||
| 1440204212 | enq: KA - ACL control status | name|mode | 0 | 0 | Other | <- name |
| 1591580536 | Nest operation | Other | <- name | |||
| 332825436 | DIAG lock acquisition | where | Other | <- name | ||
| 665933121 | latch: ges resource hash list | address | number | why | Other | <- name |
| 3595075359 | DFS lock handle | type|mode | id1 | id2 | Other | <- name |
| 759618117 | ges server process to shutdown | type | Other | <- name | ||
| 3128645467 | ges client process to exit | Other | <- name | |||
| 2627274657 | ges global resource directory to be frozen | location | Other | <- name | ||
| 1761249154 | ges resource directory to be unfrozen | Other | <- name | |||
| 2871858069 | gcs resource directory to be unfrozen | Other | <- name | |||
| 2542045584 | ges LMD to inherit communication channels | Other | <- name | |||
| 1612310333 | ges lmd sync during reconfig | location | Other | <- name | ||
| 2796847522 | ges wait for lmon to be ready | Other | <- name | |||
| 2656205476 | ges cgs registration | where | Other | <- name | ||
| 1183226617 | wait for master scn | waittime | startscn | ackscn | Other | <- name |
| 1088316196 | ges yield cpu in reconfig | location | Other | <- name | ||
| 685206108 | ges2 proc latch in rm latch get 1 | Other | <- name | |||
| 154184229 | ges2 proc latch in rm latch get 2 | Other | <- name | |||
| 695825723 | ges lmd/lmses to freeze in rcfg | lmd/lms id | Other | <- name | ||
| 1010381418 | ges lmd/lmses to unfreeze in rcfg | lmd/lms id | Other | <- name | ||
| 1631772444 | ges lms sync during dynamic remastering and reconfig | location | lms id | Other | <- name | |
| 818898053 | ges LMON to join CGS group | Other | <- name | |||
| 3008471467 | ges pmon to exit | Other | <- name | |||
| 2595201782 | ges lmd and pmon to attach | Other | <- name | |||
| 4224327511 | gcs drm freeze begin | Other | <- name | |||
| 3116973328 | gcs retry nowait latch get | location | Other | <- name | ||
| 2635889591 | gcs remastering wait for read latch | flags | idx1 | idx2 | Other | <- name |
| 2181430622 | ges cached resource cleanup | waittime | Other | <- name | ||
| 2785624238 | ges generic event | Other | <- name | |||
| 1962787835 | ges instance reconfig name entry query | retry | inst | Other | <- name | |
| 2857777550 | ges process with outstanding i/o | pid | Other | <- name | ||
| 3957868722 | ges user error | error | Other | <- name | ||
| 2120155596 | ges enter server mode | Other | <- name | |||
| 350643236 | gcs enter server mode | Other | <- name | |||
| 4261098405 | ges ipc enter server mode | Other | <- name | |||
| 2038008095 | gcs drm freeze in enter server mode | Other | <- name | |||
| 1895771704 | gcs ddet enter server mode | Other | <- name | |||
| 2783453682 | ges cancel | Other | <- name | |||
| 26939470 | ges resource cleanout during enqueue open | Other | <- name | |||
| 1260212817 | ges resource cleanout during enqueue open-cvt | Other | <- name | |||
| 3741819151 | ges master to get established for SCN op | Other | <- name | |||
| 1312215341 | ges LMON to get to FTDONE | Other | <- name | |||
| 2863691995 | ges1 LMON to wake up LMD - mrcvr | Other | <- name | |||
| 1687619969 | ges2 LMON to wake up LMD - mrcvr | Other | <- name | |||
| 2414509731 | ges2 LMON to wake up lms - mrcvr 2 | Other | <- name | |||
| 2242140456 | ges2 LMON to wake up lms - mrcvr 3 | Other | <- name | |||
| 4086135771 | ges inquiry response | type|mode|where | id1 | id2 | Other | <- name |
| 3642965647 | ges reusing os pid | pid | count | Other | <- name | |
| 505407722 | ges LMON for send queues | Other | <- name | |||
| 643358389 | ges LMD suspend for testing event | Other | <- name | |||
| 2287899877 | ges performance test completion | Other | <- name | |||
| 1166323227 | kjbopen wait for recovery domain attach | Other | <- name | |||
| 361900693 | kjudomatt wait for recovery domain attach | Other | <- name | |||
| 2662540004 | kjudomdet wait for recovery domain detach | Other | <- name | |||
| 1193769478 | kjbdomalc allocate recovery domain - retry | Other | <- name | |||
| 1228081120 | kjbdrmcvtq lmon drm quiesce: ping completion | location | lms id | Other | <- name | |
| 164764783 | ges RMS0 retry add redo log | Other | <- name | |||
| 2627100592 | readable standby redo apply remastering | Other | <- name | |||
| 2589387632 | ges DFS hang analysis phase 2 acks | Other | <- name | |||
| 2986589560 | ges/gcs diag dump | location | Other | <- name | ||
| 3757130716 | global plug and play automatic resource creation | where | Other | <- name | ||
| 4188419816 | gcs lmon dirtydetach step completion | domain id | location | Other | <- name | |
| 2134833657 | recovery instance recovery completion | Other | <- name | |||
| 3271968413 | ack for a broadcasted res from a remote instance | Other | <- name | |||
| 2595497065 | kill all read-only instances in cluster | Other | <- name | |||
| 3664355268 | latch: kjci process context latch | address | number | why | Other | <- name |
| 3993261106 | latch: kjci request sequence latch | address | number | why | Other | <- name |
| 2765459430 | DLM cross inst call completion | caller instance number |
cluster incarnation number |
request identifier | Other | <- name |
| 3534674430 | DLM: shared instance mode init | Other | <- name | |||
| 1656318846 | enq: KI - contention | name|mode | client opcode | 0 | Other | <- name |
| 3296595079 | latch: kjoeq omni enqueue hash bucket latch | address | number | why | Other | <- name |
| 3892456182 | DLM enqueue copy completion | Owner ID | op|restype | id1|id2 | Other | <- name |
| 1575324855 | latch: kjoer owner hash bucket | address | number | why | Other | <- name |
| 1793459373 | DLM Omni Enq Owner replication | Owner ID | Other | <- name | ||
| 4079369678 | KJC: Wait for msg sends to complete | msg | dest|rcvr | mtype | Other | <- name |
| 1801723349 | ges message buffer allocation | pool | request | allocated | Other | <- name |
| 3613653811 | kjctssqmg: quick message send wait | Other | <- name | |||
| 3368851413 | gcs domain validation | cluinc | rcvinc | Other | <- name | |
| 142175773 | latch: gcs resource hash | address | number | why | Other | <- name |
| 2848189392 | affinity expansion in replay | Other | <- name | |||
| 2470511309 | wait for sync ack | cluinc | pending_nd | Other | <- name | |
| 189592347 | wait for verification ack | cluinc | pending_insts | Other | <- name | |
| 3428259705 | wait for assert messages to be sent | Other | <- name | |||
| 3937428465 | wait for scn ack | pending_nd | scn | Other | <- name | |
| 3928537616 | lms flush message acks | id | Other | <- name | ||
| 3954828229 | name-service call wait | waittime | op | loc | Other | <- name |
| 1736567536 | CGS wait for IPC msg | Other | <- name | |||
| 2321793642 | IMR hang simulation | Other | <- name | |||
| 4139178294 | IMR mount phase II completion | Other | <- name | |||
| 1175435584 | IMR disk votes | Other | <- name | |||
| 3706379258 | IMR rr lock release | Other | <- name | |||
| 872961962 | IMR net-check message ack | Other | <- name | |||
| 1055131010 | IMR rr update | Other | <- name | |||
| 1123581371 | IMR membership resolution | Other | <- name | |||
| 4003053530 | IMR CSS join retry | retry count | Other | <- name | ||
| 2448812170 | IMR slave process init | Other | <- name | |||
| 2268235780 | IMR slave process shutdown | location | Other | <- name | ||
| 269767187 | IMR slave acknowledgement msg | Other | <- name | |||
| 2151285256 | CGS skgxn join retry | retry count | Other | <- name | ||
| 4241215981 | CGS ping operation | location | Other | <- name | ||
| 1965140390 | gcs to be enabled | Other | <- name | |||
| 3480025058 | gcs log flush sync | waittime | poll | event | Other | <- name |
| 2222314230 | KA: shared KGA not initialized | Other | <- name | |||
| 2373399366 | enq: PP - contention | type|mode | id1 | id2 | Other | <- name |
| 2288038353 | enq: HM - contention | type|mode | id1 | id2 | Other | <- name |
| 2948850473 | GCR ctx lock acquisition | retry count | Other | <- name | ||
| 3428914697 | GCR CSS group lock | Other | <- name | |||
| 1308860334 | GCR CSS group join | retry count | Other | <- name | ||
| 3139209677 | GCR CSS group leave | Other | <- name | |||
| 2548959420 | GCR CSS group update | Other | <- name | |||
| 2771226010 | GCR CSS group query | Other | <- name | |||
| 3856692583 | enq: AC - acquiring partition id | name|mode | 0 | 0 | Other | <- name |
| 894671924 | LMA glob lock acquisition | lock | retry count | Other | <- name | |
| 3165031328 | LMA KGA glob lock acquisition | lock | retry count | Other | <- name | |
| 3418985179 | latch: GCS logfile block | address | number | why | Other | <- name |
| 812661408 | latch: GCS logfile write queue | address | number | why | Other | <- name |
| 2411650447 | LMFC reconfig operation | RCFG State | Operation | Other | <- name | |
| 3006093898 | PCFC: recovery domain valid | Other | <- name | |||
| 3493282803 | SGA: allocation forcing component growth | Other | <- name | |||
| 3659501038 | SGA: sga_target resize | Other | <- name | |||
| 1230198893 | enq: SC - contention | type|mode | id1 | id2 | Other | <- name |
| 40893507 | control file heartbeat | Other | <- name | |||
| 3061031534 | control file diagnostic dump | type | param | Other | <- name | |
| 1494394835 | enq: CF - contention | name|mode | 0 | operation | Other | <- name |
| 608373385 | enq: SW - contention | name|mode | 0 | 0 | Other | <- name |
| 1608438935 | enq: DS - contention | name|mode | 0 | 0 | Other | <- name |
| 1231322525 | enq: TC - contention | name|mode | checkpoint ID | 0 | Other | <- name |
| 718572278 | enq: TC - contention2 | name|mode | checkpoint ID | 0 | Other | <- name |
| 2332720660 | buffer exterminate | file# | block# | buf_ptr | Other | <- name |
| 4243513970 | kcbw: cache protect wait | Other | <- name | |||
| 3401628503 | latch: cache buffers lru chain | address | number | why | Other | <- name |
| 1340848367 | enq: PW - perwarm status in dbw0 | name|mode | 0 | 0 | Other | <- name |
| 22066106 | latch: checkpoint queue latch | address | number | why | Other | <- name |
| 2935866945 | latch: cache buffer handles | address | number | why | Other | <- name |
| 3476701947 | kcbzps | Other | <- name | |||
| 912137450 | DBWR range invalidation sync | dbwr# | Other | <- name | ||
| 218992928 | buffer deadlock | dba | class*10+mode | flag | Other | <- name |
| 1948834383 | buffer latch | latch addr | chain# | Other | <- name | |
| 3807851191 | cr request retry | file# | block# | Other | <- name | |
| 271673613 | influx scn | file# | block# | class# | Other | <- name |
| 479497384 | writes stopped by instance recovery or database suspension | by thread# | our thread# | Other | <- name | |
| 2545148957 | lock escalate retry | Other | <- name | |||
| 3412713426 | lock deadlock retry | Other | <- name | |||
| 1315338218 | prefetch warmup block being transferred | file# | block# | id# | Other | <- name |
| 105891848 | recovery buffer pinned | file# | block# | Other | <- name | |
| 1250260140 | tablespace key change | pdb# | ts# | file# | Other | <- name |
| 1531409241 | TSE SSO wallet reopen | Other | <- name | |||
| 3874022972 | force-cr-override flush | file# | block# | Other | <- name | |
| 2576559565 | enq: CR - block range reuse ckpt | name|mode | 2 | 0 | Other | <- name |
| 2622395338 | enq: TR - serialize TS rekeys | name|mode | pdbid | ts# | Other | <- name |
| 666989299 | enq: TR - database key open check | name|mode | pdbid | ts# | Other | <- name |
| 577169102 | enq: TR - serialize system rekeys | name|mode | pdbid | ts# | Other | <- name |
| 1898285196 | wait for MTTR advisory state object | Other | <- name | |||
| 295718413 | latch: object queue header operation | address | number | why | Other | <- name |
| 4273032105 | enq: BU - recovery set construct | name|mode | 0 | 0 | Other | <- name |
| 591247898 | enq: BU - recovery set takeover | name|mode | 0 | 0 | Other | <- name |
| 3102461226 | retry CFTXN during close | Other | <- name | |||
| 1383326310 | get branch/thread/sequence enqueue | Other | <- name | |||
| 2704451831 | enq: WL - Test access/locking | name|mode | log # / thread id # | sequence # | Other | <- name |
| 841803369 | Data Guard server operation completion | Other | <- name | |||
| 529335332 | FAL archive wait 1 sec for REOPEN minimum | Other | <- name | |||
| 4036275899 | TEST: action sync | Other | <- name | |||
| 205495275 | TEST: action hang | Other | <- name | |||
| 3845085937 | RSGA: RAC reconfiguration | Other | <- name | |||
| 1128412462 | enq: WL - RAC-wide SGA initialize | name|mode | log # / thread id # | sequence # | Other | <- name |
| 3068515786 | enq: WL - RAC-wide SGA write | name|mode | log # / thread id # | sequence # | Other | <- name |
| 3376312326 | enq: WL - RAC-wide SGA dump | name|mode | log # / thread id # | sequence # | Other | <- name |
| 2123819464 | MRP stop | Other | <- name | |||
| 4125956551 | enq: SA - standby redo logfiles | name|mode | 0 | 0 | Other | <- name |
| 1423505461 | enq: WS - contention | type|mode | id1 | id2 | Other | <- name |
| 4257177215 | MRP wait on process start | Other | <- name | |||
| 4223476495 | MRP wait on process restart | Other | <- name | |||
| 2370040255 | MRP wait on startup clear | Other | <- name | |||
| 56334152 | MRP inactivation | Other | <- name | |||
| 916189195 | MRP wait on archivelog arrival | Other | <- name | |||
| 649270296 | MRP wait on archivelog archival | Other | <- name | |||
| 2490803321 | enq: WL - Far Sync Fail Over | name|mode | log # / thread id # | sequence # | Other | <- name |
| 3285081853 | enq: SA - MRP SRL access | name|mode | 0 | 0 | Other | <- name |
| 3394915937 | Monitor testing | Other | <- name | |||
| 274926311 | enq: WL - redo_db table update | name|mode | log # / thread id # | sequence # | Other | <- name |
| 952807416 | enq: WL - redo_log table update | name|mode | log # / thread id # | sequence # | Other | <- name |
| 1722088478 | log switch/archive | thread# | Other | <- name | ||
| 3409933913 | enq: WL - Switchover To Primary | name|mode | log # / thread id # | sequence # | Other | <- name |
| 805821516 | ARCH wait on c/f tx acquire 1 | Other | <- name | |||
| 3771596012 | RFS attach | Other | <- name | |||
| 4172664383 | RFS create | Other | <- name | |||
| 2508684169 | RFS close | Other | <- name | |||
| 1498277161 | RFS announce | Other | <- name | |||
| 2909083597 | RFS register | Other | <- name | |||
| 1120829189 | RFS detach | Other | <- name | |||
| 571751314 | RFS ping | Other | <- name | |||
| 881117162 | RFS dispatch | Other | <- name | |||
| 784686743 | enq: WL - RFS global state contention | name|mode | log # / thread id # | sequence # | Other | <- name |
| 219245212 | enq: WL - SNA access/locking | name|mode | log # / thread id # | sequence # | Other | <- name |
| 984914326 | LGWR simulation latency wait | Other | <- name | |||
| 781082802 | LNS simulation latency wait | Other | <- name | |||
| 668166272 | ASYNC Remote Write | Other | <- name | |||
| 3339190814 | SYNC Remote Write | Other | <- name | |||
| 2147654677 | ARCH Remote Write | Other | <- name | |||
| 2528235682 | Redo Transport Attach | Other | <- name | |||
| 33151350 | Redo Transport Detach | Other | <- name | |||
| 3470397773 | Redo Transport Open | Other | <- name | |||
| 1539866381 | Redo Transport Close | Other | <- name | |||
| 2666458816 | Redo Transport Ping | Other | <- name | |||
| 1319950766 | Remote SYNC Ping | Other | <- name | |||
| 3032907492 | Redo Transport Slave Startup | Other | <- name | |||
| 188013640 | Redo Transport Slave Shutdown | Other | <- name | |||
| 3656641042 | Redo Writer Remote Sync Notify | Other | <- name | |||
| 3213124895 | Redo Writer Remote Sync Complete | Other | <- name | |||
| 3944789232 | Redo Transport MISC | Other | <- name | |||
| 566288919 | Redo Transport Network Throttle | Other | <- name | |||
| 649262647 | enq: WL - Network Throttle | name|mode | log # / thread id # | sequence # | Other | <- name |
| 3098550178 | LGWR-LNS wait on channel | Other | <- name | |||
| 1211302889 | enq: WR - contention | name|mode | thread id # | sequence # | Other | <- name |
| 2617915495 | Data Guard: rtrt work | Other | <- name | |||
| 3291268781 | Redo transport testing | Other | <- name | |||
| 3601986267 | enq: RZ - add element | name|mode | 0 | 0 | Other | <- name |
| 1802258776 | enq: RZ - remove element | name|mode | 0 | 0 | Other | <- name |
| 3839860880 | Image redo gen delay | Other | redo resource management | |||
| 3451340452 | Long operation CF pause | Other | CF txn pause | |||
| 4266849434 | LGWR wait for redo copy | copy latch # | Other | <- name | ||
| 266850936 | latch: redo allocation | address | number | why | Other | <- name |
| 1561425187 | log file switch (clearing log file) | Other | <- name | |||
| 4160645236 | log file sync: PDB shutdown abort | sync scn | Other | <- name | ||
| 2397844549 | target log write size | Other | <- name | |||
| 1793502753 | LGWR any worker group | Other | <- name | |||
| 1249397642 | LGWR all worker groups | Other | <- name | |||
| 3116432628 | LGWR worker group ordering | lwn_id | phase | Other | <- name | |
| 771590720 | LGWR intra group sync | where | groupid | slaveid | Other | <- name |
| 269666300 | LGWR intra group IO completion | where | groupid | slaveid | Other | <- name |
| 1555037586 | enq: WL - contention | name|mode | log # / thread id # | sequence # | Other | <- name |
| 1281359820 | enq: RN - contention | name|mode | thread number | log number | Other | <- name |
| 1242352358 | DFS db file lock | file# | Other | quiesce for datafile offline |
||
| 665338553 | PDB close/open on another instance | Other | <- name | |||
| 80051109 | database open on read-write instance | Other | <- name | |||
| 217146514 | enq: DF - contention | name|mode | 0 | file # | Other | <- name |
| 1184948750 | enq: IS - contention | name|mode | 0 or pdbid | type | Other | <- name |
| 1317384776 | enq: IP - open/close PDB | name|mode | type | pdbuid | Other | <- name |
| 3839871930 | enq: PX - PDB instance recovery | name|mode | 0 or thread# | type | Other | <- name |
| 1309055815 | enq: FS - contention | name|mode | 0 or pdbid | type | Other | <- name |
| 2183635389 | enq: FS - online log operation | name|mode | 0 or pdbid | type | Other | <- name |
| 3294817508 | enq: DM - contention | name|mode | type | type | Other | <- name |
| 178034865 | enq: DM - access control | name|mode | type | type | Other | <- name |
| 647852263 | enq: RP - contention | name|mode | file # | 1 or block | Other | <- name |
| 1925256273 | latch: gc element | address | number | why | Other | <- name |
| 4193134291 | redo log switch request completion | Other | <- name | |||
| 1143317824 | enq: RT - contention | name|mode | redo thread | type | Other | <- name |
| 2588100800 | enq: RT - thread internal enable/disable | name|mode | redo thread | type | Other | <- name |
| 4021392840 | enq: IR - contention | name|mode | 0 | 0/1 | Other | <- name |
| 3041521765 | enq: IR - contention2 | name|mode | 0 | 0/1 | Other | <- name |
| 457958410 | enq: IR - global serialization | name|mode | 0 | 0/1 | Other | <- name |
| 3639275442 | enq: IR - local serialization | name|mode | 0 | 0/1 | Other | <- name |
| 1926932789 | enq: IR - arbitrate instance recovery | name|mode | 0 | 0/1 | Other | <- name |
| 3113891348 | enq: MR - contention | name|mode | 0 or file # | type | Other | <- name |
| 3480024039 | enq: MR - standby role transition | name|mode | 0 or file # | type | Other | <- name |
| 2989355594 | enq: MR - multi instance redo apply | name|mode | 0 or file # | type | Other | <- name |
| 901508430 | enq: MR - any role transition | name|mode | 0 or file # | type | Other | <- name |
| 2835520952 | enq: MR - PDB open | name|mode | 0 or file # | type | Other | <- name |
| 2431157470 | enq: MR - datafile online | name|mode | 0 or file # | type | Other | <- name |
| 2195955142 | enq: MR - adg instance recovery | name|mode | 0 or file # | type | Other | <- name |
| 2266304296 | enq: MR - preplugin recovery | name|mode | 0 or file # | type | Other | <- name |
| 1315198629 | enq: MR - datafile pre-create | name|mode | 0 or file # | type | Other | <- name |
| 1819372799 | shutdown after switchover to standby | Other | <- name | |||
| 855778212 | cancel media recovery on switchover | Other | <- name | |||
| 2172988940 | PDB lock domain invalidation | Other | <- name | |||
| 2289478848 | Recovery: scn growth limit | Other | <- name | |||
| 2938939381 | parallel recovery coord wait for reply | Other | <- name | |||
| 201710181 | parallel recovery coord send blocked | Other | <- name | |||
| 4008505077 | parallel recovery slave wait for change | Other | <- name | |||
| 3954034543 | enq: BR - file shrink | name|mode | operation | file # | Other | <- name |
| 1796838767 | enq: BR - proxy-copy | name|mode | operation | file # | Other | <- name |
| 1785130586 | enq: BR - multi-section restore header | name|mode | operation | file # | Other | <- name |
| 1429048489 | enq: BR - multi-section restore section | name|mode | operation | file # | Other | <- name |
| 3146685455 | enq: BR - space info datafile hdr update | name|mode | operation | file # | Other | <- name |
| 4186138071 | enq: BR - request autobackup | name|mode | operation | file # | Other | <- name |
| 120917685 | enq: BR - perform autobackup | name|mode | operation | file # | Other | <- name |
| 1408460348 | enq: BR - perform catalog recovery area | name|mode | operation | file # | Other | <- name |
| 4055016213 | enq: ID - contention | name|mode | 0 | 0 | Other | <- name |
| 1895301661 | Backup Restore Throttle sleep | session_id | serial | Other | <- name | |
| 3940042335 | Backup Restore Switch Bitmap sleep | session_id | serial | Other | <- name | |
| 1158580207 | Backup Restore Event sleep | session_id | serial | Other | <- name | |
| 2696003729 | RMAN wallet access limit | Other | <- name | |||
| 4254153540 | enq: BS - Backup spare1 | name|mode | id1 | id2 | Other | <- name |
| 3572922547 | enq: BS - Backup spare2 | name|mode | id1 | id2 | Other | <- name |
| 1519110690 | enq: BS - Backup spare3 | name|mode | id1 | id2 | Other | <- name |
| 918511175 | enq: BS - Backup spare4 | name|mode | id1 | id2 | Other | <- name |
| 119366042 | enq: BS - Backup spare5 | name|mode | id1 | id2 | Other | <- name |
| 4127095906 | enq: BS - Backup spare6 | name|mode | id1 | id2 | Other | <- name |
| 890108316 | enq: BS - Backup spare7 | name|mode | id1 | id2 | Other | <- name |
| 4010237913 | enq: BS - Backup spare8 | name|mode | id1 | id2 | Other | <- name |
| 512631582 | enq: BS - Backup spare9 | name|mode | id1 | id2 | Other | <- name |
| 2567538002 | enq: BS - Backup spare0 | name|mode | id1 | id2 | Other | <- name |
| 513503674 | enq: AB - ABMR process start/stop | name|mode | operation | operation parm | Other | <- name |
| 4289089804 | enq: AB - ABMR process initialized | name|mode | operation | operation parm | Other | <- name |
| 1348089685 | Auto BMR completion | file# | block# | Other | <- name | |
| 3217997244 | Auto BMR RPC standby catchup | wrap | base | Other | <- name | |
| 1423698111 | enq: ZR - ZDLRA lock db | name|mode | operation | id | Other | <- name |
| 2394356444 | enq: ZR - ZDLRA lock storage loc | name|mode | operation | id | Other | <- name |
| 165935761 | enq: ZR - ZDLRA lock timer queue | name|mode | operation | id | Other | <- name |
| 1636438482 | enq: ZR - ZDLRA lock scheduler | name|mode | operation | id | Other | <- name |
| 1002738712 | enq: ZR - ZDLRA lock API | name|mode | operation | id | Other | <- name |
| 2470140807 | enq: ZR - ZDLRA quiesce tasks | name|mode | operation | id | Other | <- name |
| 1254781511 | enq: ZR - ZDLRA check quiesce tasks | name|mode | operation | id | Other | <- name |
| 2590051530 | enq: ZR - ZDLRA quiesce servlets | name|mode | operation | id | Other | <- name |
| 4080162904 | enq: ZR - ZDLRA check servlet quiescence | name|mode | operation | id | Other | <- name |
| 2124551921 | enq: ZR - ZDLRA serialize unregister db | name|mode | operation | id | Other | <- name |
| 466463911 | enq: ZR - ZDLRA run scheduler | name|mode | operation | id | Other | <- name |
| 1183844682 | enq: ZR - ZDLRA purge storage loc | name|mode | operation | id | Other | <- name |
| 618668824 | enq: ZR - ZDLRA spare enq 10 | name|mode | operation | id | Other | <- name |
| 204987005 | enq: ZR - ZDLRA invalidate plans | name|mode | operation | id | Other | <- name |
| 680840689 | enq: ZR - ZDLRA protect plans | name|mode | operation | id | Other | <- name |
| 4290115138 | enq: BC - drop container group | name|mode | container group | container id | Other | <- name |
| 995732317 | enq: BC - create container | name|mode | container group | container id | Other | <- name |
| 1176032305 | enq: BC - group - create container | name|mode | container group | container id | Other | <- name |
| 3553233538 | enq: BC - drop container | name|mode | container group | container id | Other | <- name |
| 1267579589 | enq: BC - group - create file | name|mode | container group | container id | Other | <- name |
| 623108742 | enq: BI - create file | name|mode | group ID / file ID | file ID | Other | <- name |
| 84640895 | enq: BI - identify file | name|mode | group ID / file ID | file ID | Other | <- name |
| 2652244696 | enq: BI - delete file | name|mode | group ID / file ID | file ID | Other | <- name |
| 2214479234 | enq: BZ - resize file | name|mode | group ID / file ID | file ID | Other | <- name |
| 990760803 | enq: BV - rebuild/validate group | name|mode | amrv$ key | Other | <- name | |
| 1532804659 | Backup Appliance container synchronous read | block# | blocks | Other | <- name | |
| 3349653204 | Backup Appliance container synchronous write | block# | blocks | Other | <- name | |
| 2488361479 | Backup Appliance container I/O | requests | Other | <- name | ||
| 823842457 | Supplemental logging roles | role id | Other | <- name | ||
| 2347406356 | LogMiner builder: queue full | Session ID | Other | <- name | ||
| 3592915900 | LogMiner reader: redo slot | Session ID | Thread | Other | <- name | |
| 1126267022 | LogMiner reader: memory | Session ID | Other | <- name | ||
| 2344841594 | LogMiner merger: redo slot | Session ID | Other | <- name | ||
| 1937230003 | LogMiner: txn | Session ID | Lock | State | Other | <- name |
| 146026836 | LogMiner: queue | Session ID | Lock | State | Other | <- name |
| 2806308254 | LogMiner: session audit list | Session ID | Lock | State | Other | <- name |
| 1047024350 | LogMiner FSC: dictionary load completion | Session ID | Other | <- name | ||
| 1489162918 | enq: MN - contention | name|mode | session ID | 0 | Other | <- name |
| 2417659362 | enq: ZL - LogMiner foreign log metadata | name|mode | session ID | 0 | Other | <- name |
| 622794581 | enq: PL - contention | name|mode | 0 | 0 | Other | <- name |
| 1930628560 | enq: CP - Pluggable database resetlogs | name|mode | Internal | Internal | Other | <- name |
| 260587712 | enq: SB - logical standby metadata | name|mode | 0 | 0 | Other | <- name |
| 2514944057 | enq: SB - table instantiation | name|mode | 0 | 0 | Other | <- name |
| 2366696931 | Logical Standby Apply shutdown | Other | <- name | |||
| 2276822405 | Logical Standby pin transaction | xidusn | xidslt | xidsqn | Other | <- name |
| 1748443679 | Logical Standby dictionary build | Other | <- name | |||
| 3415281788 | Logical Standby Terminal Apply | stage | Other | <- name | ||
| 993838451 | Logical Standby Debug | event | Other | <- name | ||
| 1061728450 | Resolution of in-doubt txns | SCN | Other | <- name | ||
| 707813539 | enq: XR - quiesce database | name|mode | operation | 0 | Other | <- name |
| 3609173507 | enq: XR - database force logging | name|mode | operation | 0 | Other | <- name |
| 529913931 | ADG query scn advance | Other | <- name | |||
| 4238679773 | ADG instance recovery complete | Other | <- name | |||
| 907871122 | latch: obj/range reuse redo processing | address | number | why | Other | <- name |
| 4185983479 | standby query scn advance | Other | <- name | |||
| 1445223374 | change tracking file synchronous read | block# | blocks | Other | <- name | |
| 424098511 | change tracking file synchronous write | block# | blocks | Other | <- name | |
| 30036540 | change tracking file parallel write | blocks | requests | Other | <- name | |
| 513392991 | block change tracking buffer space | Other | <- name | |||
| 4217808978 | CTWR media recovery checkpoint request | Other | <- name | |||
| 1487467637 | enq: CT - global space management | name|mode | operation | operation parm | Other | <- name |
| 3466352936 | enq: CT - local space management | name|mode | operation | operation parm | Other | <- name |
| 690018733 | enq: CT - change stream ownership | name|mode | operation | operation parm | Other | <- name |
| 2979034732 | enq: CT - state | name|mode | operation | operation parm | Other | <- name |
| 790405879 | enq: CT - state change gate 1 | name|mode | operation | operation parm | Other | <- name |
| 2477507895 | enq: CT - state change gate 2 | name|mode | operation | operation parm | Other | <- name |
| 3488556206 | enq: CT - CTWR process start/stop | name|mode | operation | operation parm | Other | <- name |
| 513540187 | enq: CT - reading | name|mode | operation | operation parm | Other | <- name |
| 3598948525 | recovery area: computing dropped files | Other | <- name | |||
| 4063976546 | recovery area: computing obsolete files | Other | <- name | |||
| 1877105024 | recovery area: computing backed up files | Other | <- name | |||
| 2825667152 | recovery area: computing applied logs | Other | <- name | |||
| 2897929244 | enq: RS - file delete | name|mode | record type | record id | Other | <- name |
| 313351369 | enq: RS - record reuse | name|mode | record type | record id | Other | <- name |
| 3504071695 | enq: RS - prevent file delete | name|mode | record type | record id | Other | <- name |
| 3170569251 | enq: RS - prevent aging list update | name|mode | record type | record id | Other | <- name |
| 3178040924 | enq: RS - persist alert level | name|mode | record type | record id | Other | <- name |
| 115643876 | enq: RS - read alert level | name|mode | record type | record id | Other | <- name |
| 3488540422 | enq: RS - write alert level | name|mode | record type | record id | Other | <- name |
| 3383573524 | enq: FL - Flashback database log | name|mode | Log # | zero | Other | <- name |
| 511900941 | enq: FL - Flashback db command | name|mode | Log # | zero | Other | <- name |
| 1057119651 | enq: FD - Marker generation | name|mode | Internal | Internal | Other | <- name |
| 120716488 | enq: FD - Tablespace flashback on/off | name|mode | Internal | Internal | Other | <- name |
| 3377895670 | enq: FD - Flashback coordinator | name|mode | Internal | Internal | Other | <- name |
| 1783985711 | enq: FD - Flashback on/off | name|mode | Internal | Internal | Other | <- name |
| 795831746 | enq: FD - Restore point create/drop | name|mode | Internal | Internal | Other | <- name |
| 2085703061 | enq: FD - Flashback logical operations | name|mode | Internal | Internal | Other | <- name |
| 1729254775 | flashback free VI log | Other | <- name | |||
| 3594374201 | flashback log switch | Other | <- name | |||
| 626068540 | enq: FW - contention | type|mode | id1 | id2 | Other | <- name |
| 799112511 | RVWR wait for flashback copy | copy latch # | Other | <- name | ||
| 3601079116 | parallel recovery read buffer free | Other | <- name | |||
| 3312658627 | parallel recovery redo cache buffer free | Other | <- name | |||
| 4215254072 | parallel recovery change buffer free | Other | <- name | |||
| 2620531563 | parallel recovery push change | Other | <- name | |||
| 3995823356 | cell smart flash keep | cellhash# | Other | <- name | ||
| 4081701776 | cell smart flash unkeep | cellhash# | Other | <- name | ||
| 2051476866 | cell ram cache population | cellhash# | Other | <- name | ||
| 3015991344 | parallel recovery coord: all replies | Other | <- name | |||
| 930916630 | datafile move cleanup during resize | Other | online move datafile resize cleanup |
|||
| 1699923767 | Nologging Standby Unit Test | Other | <- name | |||
| 3599750200 | Nonlogged block fetch | Absolute file | Start block | RCVID or Request | Other | <- name |
| 3747686915 | recovery receive buffer free | Other | <- name | |||
| 261947819 | recovery cancel | Other | <- name | |||
| 689601736 | recovery remote file verification | Other | <- name | |||
| 3798980926 | recovery active instance mapping setup | Other | <- name | |||
| 25545516 | recovery new thread enable | Other | <- name | |||
| 3479514684 | recovery file header update for checkpoint | Other | <- name | |||
| 1591128517 | recovery file header update for fuzziness | Other | <- name | |||
| 376996958 | recovery coordinator apply pending | Other | <- name | |||
| 2158353269 | recovery coordinator marker apply | Other | <- name | |||
| 3702772090 | recovery coordinator message | Other | <- name | |||
| 60575812 | recovery merge pending | Other | <- name | |||
| 3948720099 | recovery metadata latch | Other | <- name | |||
| 4257452445 | recovery checkpoint | Other | <- name | |||
| 1877449207 | recovery apply pending | Other | <- name | |||
| 519712656 | recovery fuzzy update | Other | <- name | |||
| 1797919480 | recovery shutdown | Other | <- name | |||
| 321437621 | recovery message | Other | <- name | |||
| 2011314812 | recovery slaves to be informed | Other | <- name | |||
| 3371685550 | recovery move influx buffers | Other | <- name | |||
| 2421198487 | recovery marker apply | Other | <- name | |||
| 4023429149 | recovery timestamp | Other | <- name | |||
| 3178497879 | recovery send buffer free | Other | <- name | |||
| 4093658961 | DBMS_ROLLING instruction completion | Instruction id | Other | <- name | ||
| 3030855852 | Shadow lost write | Other | <- name | |||
| 2177880604 | blocking txn id for DDL | table | scn | only dml | Other | <- name |
| 2153157043 | transaction | undo seg#|slot# | wrap# | count | Other | <- name |
| 403545727 | inactive transaction branch | branch# | waited | Other | <- name | |
| 957725912 | txn to complete | Other | <- name | |||
| 2264655921 | PMON to cleanup pseudo-branches at svc stop time | Other | <- name | |||
| 2206434397 | PMON to cleanup detached branches at shutdown | Other | <- name | |||
| 2091246363 | test long ops | Other | <- name | |||
| 2221529869 | latch: undo global data | address | number | why | Other | <- name |
| 1467219297 | undo segment recovery | segment# | tx flags | Other | <- name | |
| 4224098334 | unbound tx | Other | <- name | |||
| 865316074 | wait for change | Other | <- name | |||
| 1657000051 | wait for another txn - undo rcv abort | Other | <- name | |||
| 1886837281 | wait for another txn - txn abort | Other | <- name | |||
| 2537911001 | wait for another txn - rollback to savepoint | Other | <- name | |||
| 313295972 | undo_retention publish retry | where | retry_count | Other | <- name | |
| 2742799282 | txn cache read version | Other | <- name | |||
| 2605232529 | enq: TA - contention | name|mode | operation | undo segment # / other |
Other | <- name |
| 1629782133 | enq: TX - contention | name|mode | usn<<16 | slot | sequence | Other | <- name |
| 2458904239 | enq: US - contention | name|mode | undo segment # | 0 | Other | <- name |
| 3065535233 | wait for stopper event to be increased | Other | <- name | |||
| 3020078888 | wait for a undo record | Other | <- name | |||
| 289494273 | wait for a paralle reco to abort | Other | <- name | |||
| 2301151944 | enq: IM - contention for blr | name|mode | pool # | 0 | Other | <- name |
| 1752153790 | enq: TD - KTF dump entries | name|mode | 0 | 0 | Other | <- name |
| 4241032297 | enq: TE - KTF broadcast | name|mode | 0 | 0 | Other | <- name |
| 706934628 | enq: CN - race with txn | name|mode | reg id | 0 | Other | <- name |
| 4060759714 | enq: CN - race with reg | name|mode | reg id | 0 | Other | <- name |
| 613420004 | enq: CN - race with init | name|mode | reg id | 0 | Other | <- name |
| 2549235236 | latch: Change Notification Hash table latch | address | number | why | Other | <- name |
| 606473003 | enq: CO - master slave det | name|mode | inst id | 0 | Other | <- name |
| 3932945957 | enq: FE - contention | name|mode | 0 | 0 | Other | <- name |
| 2487720797 | latch: change notification client cache latch | address | number | why | Other | <- name |
| 3805228026 | latch: SGA Logging Log Latch | address | number | why | Other | <- name |
| 3039512838 | latch: SGA Logging Bkt Latch | address | number | why | Other | <- name |
| 305609008 | enq: MC - Securefile log | name|mode | 0 | hash(logname) | Other | <- name |
| 1813165094 | enq: MF - flush bkgnd periodic | name|mode | logid | bktId<<16|instid | Other | <- name |
| 2216368433 | enq: MF - creating swap in instance | name|mode | logid | bktId<<16|instid | Other | <- name |
| 4015649387 | enq: MF - flush space | name|mode | logid | bktId<<16|instid | Other | <- name |
| 1168962483 | enq: MF - flush client | name|mode | logid | bktId<<16|instid | Other | <- name |
| 322730247 | enq: MF - flush prior error | name|mode | logid | bktId<<16|instid | Other | <- name |
| 3312041081 | enq: MF - flush destroy | name|mode | logid | bktId<<16|instid | Other | <- name |
| 3248177810 | latch: ILM activity tracking latch | address | number | why | Other | <- name |
| 3307999956 | latch: ILM access tracking extent | address | number | why | Other | <- name |
| 3751718539 | IM CU busy | Other | <- name | |||
| 1224810073 | enq: ZQ - register | name|mode | ts# | dba | Other | <- name |
| 139032432 | enq: ZQ - quiesce | name|mode | ts# | dba | Other | <- name |
| 3524622153 | IM ADG space pressure | bucket#|slave# | retry# | count | Other | <- name |
| 896842959 | enq: TF - contention | name|mode | PDB ID & tablespace # | relative file # | Other | <- name |
| 310348786 | latch: lob segment hash table latch | address | number | why | Other | <- name |
| 2868244995 | latch: lob segment query latch | address | number | why | Other | <- name |
| 361584826 | latch: lob segment dispenser latch | address | number | why | Other | <- name |
| 2934069603 | Wait for shrink lock2 | object_id | lock_mode | Other | <- name | |
| 3943836588 | Wait for shrink lock | object_id | lock_mode | Other | <- name | |
| 1330927475 | L1 validation | seghdr | l1bmb | Other | <- name | |
| 628015238 | Wait for TT enqueue | tsn | Other | <- name | ||
| 3075113618 | kttm2d | Other | <- name | |||
| 1972012953 | ktsambl | Other | <- name | |||
| 2560588841 | ktfbtgex | tsn | Other | <- name | ||
| 319052581 | enq: DT - contention | name|mode | 0 | 0 | Other | <- name |
| 2667616873 | enq: TS - contention | name|mode | tablespace ID | dba | Other | <- name |
| 1238611814 | enq: FB - contention | name|mode | tablespace # | dba | Other | <- name |
| 2678203686 | enq: SK - contention | name|mode | tablespace # | dba | Other | <- name |
| 2910919470 | enq: DW - contention | name|mode | tablespace # | dba | Other | <- name |
| 3652428359 | enq: SU - contention | name|mode | table space # | 0 | Other | <- name |
| 4205956891 | enq: TT - contention | name|mode | tablespace ID | operation | Other | <- name |
| 3226067315 | ktm: instance recovery | undo segment# | Other | <- name | ||
| 1525267497 | instance state change | layer | value | waited | Other | <- name |
| 1335721068 | enq: SM - contention | type|mode | id1 | id2 | Other | <- name |
| 887351382 | enq: SJ - Slave Task Cancel | name|mode | Slave process id | task id | Other | <- name |
| 2705466509 | Space Manager: slave messages | Other | <- name | |||
| 3728789504 | enq: FH - contention | name|mode | Instance ID | Other | <- name | |
| 4294793344 | latch: IM area scb latch | address | number | why | Other | <- name |
| 1911429171 | latch: IM area sb latch | address | number | why | Other | <- name |
| 404240180 | enq: TZ - contention | name|mode | tablespace # | dba | Other | <- name |
| 3618490056 | enq: IN - contention | name|mode | tablespace # | dba | Other | <- name |
| 1409544283 | enq: ZB - contention | name|mode | tablespace # | dba | Other | <- name |
| 974506341 | latch: IM seg hdr latch | address | number | why | Other | <- name |
| 483380562 | latch: IM emb latch | address | number | why | Other | <- name |
| 4152697039 | Analyze hash compare | Other | <- name | |||
| 67546339 | index block split | rootdba | level | childdba | Other | <- name |
| 1147524433 | internal test event (index split branch) | Other | <- name | |||
| 2057953336 | internal test event (index split leaf) | Other | <- name | |||
| 2099272158 | kdblil wait before retrying ORA-54 | Other | <- name | |||
| 3753064287 | dupl. cluster key | dba | Other | <- name | ||
| 3554823254 | internal test event (index merge) | Other | <- name | |||
| 1349347951 | enq: DL - contention | name|mode | object # | 0 | Other | <- name |
| 403868930 | enq: HQ - contention | name|mode | object # | hash value | Other | <- name |
| 893937616 | enq: HP - contention | name|mode | tablespace # | dba | Other | <- name |
| 3874544423 | Securefile Write Gather Cache Yield Process | Other | <- name | |||
| 1065985958 | enq: KL - contention | type|mode | id1 | id2 | Other | <- name |
| 3445676385 | enq: WG - delete fso | name|mode | kdlw lobid first half | kdlw lobid sec half | Other | <- name |
| 3380482012 | enq: SL - get lock | name|mode | kdlw lobid first half | kdlw lobid sec half | Other | <- name |
| 1973889364 | enq: SL - escalate lock | name|mode | kdlw lobid first half | kdlw lobid sec half | Other | <- name |
| 3555038872 | enq: SL - get lock for undo | name|mode | kdlw lobid first half | kdlw lobid sec half | Other | <- name |
| 2630448508 | enq: ZH - compression analysis | name|mode | obj# | ulevel | Other | <- name |
| 2929689230 | Compression analysis | Other | <- name | |||
| 608160643 | enq: SZ - contention | name|mode | tablespace # | rdba | Other | <- name |
| 2990561203 | enq: ZC - FS Seg contention | name|mode | tsn# | objd# | Other | <- name |
| 2876222906 | enq: ZD - FS CU mod | name|mode | segid | startdba | Other | <- name |
| 987611292 | enq: SY - IM populate by other session | name|mode | tablespace # & objd | rdba | Other | <- name |
| 2350325668 | enq: JZ - Join group dictionary | name|mode | 0 | 0 | Other | <- name |
| 2513432000 | IM populate completion | Other | <- name | |||
| 3843389040 | IMXT Populate - drop HT | Other | <- name | |||
| 1035049954 | IM FastStart deadlock retry | Other | <- name | |||
| 1300659046 | IM ADO scheduler retry | Other | <- name | |||
| 3484624144 | latch: IMFS defer write list | address | number | why | Other | <- name |
| 882830310 | IMFS Flush defer writes | Other | <- name | |||
| 390916909 | In-Memory populate: over pga limit | process number | serial number | Other | <- name | |
| 2984698957 | latch: Column stats entry latch | address | number | why | Other | <- name |
| 2322167609 | row cache cleanup | Other | <- name | |||
| 1263391620 | row cache process | location | Other | <- name | ||
| 108267531 | enq: QA - contention | type|mode | id1 | id2 | Other | <- name |
| 1139092931 | enq: QB - contention | type|mode | id1 | id2 | Other | <- name |
| 1907863590 | enq: QC - contention | type|mode | id1 | id2 | Other | <- name |
| 3962851118 | enq: QD - contention | type|mode | id1 | id2 | Other | <- name |
| 774455082 | enq: QE - contention | type|mode | id1 | id2 | Other | <- name |
| 2436256250 | enq: QF - contention | type|mode | id1 | id2 | Other | <- name |
| 1347029671 | enq: QG - contention | type|mode | id1 | id2 | Other | <- name |
| 1414776114 | enq: QH - contention | type|mode | id1 | id2 | Other | <- name |
| 1851813854 | enq: QI - contention | type|mode | id1 | id2 | Other | <- name |
| 4087131843 | enq: QJ - contention | type|mode | id1 | id2 | Other | <- name |
| 1542600248 | enq: QK - contention | type|mode | id1 | id2 | Other | <- name |
| 2159175404 | enq: QL - contention | type|mode | id1 | id2 | Other | <- name |
| 1480629321 | enq: QM - contention | type|mode | id1 | id2 | Other | <- name |
| 988442240 | enq: QN - contention | type|mode | id1 | id2 | Other | <- name |
| 1348672103 | enq: QO - contention | type|mode | id1 | id2 | Other | <- name |
| 4077590343 | enq: QP - contention | type|mode | id1 | id2 | Other | <- name |
| 871478667 | enq: QQ - contention | type|mode | id1 | id2 | Other | <- name |
| 188776046 | enq: QR - contention | type|mode | id1 | id2 | Other | <- name |
| 3543257946 | enq: QS - contention | type|mode | id1 | id2 | Other | <- name |
| 2183806234 | enq: QT - contention | type|mode | id1 | id2 | Other | <- name |
| 331767289 | enq: QU - contention | type|mode | id1 | id2 | Other | <- name |
| 251336424 | enq: QV - contention | type|mode | id1 | id2 | Other | <- name |
| 348872490 | enq: QX - contention | type|mode | id1 | id2 | Other | <- name |
| 2109119095 | enq: QY - contention | type|mode | id1 | id2 | Other | <- name |
| 1939400123 | enq: QZ - contention | type|mode | id1 | id2 | Other | <- name |
| 2210508267 | enq: DV - contention | name|mode | object # | 0 | Other | <- name |
| 2584404246 | enq: SO - contention | name|mode | object # | 0 | Other | <- name |
| 2513782899 | RAC: row cache lock nowait retry | stub handle | attempt count | Other | <- name | |
| 4136932854 | enq: VA - contention | type|mode | id1 | id2 | Other | <- name |
| 143723934 | enq: VB - contention | type|mode | id1 | id2 | Other | <- name |
| 1494426468 | enq: VC - contention | type|mode | id1 | id2 | Other | <- name |
| 948192883 | enq: VD - contention | type|mode | id1 | id2 | Other | <- name |
| 2478141767 | enq: VE - contention | type|mode | id1 | id2 | Other | <- name |
| 1821295450 | enq: VF - contention | type|mode | id1 | id2 | Other | <- name |
| 3151153518 | enq: VG - contention | type|mode | id1 | id2 | Other | <- name |
| 2667965274 | enq: VH - contention | type|mode | id1 | id2 | Other | <- name |
| 2073979996 | enq: VI - contention | type|mode | id1 | id2 | Other | <- name |
| 3548033582 | enq: VJ - contention | type|mode | id1 | id2 | Other | <- name |
| 3854837673 | enq: VK - contention | type|mode | id1 | id2 | Other | <- name |
| 1719975306 | enq: VL - contention | type|mode | id1 | id2 | Other | <- name |
| 2388580865 | enq: VM - contention | type|mode | id1 | id2 | Other | <- name |
| 421100281 | enq: VN - contention | type|mode | id1 | id2 | Other | <- name |
| 3088969444 | enq: VO - contention | type|mode | id1 | id2 | Other | <- name |
| 2517810683 | enq: VP - contention | type|mode | id1 | id2 | Other | <- name |
| 3292945243 | enq: VQ - contention | type|mode | id1 | id2 | Other | <- name |
| 2799228463 | enq: VR - contention | type|mode | id1 | id2 | Other | <- name |
| 1184138424 | enq: VS - contention | type|mode | id1 | id2 | Other | <- name |
| 3090276998 | enq: VT - contention | type|mode | id1 | id2 | Other | <- name |
| 2565788971 | enq: VU - contention | type|mode | id1 | id2 | Other | <- name |
| 4143858120 | enq: VV - contention | type|mode | id1 | id2 | Other | <- name |
| 296128251 | enq: VX - contention | type|mode | id1 | id2 | Other | <- name |
| 4244679353 | enq: VY - contention | type|mode | id1 | id2 | Other | <- name |
| 487077473 | enq: VZ - contention | type|mode | id1 | id2 | Other | <- name |
| 6973873 | enq: EA - contention | type|mode | id1 | id2 | Other | <- name |
| 1795491474 | enq: EB - contention | type|mode | id1 | id2 | Other | <- name |
| 4060429599 | enq: EC - contention | type|mode | id1 | id2 | Other | <- name |
| 1617660300 | enq: ED - contention | type|mode | id1 | id2 | Other | <- name |
| 1236794935 | enq: EE - contention | type|mode | id1 | id2 | Other | <- name |
| 2286575608 | enq: EF - contention | type|mode | id1 | id2 | Other | <- name |
| 2645745678 | enq: EG - contention | type|mode | id1 | id2 | Other | <- name |
| 3577533227 | enq: EH - contention | type|mode | id1 | id2 | Other | <- name |
| 1285941240 | enq: EI - contention | type|mode | id1 | id2 | Other | <- name |
| 1146405468 | enq: EJ - contention | type|mode | id1 | id2 | Other | <- name |
| 3016736045 | enq: EK - contention | type|mode | id1 | id2 | Other | <- name |
| 3992761025 | enq: EL - contention | type|mode | id1 | id2 | Other | <- name |
| 2089285608 | enq: EM - contention | type|mode | id1 | id2 | Other | <- name |
| 2899227099 | enq: EN - contention | type|mode | id1 | id2 | Other | <- name |
| 88490769 | enq: EO - contention | type|mode | id1 | id2 | Other | <- name |
| 3931594708 | enq: EP - contention | type|mode | id1 | id2 | Other | <- name |
| 2541744767 | enq: EQ - contention | type|mode | id1 | id2 | Other | <- name |
| 3235986442 | enq: ER - contention | type|mode | id1 | id2 | Other | <- name |
| 1894918728 | enq: ES - contention | type|mode | id1 | id2 | Other | <- name |
| 3810509754 | enq: ET - contention | type|mode | id1 | id2 | Other | <- name |
| 3336800414 | enq: EU - contention | type|mode | id1 | id2 | Other | <- name |
| 1649381315 | enq: EV - contention | type|mode | id1 | id2 | Other | <- name |
| 1652839384 | enq: EX - contention | type|mode | id1 | id2 | Other | <- name |
| 1483837291 | enq: EY - contention | type|mode | id1 | id2 | Other | <- name |
| 2534915893 | enq: EZ - contention | type|mode | id1 | id2 | Other | <- name |
| 255555647 | enq: LA - contention | type|mode | id1 | id2 | Other | <- name |
| 923714426 | enq: LB - contention | type|mode | id1 | id2 | Other | <- name |
| 3275074137 | enq: LC - contention | type|mode | id1 | id2 | Other | <- name |
| 871599156 | enq: LD - contention | type|mode | id1 | id2 | Other | <- name |
| 2857947505 | enq: LE - contention | type|mode | id1 | id2 | Other | <- name |
| 2639284940 | enq: LF - contention | type|mode | id1 | id2 | Other | <- name |
| 834829421 | enq: LG - contention | type|mode | id1 | id2 | Other | <- name |
| 978782178 | enq: LH - contention | type|mode | id1 | id2 | Other | <- name |
| 278321110 | enq: LI - contention | type|mode | id1 | id2 | Other | <- name |
| 3300838304 | enq: LJ - contention | type|mode | id1 | id2 | Other | <- name |
| 3400360290 | enq: LK - contention | type|mode | id1 | id2 | Other | <- name |
| 2789266358 | enq: LL - contention | type|mode | id1 | id2 | Other | <- name |
| 1670662413 | enq: LM - contention | type|mode | id1 | id2 | Other | <- name |
| 1469305273 | enq: LN - contention | type|mode | id1 | id2 | Other | <- name |
| 3489117640 | enq: LO - contention | type|mode | id1 | id2 | Other | <- name |
| 3355742611 | enq: LP - contention | type|mode | id1 | id2 | Other | <- name |
| 3810098838 | enq: LQ - contention | type|mode | id1 | id2 | Other | <- name |
| 688765145 | enq: LR - contention | type|mode | id1 | id2 | Other | <- name |
| 2437279763 | enq: LS - contention | type|mode | id1 | id2 | Other | <- name |
| 1781121790 | enq: LT - contention | type|mode | id1 | id2 | Other | <- name |
| 3836307699 | enq: LU - contention | type|mode | id1 | id2 | Other | <- name |
| 1320668291 | enq: LV - contention | type|mode | id1 | id2 | Other | <- name |
| 970056814 | enq: LX - contention | type|mode | id1 | id2 | Other | <- name |
| 3540555035 | enq: LY - contention | type|mode | id1 | id2 | Other | <- name |
| 42470383 | enq: LZ - contention | type|mode | id1 | id2 | Other | <- name |
| 4141358912 | enq: YA - contention | type|mode | id1 | id2 | Other | <- name |
| 49303873 | enq: YB - contention | type|mode | id1 | id2 | Other | <- name |
| 16923067 | enq: YC - contention | type|mode | id1 | id2 | Other | <- name |
| 430723601 | enq: YD - contention | type|mode | id1 | id2 | Other | <- name |
| 2777252872 | enq: YE - contention | type|mode | id1 | id2 | Other | <- name |
| 716188495 | enq: YF - contention | type|mode | id1 | id2 | Other | <- name |
| 3273918077 | enq: YG - contention | type|mode | id1 | id2 | Other | <- name |
| 4261727606 | enq: YH - contention | type|mode | id1 | id2 | Other | <- name |
| 3900056393 | enq: YI - contention | type|mode | id1 | id2 | Other | <- name |
| 1086588912 | enq: YJ - contention | type|mode | id1 | id2 | Other | <- name |
| 1546516104 | enq: YK - contention | type|mode | id1 | id2 | Other | <- name |
| 3656843901 | enq: YL - contention | type|mode | id1 | id2 | Other | <- name |
| 1902098915 | enq: YM - contention | type|mode | id1 | id2 | Other | <- name |
| 2694944627 | enq: YN - contention | type|mode | id1 | id2 | Other | <- name |
| 3078550945 | enq: YO - contention | type|mode | id1 | id2 | Other | <- name |
| 3866696202 | enq: YP - contention | type|mode | id1 | id2 | Other | <- name |
| 1945496019 | enq: YQ - contention | type|mode | id1 | id2 | Other | <- name |
| 2349867750 | enq: YR - contention | type|mode | id1 | id2 | Other | <- name |
| 2384470175 | enq: YS - contention | type|mode | id1 | id2 | Other | <- name |
| 104199150 | enq: YT - contention | type|mode | id1 | id2 | Other | <- name |
| 1824966457 | enq: YU - contention | type|mode | id1 | id2 | Other | <- name |
| 1334630542 | enq: YV - contention | type|mode | id1 | id2 | Other | <- name |
| 222894096 | enq: YX - contention | type|mode | id1 | id2 | Other | <- name |
| 3368294287 | enq: YY - contention | type|mode | id1 | id2 | Other | <- name |
| 4162515370 | enq: YZ - contention | type|mode | id1 | id2 | Other | <- name |
| 3149857794 | enq: GA - contention | type|mode | id1 | id2 | Other | <- name |
| 707945442 | enq: GB - contention | type|mode | id1 | id2 | Other | <- name |
| 3184090883 | enq: GC - contention | type|mode | id1 | id2 | Other | <- name |
| 3010766263 | enq: GD - contention | type|mode | id1 | id2 | Other | <- name |
| 2257184003 | enq: GE - contention | type|mode | id1 | id2 | Other | <- name |
| 1470408532 | enq: GF - contention | type|mode | id1 | id2 | Other | <- name |
| 1578294037 | enq: GG - contention | type|mode | id1 | id2 | Other | <- name |
| 356161086 | enq: GH - contention | type|mode | id1 | id2 | Other | <- name |
| 2197298464 | enq: GI - contention | type|mode | id1 | id2 | Other | <- name |
| 3500533291 | enq: GJ - contention | type|mode | id1 | id2 | Other | <- name |
| 3571038774 | enq: GK - contention | type|mode | id1 | id2 | Other | <- name |
| 4115167081 | enq: GL - contention | type|mode | id1 | id2 | Other | <- name |
| 2822381649 | enq: GM - contention | type|mode | id1 | id2 | Other | <- name |
| 1932106797 | enq: GN - contention | type|mode | id1 | id2 | Other | <- name |
| 1220576703 | enq: GO - contention | type|mode | id1 | id2 | Other | <- name |
| 744993121 | enq: GP - contention | type|mode | id1 | id2 | Other | <- name |
| 2885424359 | enq: GQ - contention | type|mode | id1 | id2 | Other | <- name |
| 1692170555 | enq: GR - contention | type|mode | id1 | id2 | Other | <- name |
| 297473731 | enq: GS - contention | type|mode | id1 | id2 | Other | <- name |
| 3224017946 | enq: GT - contention | type|mode | id1 | id2 | Other | <- name |
| 2778953476 | enq: GU - contention | type|mode | id1 | id2 | Other | <- name |
| 959853025 | enq: GV - contention | type|mode | id1 | id2 | Other | <- name |
| 2865689336 | enq: GX - contention | type|mode | id1 | id2 | Other | <- name |
| 2895074916 | enq: GY - contention | type|mode | id1 | id2 | Other | <- name |
| 4024171206 | enq: GZ - contention | type|mode | id1 | id2 | Other | <- name |
| 1348917136 | enq: NA - contention | type|mode | id1 | id2 | Other | <- name |
| 3834846031 | enq: NB - contention | type|mode | id1 | id2 | Other | <- name |
| 2006236678 | enq: NC - contention | type|mode | id1 | id2 | Other | <- name |
| 1871532613 | enq: ND - contention | type|mode | id1 | id2 | Other | <- name |
| 4012219648 | enq: NE - contention | type|mode | id1 | id2 | Other | <- name |
| 3502491416 | enq: NF - contention | type|mode | id1 | id2 | Other | <- name |
| 2471192843 | enq: NG - contention | type|mode | id1 | id2 | Other | <- name |
| 1409485279 | enq: NH - contention | type|mode | id1 | id2 | Other | <- name |
| 672532181 | enq: NI - contention | type|mode | id1 | id2 | Other | <- name |
| 2473475281 | enq: NJ - contention | type|mode | id1 | id2 | Other | <- name |
| 3808553866 | enq: NK - contention | type|mode | id1 | id2 | Other | <- name |
| 1598198340 | enq: NL - contention | type|mode | id1 | id2 | Other | <- name |
| 3050419639 | enq: NM - contention | type|mode | id1 | id2 | Other | <- name |
| 1665290538 | enq: NN - contention | type|mode | id1 | id2 | Other | <- name |
| 1174794313 | enq: NO - contention | type|mode | id1 | id2 | Other | <- name |
| 2004959591 | enq: NP - contention | type|mode | id1 | id2 | Other | <- name |
| 3657424359 | enq: NQ - contention | type|mode | id1 | id2 | Other | <- name |
| 3356952131 | enq: NR - contention | type|mode | id1 | id2 | Other | <- name |
| 2192142731 | enq: NS - contention | type|mode | id1 | id2 | Other | <- name |
| 3427460944 | enq: NT - contention | type|mode | id1 | id2 | Other | <- name |
| 112223784 | enq: NU - contention | type|mode | id1 | id2 | Other | <- name |
| 4128471227 | enq: NV - contention | type|mode | id1 | id2 | Other | <- name |
| 2545284036 | enq: NX - contention | type|mode | id1 | id2 | Other | <- name |
| 1766455960 | enq: NY - contention | type|mode | id1 | id2 | Other | <- name |
| 2086756223 | enq: NZ - contention | type|mode | id1 | id2 | Other | <- name |
| 3753139397 | enq: IV - contention | type|mode | id1 | id2 | Other | <- name |
| 3937527428 | enq: TP - contention | name|mode | 0 | 0 | Other | <- name |
| 1305530676 | enq: RW - MV metadata contention | name|mode | table obj# | 0 | Other | <- name |
| 1911278064 | enq: OC - contention | name|mode | 1 | 2 | Other | <- name |
| 3443769614 | enq: OL - contention | name|mode | hash value | 0 | Other | <- name |
| 2380778435 | kkdlgon | Other | <- name | |||
| 987594289 | kkdlsipon | Other | <- name | |||
| 1604845996 | kkdlhpon | Other | <- name | |||
| 355994765 | Remote Tool Request Reply | Other | <- name | |||
| 3009035641 | Remote Tool Request Free List | Other | <- name | |||
| 3770549072 | kgltwait | Other | <- name | |||
| 3834925098 | kksfbc research | Other | <- name | |||
| 695862004 | kksscl hash split | Other | <- name | |||
| 2679325 | kksfbc child completion | Other | <- name | |||
| 325782660 | enq: CU - contention | name|mode | handle | handle | Other | <- name |
| 3963940642 | enq: AE - lock | name|mode | edition obj# | pdbuid | Other | <- name |
| 3983390698 | Revoke: get object | maximum time | amount of time | Other | <- name | |
| 2211137592 | enq: PF - contention | name|mode | 0 | 0 | Other | <- name |
| 3405015922 | enq: PZ - flush passwordfile metadata | name|mode | 0 | 0 | Other | <- name |
| 2886680154 | enq: PZ - load passwordfile metadata | name|mode | 0 | 0 | Other | <- name |
| 1682769842 | enq: IL - contention | name|mode | object # | 0 | Other | <- name |
| 1619270516 | enq: CL - drop label | name|mode | object # | 0 | Other | <- name |
| 3032662556 | enq: CL - compare labels | name|mode | object # | 0 | Other | <- name |
| 2966458487 | enq: SG - OLS Add Group | name|mode | object # | 0 | Other | <- name |
| 2242607460 | enq: SG - OLS Create Group | name|mode | object # | 0 | Other | <- name |
| 2337297337 | enq: SG - OLS Drop Group | name|mode | object # | 0 | Other | <- name |
| 2419135517 | enq: SG - OLS Alter Group Parent | name|mode | object # | 0 | Other | <- name |
| 842554107 | enq: OP - OLS Store user entries | name|mode | object # | 0 | Other | <- name |
| 4210998488 | enq: OP - OLS Cleanup unused profiles | name|mode | object # | 0 | Other | <- name |
| 2064902942 | move audit tablespace delay | Other | <- name | |||
| 1548192275 | enq: CC - decryption | name|mode | 0 | 0 | Other | <- name |
| 3559219295 | enq: MK - contention | name|mode | 0 | 0 | Other | <- name |
| 4033490427 | enq: OW - initialization | name|mode | 0 | 0 | Other | <- name |
| 964463181 | enq: OW - termination | name|mode | 0 | 0 | Other | <- name |
| 3147636141 | enq: RK - set key | name|mode | 0 | 0 | Other | <- name |
| 3379814898 | enq: RK - queue wallet and TS keys | name|mode | 0 | 0 | Other | <- name |
| 3158937066 | enq: HC - HSM cache write | name|mode | 0 | 0 | Other | <- name |
| 663631404 | enq: HC - HSM cache read | name|mode | 0 | 0 | Other | <- name |
| 2687533677 | enq: RL - RAC wallet lock | name|mode | 0 | 0 | Other | <- name |
| 4025463557 | enq: PJ - modify DV policy | name|mode | 0 | 0 | Other | <- name |
| 1522297956 | enq: PJ - read DV policy | name|mode | 0 | 0 | Other | <- name |
| 3612159796 | Row cache for Grant or Revoke | maximum time | amount of time | Other | <- name | |
| 1248642937 | enq: ZZ - update hash tables | name|mode | KSBXIC Action | 0 | Other | <- name |
| 387973045 | Failed Logon Delay | Other | <- name | |||
| 1444835457 | enq: ZA - add std audit table partition | name|mode | KZAM Aud Partition | 0 | Other | <- name |
| 2473367936 | enq: ZF - add fga audit table partition | name|mode | KZAM Fga Partition | 0 | Other | <- name |
| 4117873466 | enq: ZS - excl access to spill audit file | name|mode | Spillover audit file | 0 | Other | <- name |
| 2167287208 | enq: UT - transfer audit records | name|mode | TRANSFER AUDIT RECORDS |
0 | Other | <- name |
| 2191852259 | enq: PA - modify a privilege capture | name|mode | 0 | 0 | Other | <- name |
| 3768392460 | enq: PA - read a privilege capture | name|mode | 0 | 0 | Other | <- name |
| 3218498929 | enq: PC - update privilege capture info | name|mode | 0 | 0 | Other | <- name |
| 3478134814 | enq: PC - read privilege capture info | name|mode | 0 | 0 | Other | <- name |
| 2825881230 | enq: KZ - contention | type|mode | id1 | id2 | Other | <- name |
| 2881503609 | enq: DX - contention | name|mode | transaction entry # | 0 | Other | <- name |
| 721778600 | enq: DR - contention | name|mode | 0 | 0 | Other | <- name |
| 363664498 | pending global transaction(s) | scans | Other | <- name | ||
| 1932123989 | free global transaction table entry | tries | Other | <- name | ||
| 800384622 | library cache revalidation | Other | <- name | |||
| 1578286316 | library cache shutdown | Other | <- name | |||
| 168007407 | BFILE closure | Other | <- name | |||
| 3242184666 | BFILE check if exists | Other | <- name | |||
| 1942306413 | BFILE check if open | Other | <- name | |||
| 472769133 | BFILE get length | Other | <- name | |||
| 4198001558 | BFILE get name object | Other | <- name | |||
| 33957852 | BFILE get path object | Other | <- name | |||
| 1993008680 | BFILE open | Other | <- name | |||
| 2281626056 | BFILE internal seek | Other | <- name | |||
| 2625557633 | resmgr:internal state cleanup | location | Other | <- name | ||
| 1731053206 | xdb schema cache initialization | Other | <- name | |||
| 378175956 | ASM cluster file access | lock | mode | Other | <- name | |
| 366154626 | CSS initialization | Other | <- name | |||
| 3315172079 | CSS group registration | group_name1 | group_name2 | mem_id | Other | <- name |
| 321492953 | CSS group membership query | group_name1 | group_name2 | group_name3 | Other | <- name |
| 4255804750 | CSS operation: data query | function_id | Other | <- name | ||
| 3392052408 | CSS operation: data update | function_id | Other | <- name | ||
| 1812662268 | CSS Xgrp shared operation | function_id | Other | <- name | ||
| 1558934147 | CSS operation: query | function_id | Other | <- name | ||
| 2051030365 | CSS operation: action | function_id | Other | <- name | ||
| 2821557051 | CSS operation: diagnostic | function_id | Other | <- name | ||
| 1957973247 | GIPC operation: dump | function_id | Other | <- name | ||
| 3269846298 | GPnP Initialization | Other | <- name | |||
| 3458573322 | GPnP Termination | Other | <- name | |||
| 2801929040 | GPnP Get Item | Other | <- name | |||
| 2084604428 | GPnP Set Item | Other | <- name | |||
| 725794275 | GPnP Get Error | Other | <- name | |||
| 660190475 | ADR file lock | Other | <- name | |||
| 1780066010 | ADR block file read | Other | <- name | |||
| 4092822979 | ADR block file write | Other | <- name | |||
| 3329884903 | CRS call completion | clsrrestype | kjha_action | Other | <- name | |
| 1957311914 | ASM: OFS Cluster membership update | Other | <- name | |||
| 1720615545 | dispatcher shutdown | waited | Other | <- name | ||
| 2160405876 | latch: virtual circuit queues | address | number | why | Other | <- name |
| 2803313450 | listen endpoint status | end-point# | status | Other | <- name | |
| 3085137677 | listener registration dump | dump | Other | <- name | ||
| 3280053043 | OJVM: Generic | Other | <- name | |||
| 3225641117 | select wait | Other | <- name | |||
| 2155415449 | jobq slave shutdown wait | Other | <- name | |||
| 1039441158 | jobq slave TJ process wait | Other | <- name | |||
| 2521301688 | job scheduler coordinator slave wait | Other | <- name | |||
| 2016557033 | enq: JD - contention | name|mode | 0 | 0 | Other | <- name |
| 4077422893 | enq: JQ - contention | name|mode | 0 | 0 | Other | <- name |
| 143199788 | enq: OD - Serializing DDLs | name|mode | object # | 0 | Other | <- name |
| 3862184413 | RAC referential constraint parent lock | maximum attempts | attempt count | Other | <- name | |
| 198056240 | RAC: constraint DDL lock | maximum attempts | attempt count | Other | <- name | |
| 4264819978 | kkshgnc reloop | Other | <- name | |||
| 3412463764 | optimizer stats update retry | Other | <- name | |||
| 1586753839 | wait active processes | Other | <- name | |||
| 4042173709 | SUPLOG PL wait for inflight pragma-d PL/SQL | session_num | Other | <- name | ||
| 3735259588 | enq: MD - contention | name|mode | master object # | 0 | Other | <- name |
| 3982742587 | enq: MS - contention | name|mode | master object # | purpose | Other | <- name |
| 2191672992 | wait for kkpo ref-partitioning *TEST EVENT* | where | Other | <- name | ||
| 2212621438 | RAC reference partitioning descendants lock | maximum attempts | attempt count | Other | <- name | |
| 197381757 | enq: AP - contention | name|mode | 0 | 0 | Other | <- name |
| 3350442546 | enq: RH - quarantine | name|mode | 0 | 0 | Other | <- name |
| 4097381538 | PX slave connection | Other | <- name | |||
| 677587481 | PX slave release | Other | <- name | |||
| 624762663 | PX Send Wait | Other | <- name | |||
| 175758063 | PX qref latch | function | sleeptime | qref | Other | <- name |
| 2914763719 | PX server shutdown | nalive | sleeptime | loop | Other | <- name |
| 713547867 | PX create server | nservers | sleeptime | enqueue | Other | <- name |
| 275064659 | PX signal server | serial | error | nbusy | Other | <- name |
| 4205438796 | PX Deq: Join ACK | sleeptime/senderid | passes | Other | <- name | |
| 2019821942 | PX Deq Credit: free buffer | sleeptime/senderid | passes | qref | Other | <- name |
| 4186184097 | PX Deq: Test for msg | sleeptime/senderid | passes | Other | <- name | |
| 2485206220 | PX Deq: Test for credit | sleeptime/senderid | passes | Other | <- name | |
| 2705287540 | PX Deq: Signal ACK RSG | sleeptime/senderid | passes | Other | <- name | |
| 1974015973 | PX Deq: Signal ACK EXT | sleeptime/senderid | passes | Other | <- name | |
| 146029171 | PX Deq: reap credit | Other | <- name | |||
| 4195961226 | PX Nsq: PQ descriptor query | Other | <- name | |||
| 1721932125 | PX Nsq: PQ load info query | Other | <- name | |||
| 55053127 | PX Deq Credit: Session Stats | sleeptime/senderid | passes | Other | <- name | |
| 2306891574 | PX Deq: Slave Session Stats | sleeptime/senderid | passes | Other | <- name | |
| 1826399205 | PX Deq: Slave Join Frag | sleeptime/senderid | passes | Other | <- name | |
| 2143046196 | enq: PI - contention | name|mode | operation | serial # | Other | <- name |
| 2071012023 | enq: PS - contention | name|mode | instance | slave ID | Other | <- name |
| 3187918539 | enq: DA - Slave Process Array | name|mode | 0 | 0 | Other | <- name |
| 676951513 | latch: parallel query alloc buffer | address | number | why | Other | <- name |
| 2176755381 | kxfxse | kxfxse debug wait: stalling for slave 0 |
Other | <- name | ||
| 789727252 | kxfxsp | kxfxsp debug wait: stalling for slave 0 |
Other | <- name | ||
| 2049127157 | PX Deq: Table Q qref | sleeptime/senderid | passes | Other | <- name | |
| 4068211615 | PX Deq: Table Q Get Keys | sleeptime/senderid | passes | Other | <- name | |
| 2044715771 | PX Deq: Table Q Close | sleeptime/senderid | passes | Other | <- name | |
| 1944760014 | GV$: slave acquisition retry wait time | Other | <- name | |||
| 265138948 | PX hash elem being inserted | hashid | element | insert/update | Other | <- name |
| 2185396738 | latch: PX hash array latch | address | number | why | Other | <- name |
| 3076848514 | enq: AY - contention | name|mode | Op1 | Op2 | Other | <- name |
| 3701540314 | enq: TO - contention | name|mode | object # | 1 | Other | <- name |
| 3003716442 | enq: ZP - Private Temporary Table | name|mode | sess# | ser# | Other | <- name |
| 210464158 | IMCDT end of scans cleanup | session id | Other | <- name | ||
| 2239268215 | enq: IT - contention | name|mode | object # | 0 | Other | <- name |
| 2212717019 | enq: BF - allocation contention | name|mode | node#/parallelizer# | bloom# | Other | <- name |
| 2476632936 | enq: BF - PMON Join Filter cleanup | name|mode | node#/parallelizer# | bloom# | Other | <- name |
| 3612504684 | enq: RD - RAC load | name|mode | sqlid | execid | Other | <- name |
| 720590657 | PX key vector flatten | sleeptime | passes | Other | <- name | |
| 2134054793 | PX hash key vector cell | sleeptime | passes | Other | <- name | |
| 3088459204 | PX hash key vector merge | sleeptime | passes | Other | <- name | |
| 227324969 | PX key vector use load | sleeptime | passes | Other | <- name | |
| 1640694188 | PX key vector create dgk init | sleeptime | passes | Other | <- name | |
| 1677991500 | enq: MG - MGA allocation | name|mode | qcserial# | rowsource#/mgacode# | Other | <- name |
| 4252762903 | enq: MG - client shared context allocation | name|mode | qcserial# | rowsource#/mgacode# | Other | <- name |
| 4172720392 | timer in sksawat | Other | <- name | |||
| 148348926 | scginq AST call | Other | <- name | |||
| 3632212035 | kupp process wait | Other | <- name | |||
| 1677898746 | Kupp process shutdown | nalive | sleeptime | loop | Other | <- name |
| 1618891965 | Data Pump slave startup | Other | <- name | |||
| 1990104190 | Data Pump slave init | Other | <- name | |||
| 4149771879 | enq: KP - contention | name|mode | 0 | 0 | Other | <- name |
| 62357398 | Replication Dequeue | sleeptime/senderid | passes | Other | <- name | |
| 171343339 | knpc_acwm_AwaitChangedWaterMark | Other | <- name | |||
| 68404501 | knpc_anq_AwaitNonemptyQueue | Other | <- name | |||
| 2722071092 | knpsmai | Other | <- name | |||
| 3056899600 | enq: SR - contention | name|mode | operation | sequence # / apply # |
Other | <- name |
| 1695560430 | enq: RG - Apply coord start/stop | name|mode | 0 | 0 | Other | <- name |
| 2065856153 | REPL Capture/Apply: database startup | 2=>GoldenGate 1=>XStream 0=>Streams |
Other | <- name | ||
| 2721331920 | REPL Capture/Apply: miscellaneous | 2=>GoldenGate 1=>XStream 0=>Streams |
TYPE | Other | <- name | |
| 3398735787 | enq: SI - contention | name|mode | object # | 0 | Other | <- name |
| 1864425273 | REPL Capture/Apply: RAC inter-instance ack | 2=>GoldenGate 1=>XStream 0=>Streams |
Other | <- name | ||
| 2673474179 | enq: IA - contention | name|mode | 0 | 0 | Other | <- name |
| 2959147725 | enq: JI - contention | name|mode | view object # | 0 | Other | <- name |
| 2379543324 | qerex_gdml | Other | <- name | |||
| 545059663 | enq: AT - contention | name|mode | 0 | 0 | Other | <- name |
| 3227435068 | Retry DB Audit Record Insertion Delay | Other | <- name | |||
| 2694900870 | opishd | Other | <- name | |||
| 2339167892 | secure protocol error delay | Other | <- name | |||
| 3714800175 | kpodplck wait before retrying ORA-54 | Other | <- name | |||
| 4187088707 | enq: CQ - contention | name|mode | 0 | 0 | Other | <- name |
| 256518009 | wait for EMON to spawn | Other | <- name | |||
| 2145388 | EMON termination | Other | <- name | |||
| 3606851176 | enq: AZ - AQ_SRVNTFN_Q Creation | name|mode | 0 | 0 | Other | <- name |
| 2204104508 | Emon coordinator startup | Other | <- name | |||
| 3429311972 | enq: SE - contention | name|mode | Session-id | Serial# | Other | <- name |
| 4191886805 | tsm with timeout | Other | <- name | |||
| 475650147 | Streams AQ: waiting for busy instance for instance_name | where | wait_count | Other | <- name | |
| 360694399 | Streams AQ: index block pin/row lock | Other | Other | <- name | ||
| 1371132976 | enq: TQ - TM contention | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other | <- name |
| 717240345 | enq: TQ - DDL contention | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other | <- name |
| 451597502 | enq: TQ - INI contention | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other | <- name |
| 3544909312 | enq: TQ - DDL-INI contention | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other | <- name |
| 2485099792 | enq: TQ - INI sq contention | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other | <- name |
| 2161466780 | enq: TQ - MC free sync at cross job start | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other | <- name |
| 3940406592 | enq: TQ - MC free sync at cross job stop | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other | <- name |
| 3556092800 | enq: TQ - MC free sync at cross job end | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other | <- name |
| 1806788557 | enq: TQ - MC free sync at export subshard | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other | <- name |
| 414829123 | enq: TQ - create eviction table | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other | <- name |
| 1253896331 | enq: TQ - TM Job cache initialization | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other | <- name |
| 851010114 | enq: TQ - TM Job cache use | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other | <- name |
| 140858203 | enq: TQ - sq TM contention | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other | <- name |
| 1778940434 | enq: TQ - LB drop volatile shard | name|mode | QT_OBJ# | Other=>0 pdbOpen=>1 | Other | <- name |
| 184877469 | AQ reload SO release | Other | <- name | |||
| 1604858083 | enq: RQ - Enqueue commit uncached | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 3085538108 | enq: RQ - Enqueue commit cached | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 2919324227 | enq: RQ - Dequeue update scn | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 865607805 | enq: RQ - Parallel cross update scn | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 3441381857 | enq: RQ - Cross update scn | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 2880690823 | enq: RQ - Trucate subshard | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 3170569805 | enq: RQ - Cross export subshard | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 1369383293 | enq: RQ - Cross import subshard | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 1413769130 | enq: RQ - Free shadow shard | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 3015178340 | enq: RQ - AQ indexed cached commit | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 2216156465 | enq: RQ - AQ uncached commit WM update | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 1097722103 | enq: RQ - AQ uncached dequeue | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 2303995540 | enq: RQ - AQ Eq Ptn Mapping | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 880236959 | enq: RQ - AQ Dq Ptn Mapping | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 3508179254 | enq: RQ - AQ Trnc mem free | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 732656061 | enq: RQ - AQ Trnc mem free remote | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 2182291775 | enq: RQ - AQ Trnc mem free by LB | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 2158440508 | enq: RQ - AQ Trnc mem free by CP | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 2511032739 | enq: RQ - AQ Enq commit incarnation wrap | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 992085483 | enq: RQ - AQ Rule evaluation segment load | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 3549861016 | enq: RQ - AQ Evict: block truncate | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 263001462 | enq: RQ - AQ Unevict PGA: setup subscriber | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 1533122454 | enq: RQ - AQ Unevict PGA: Queue View | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 3768201353 | enq: RQ - AQ Shid Gen | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 1316606076 | enq: RQ - AQ Enq commit block truncate | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 2034753927 | enq: RQ - AQ Cross update scn for delay | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 995822741 | enq: RQ - AQ Cross Shard mem free | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 623563369 | enq: RQ - AQ rollback retry count update | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 2906438445 | enq: RQ - AQ cached commit WM update | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 2832768511 | enq: RQ - AQ cached dequeue by condition | name|mode | Q_OBJ# | shard:mode | Other | <- name |
| 2877960639 | AQ propagation connection | Other | <- name | |||
| 8998880 | enq: KR - Drop rule force | name|mode | R_OBJ# | 0 | Other | <- name |
| 3809944109 | enq: KR - Add rule to ruleset | name|mode | R_OBJ# | 0 | Other | <- name |
| 1527114466 | enq: KR - Remove rule from ruleset | name|mode | R_OBJ# | 0 | Other | <- name |
| 1150705222 | enq: DP - contention | name|mode | 0 | 0 | Other | <- name |
| 798324601 | enq: MH - contention | name|mode | 0 | 0 | Other | <- name |
| 4174613831 | enq: ML - contention | name|mode | 0 | 0 | Other | <- name |
| 148033462 | enq: PH - contention | name|mode | 0 | 0 | Other | <- name |
| 3322341088 | enq: SF - contention | name|mode | 0 | 0 | Other | <- name |
| 3111555168 | enq: XH - contention | name|mode | 0 | 0 | Other | <- name |
| 3791087697 | enq: WA - contention | name|mode | 0 | 0 | Other | <- name |
| 2512310275 | Streams AQ: QueueTable kgl locks | Other | <- name | |||
| 1444745059 | AQ spill debug idle | Other | <- name | |||
| 1036481366 | AQ master shutdown | Other | <- name | |||
| 1719027518 | AQPC: new master | Other | <- name | |||
| 521075289 | AQ Background Master: slave start | Other | <- name | |||
| 217236789 | enq: AQ - QPT fg map dqpt | name|mode | QT_OBJ# | 0 | Other | <- name |
| 2886730684 | enq: AQ - QPT fg map qpt | name|mode | QT_OBJ# | 0 | Other | <- name |
| 4020471302 | enq: PQ - QPT add qpt | name|mode | QT_OBJ# | 0 | Other | <- name |
| 588884722 | enq: PQ - QPT drop qpt | name|mode | QT_OBJ# | 0 | Other | <- name |
| 555943052 | enq: PQ - QPT add dqpt | name|mode | QT_OBJ# | 0 | Other | <- name |
| 3301195157 | enq: PQ - QPT drop dqpt | name|mode | QT_OBJ# | 0 | Other | <- name |
| 1959042520 | enq: PQ - QPT add qpt fg | name|mode | QT_OBJ# | 0 | Other | <- name |
| 3836089153 | enq: PQ - QPT add dqpt fg | name|mode | QT_OBJ# | 0 | Other | <- name |
| 861646821 | enq: PQ - QPT Trunc | name|mode | QT_OBJ# | 0 | Other | <- name |
| 2920134246 | enq: PQ - QPT LB Trunc sync | name|mode | QT_OBJ# | 0 | Other | <- name |
| 441889315 | enq: PQ - QPT XSTART Trunc sync | name|mode | QT_OBJ# | 0 | Other | <- name |
| 1492596895 | AQ master: time mgmt/task cleanup | Other | <- name | |||
| 51933697 | AQ slave: time mgmt/task cleanup | Other | <- name | |||
| 4071093774 | enq: BA - SUBBMAP contention | name|mode | 0 | 0 | Other | <- name |
| 2421053357 | AQ:non durable subscriber add or drop | Other | <- name | |||
| 2363885740 | AQ: RAC AQ Network | Other | <- name | |||
| 93406953 | latch: AQ Sharded subscriber statistics latch | address | number | why | Other | <- name |
| 1465038546 | AQ OPT Operation Complete | subshard | skiplist | Other | <- name | |
| 2371292690 | latch: AQ OPT Background Master Latch | address | number | why | Other | <- name |
| 4107448082 | enq: CX - TEXT: Index Specific Lock | name|mode | Index Id | Partition Id | Other | <- name |
| 389396261 | enq: OT - TEXT: Generic Lock | name|mode | 0 | 0 | Other | <- name |
| 1110641933 | XDB SGA initialization | Other | <- name | |||
| 300221745 | enq: XC - XDB Configuration | name|mode | Other | <- name | ||
| 1255252648 | NFS read delegation outstanding | delegation count | Other | <- name | ||
| 4100251918 | Data Guard Broker Wait | Broker Component | Wait Argument 1 | Wait Argument 2 | Other | <- name |
| 2609577957 | enq: RF - synch: DG Broker metadata | name|mode | lock operation | lock value | Other | <- name |
| 3779250430 | enq: RF - atomicity | name|mode | lock operation | lock value | Other | <- name |
| 1367687622 | enq: RF - Broker Chief Lock | name|mode | lock operation | lock value | Other | <- name |
| 770131870 | enq: RF - synchronization: aifo master | name|mode | lock operation | lock value | Other | <- name |
| 1283852695 | enq: RF - new AI | name|mode | lock operation | lock value | Other | <- name |
| 3573752690 | enq: RF - synchronization: critical ai | name|mode | lock operation | lock value | Other | <- name |
| 1173618054 | enq: RF - RF - Database Automatic Disable | name|mode | lock operation | lock value | Other | <- name |
| 1422251130 | enq: RF - FSFO Observer Heartbeat | name|mode | lock operation | lock value | Other | <- name |
| 2735020950 | enq: RF - DG Broker Current File ID | name|mode | lock operation | lock value | Other | <- name |
| 2311929058 | enq: RF - FSFO Primary Shutdown suspended | name|mode | lock operation | lock value | Other | <- name |
| 3754864244 | enq: RF - Broker State Lock | name|mode | lock operation | lock value | Other | <- name |
| 3053910820 | enq: RF - FSFO string buffer | name|mode | lock operation | lock value | Other | <- name |
| 2069842805 | enq: RF - Broker NSV Lock | name|mode | lock operation | lock value | Other | <- name |
| 1285804450 | enq: RF - Broker LSBY FO Lock | name|mode | lock operation | lock value | Other | <- name |
| 687406475 | PX Deq: OLAP Update Reply | sleeptime/senderid | passes | Other | <- name | |
| 2722627124 | PX Deq: OLAP Update Execute | sleeptime/senderid | passes | Other | <- name | |
| 3949837646 | PX Deq: OLAP Update Close | sleeptime/senderid | passes | Other | <- name | |
| 3728184289 | enq: AW - AW$ table lock | name|mode | operation | workspace # | Other | <- name |
| 2438512004 | enq: AW - AW state lock | name|mode | operation | workspace # | Other | <- name |
| 541043045 | enq: AW - user access for AW | name|mode | operation | workspace # | Other | <- name |
| 2247828282 | enq: AW - AW generation lock | name|mode | operation | workspace # | Other | <- name |
| 2009316128 | enq: AG - contention | name|mode | workspace # | generation | Other | <- name |
| 2454416615 | enq: AO - contention | name|mode | workspace # | object # | Other | <- name |
| 523388040 | enq: OQ - xsoqhiAlloc | name|mode | resource id | 0 | Other | <- name |
| 3682185722 | enq: OQ - xsoqhiFlush | name|mode | resource id | 0 | Other | <- name |
| 681553729 | enq: OQ - xsoq*histrecb | name|mode | resource id | 0 | Other | <- name |
| 2148426979 | enq: OQ - xsoqhiClose | name|mode | resource id | 0 | Other | <- name |
| 4194119705 | enq: OQ - xsoqhistrecb | name|mode | resource id | 0 | Other | <- name |
| 1170604220 | enq: IZ - contention | type|mode | id1 | id2 | Other | <- name |
| 409056071 | enq: AM - client registration | name|mode | id1 | id2 | Other | <- name |
| 4003623979 | enq: AM - shutdown | name|mode | id1 | id2 | Other | <- name |
| 3718305 | enq: AM - rollback COD reservation | name|mode | id1 | id2 | Other | <- name |
| 2163538166 | enq: AM - background COD reservation | name|mode | id1 | id2 | Other | <- name |
| 2512559650 | enq: AM - ASM cache freeze | name|mode | id1 | id2 | Other | <- name |
| 1784903832 | enq: AM - ASM ACD Relocation | name|mode | id1 | id2 | Other | <- name |
| 3865222969 | enq: AM - group use | name|mode | id1 | id2 | Other | <- name |
| 2069926448 | enq: AM - group block | name|mode | id1 | id2 | Other | <- name |
| 827631834 | enq: AM - ASM File Destroy | name|mode | id1 | id2 | Other | <- name |
| 1369527695 | enq: AM - ASM User | name|mode | id1 | id2 | Other | <- name |
| 1010353447 | enq: AM - ASM Password File Update | name|mode | id1 | id2 | Other | <- name |
| 2754586444 | enq: AM - ASM Amdu Dump | name|mode | id1 | id2 | Other | <- name |
| 1111439585 | enq: AM - disk offline | name|mode | id1 | id2 | Other | <- name |
| 1454769910 | enq: AM - ASM reserved | name|mode | id1 | id2 | Other | <- name |
| 279744402 | enq: AM - block repair | name|mode | id1 | id2 | Other | <- name |
| 3396428008 | enq: AM - ASM disk based alloc/dealloc | name|mode | id1 | id2 | Other | <- name |
| 3160612488 | enq: AM - ASM file descriptor | name|mode | id1 | id2 | Other | <- name |
| 92719042 | enq: AM - ASM file relocation | name|mode | id1 | id2 | Other | <- name |
| 2483622550 | enq: AM - ASM SR relocation | name|mode | id1 | id2 | Other | <- name |
| 1063667893 | enq: AM - ASM Grow ACD | name|mode | id1 | id2 | Other | <- name |
| 3837655383 | enq: AM - ASM DD update SrRloc | name|mode | id1 | id2 | Other | <- name |
| 4169101203 | enq: AM - ASM file chown | name|mode | id1 | id2 | Other | <- name |
| 2601059080 | enq: AM - Register with IOServer | name|mode | id1 | id2 | Other | <- name |
| 699477076 | enq: AM - ASM metadata replication | name|mode | id1 | id2 | Other | <- name |
| 985067372 | enq: AM - SR slice Clear/Mark | name|mode | id1 | id2 | Other | <- name |
| 3556433611 | enq: AM - Enable Remote ASM | name|mode | id1 | id2 | Other | <- name |
| 442057748 | enq: AM - Disable Remote ASM | name|mode | id1 | id2 | Other | <- name |
| 4095213098 | enq: AM - Credential creation | name|mode | id1 | id2 | Other | <- name |
| 1623955356 | enq: AM - Credential deletion | name|mode | id1 | id2 | Other | <- name |
| 2677727449 | enq: AM - ASM file access req | name|mode | id1 | id2 | Other | <- name |
| 64802329 | enq: AM - ASM client operation | name|mode | id1 | id2 | Other | <- name |
| 2358860044 | enq: AM - ASM client check | name|mode | id1 | id2 | Other | <- name |
| 1675121924 | enq: AM - ASM ATB COD creation | name|mode | id1 | id2 | Other | <- name |
| 3472725730 | enq: AM - Create default DG key in OCR | name|mode | id1 | id2 | Other | <- name |
| 2680210812 | enq: AM - ASM Audit file Delete | name|mode | id1 | id2 | Other | <- name |
| 2479275509 | enq: AM - ASM Audit file Cleanup | name|mode | id1 | id2 | Other | <- name |
| 2073560035 | enq: AM - ASM VAT migration | name|mode | id1 | id2 | Other | <- name |
| 1975769604 | enq: AM - Update SR nomark flag | name|mode | id1 | id2 | Other | <- name |
| 1591602342 | enq: AM - ASM VAL cache | name|mode | id1 | id2 | Other | <- name |
| 3793499008 | enq: AM - ASM SR Segment Reuse | name|mode | id1 | id2 | Other | <- name |
| 250443378 | enq: AM - ASM SR Segment Reuse Lookup | name|mode | id1 | id2 | Other | <- name |
| 537017889 | enq: AM - ASM SR Batch Allocation | name|mode | id1 | id2 | Other | <- name |
| 1134572957 | enq: AM - ASM Sparse Disk IOCTL | name|mode | id1 | id2 | Other | <- name |
| 1654589745 | enq: AM - ASM VAM Active | name|mode | id1 | id2 | Other | <- name |
| 3363174857 | enq: AM - ASM Split Mirror File Create | name|mode | id1 | id2 | Other | <- name |
| 2694311567 | enq: AM - ASM Split Mirror File Delete | name|mode | id1 | id2 | Other | <- name |
| 2896300204 | enq: AM - ASM Mirror Prepare | name|mode | id1 | id2 | Other | <- name |
| 3154205335 | enq: AM - ASM Mirror Split | name|mode | id1 | id2 | Other | <- name |
| 305997448 | enq: AM - ASM Drop Mirror | name|mode | id1 | id2 | Other | <- name |
| 1949526317 | enq: AM - ASM PDB Mirror Split | name|mode | id1 | id2 | Other | <- name |
| 3578425710 | enq: AM - DB Mirror Prepare | name|mode | id1 | id2 | Other | <- name |
| 621703965 | enq: AM - DB Drop Mirror Copy | name|mode | id1 | id2 | Other | <- name |
| 2893418612 | enq: AM - DB Mirror Split | name|mode | id1 | id2 | Other | <- name |
| 1758319559 | enq: AM - PDB Mirror Split | name|mode | id1 | id2 | Other | <- name |
| 2320430895 | enq: AM - Create Prepare Child file group | name|mode | id1 | id2 | Other | <- name |
| 716767539 | enq: AM - Change file group redundancy | name|mode | id1 | id2 | Other | <- name |
| 525190891 | enq: AM - ASM Split Mirror ODM File Crt | name|mode | id1 | id2 | Other | <- name |
| 2345780184 | enq: AM - ASM Split Mirror ODM File Del | name|mode | id1 | id2 | Other | <- name |
| 2488686235 | enq: AM - ASMB Startup | name|mode | id1 | id2 | Other | <- name |
| 3410638104 | enq: AM - ASMB Renew | name|mode | id1 | id2 | Other | <- name |
| 294867266 | enq: AM - ASM: group unblock | name|mode | id1 | id2 | Other | <- name |
| 1743182406 | enq: AM - ASM file create | name|mode | id1 | id2 | Other | <- name |
| 1956883892 | enq: AM - ASM ATE conversion | name|mode | id1 | id2 | Other | <- name |
| 3446354675 | enq: AM - ASM resync from ATE | name|mode | id1 | id2 | Other | <- name |
| 3550195952 | enq: AM - ASM Split Status Write | name|mode | id1 | id2 | Other | <- name |
| 4245020571 | enq: AM - ASM Split Status Read | name|mode | id1 | id2 | Other | <- name |
| 1314989500 | enq: AM - ASM Client Assisted Offline | name|mode | id1 | id2 | Other | <- name |
| 143193948 | enq: AM - ASM Client Assisted Offline Chk | name|mode | id1 | id2 | Other | <- name |
| 1209620185 | ASM internal hang test | test # | Other | <- name | ||
| 1458436774 | ASM Instance startup | Other | <- name | |||
| 2251737163 | buffer busy | group# | obj# | block# | Other | <- name |
| 3520118347 | buffer freelistbusy | group# | obj# | block# | Other | <- name |
| 4196750963 | buffer rememberlist busy | group# | obj# | block# | Other | <- name |
| 539980354 | buffer writeList full | group# | obj# | block# | Other | <- name |
| 3607843151 | no free buffers | group# | obj# | block# | Other | <- name |
| 1188005821 | buffer write wait | group# | obj# | block# | Other | <- name |
| 1339059840 | buffer invalidation wait | group# | obj# | block# | Other | <- name |
| 3809103184 | buffer dirty disabled | group# | Other | <- name | ||
| 3227373516 | ASM metadata cache frozen | group# | obj# | block# | Other | <- name |
| 3006239876 | enq: FZ - contention | type|mode | id1 | id2 | Other | <- name |
| 4186342174 | enq: CM - gate | name|mode | disk group # | type | Other | <- name |
| 3394651275 | enq: CM - instance | name|mode | disk group # | type | Other | <- name |
| 3457552864 | enq: CM - diskgroup dismount | name|mode | disk group # | type | Other | <- name |
| 3051305468 | enq: XQ - recovery | name|mode | disk group # | unused | Other | <- name |
| 1688174401 | enq: XQ - relocation | name|mode | disk group # | unused | Other | <- name |
| 3970804539 | enq: XQ - purification | name|mode | disk group # | unused | Other | <- name |
| 2345563243 | enq: AD - allocate AU | name|mode | group and disk number | AU number | Other | <- name |
| 143335296 | enq: AD - deallocate AU | name|mode | group and disk number | AU number | Other | <- name |
| 2372793991 | enq: AD - relocate AU | name|mode | group and disk number | AU number | Other | <- name |
| 2627023149 | enq: AD - flush writes to AU | name|mode | group and disk number | AU number | Other | <- name |
| 1035436594 | enq: DO - disk online | name|mode | disk group # | disk # | Other | <- name |
| 3543159936 | enq: DO - disk online recovery | name|mode | disk group # | disk # | Other | <- name |
| 3796486218 | enq: DO - Staleness Registry create | name|mode | disk group # | disk # | Other | <- name |
| 1190657481 | enq: DO - startup of MARK process | name|mode | disk group # | disk # | Other | <- name |
| 2314060976 | extent map load/unlock | group | file | extent | Other | <- name |
| 3108652202 | extent map locked | mid | Other | <- name | ||
| 187881552 | enq: XL - fault extent map | name|mode | map id | nothing | Other | <- name |
| 1759761944 | Sync ASM rebalance | Other | <- name | |||
| 1532208117 | Sync ASM discovery | Other | <- name | |||
| 177573324 | File Directory Use | Other | <- name | |||
| 685231043 | enq: DG - contention | name|mode | disk group | type | Other | <- name |
| 3688395675 | enq: DD - contention | name|mode | disk group | type | Other | <- name |
| 4039922119 | enq: HD - contention | name|mode | disk group | 0 | Other | <- name |
| 996118641 | enq: DQ - contention | type|mode | id1 | id2 | Other | <- name |
| 2749567914 | ASM ioctl to dematerialize blocks | OSS FD | where | timeout | Other | <- name |
| 2043768807 | enq: DN - contention | name|mode | 0 | 0 | Other | <- name |
| 895023593 | Cluster stabilization wait | Other | <- name | |||
| 1575986328 | Cluster Suspension wait | Other | <- name | |||
| 3861676729 | ASMB cookie valid check | Other | <- name | |||
| 2662459136 | ASM background starting | Other | <- name | |||
| 1187368726 | CSS cookie check | Other | <- name | |||
| 2985320524 | ASM db client exists | Other | <- name | |||
| 3967390525 | ASM file metadata operation | msgop | locn | Other | <- name | |
| 2340849898 | ASM network foreground exits | group# | Other | <- name | ||
| 3684153710 | ASM check disk slices | group# | Other | <- name | ||
| 1565536645 | enq: XB - contention | type|mode | id1 | id2 | Other | <- name |
| 3182712926 | enq: FA - access file | name|mode | disk group number | file number | Other | <- name |
| 2145403328 | enq: RX - relocate extent | name|mode | disk group #:file # | virtual extent number |
Other | <- name |
| 3415870113 | enq: RX - unlock extent | name|mode | disk group #:file # | virtual extent number |
Other | <- name |
| 1530586040 | enq: AR - contention | type|mode | id1 | id2 | Other | <- name |
| 2210429417 | enq: AH - contention | type|mode | id1 | id2 | Other | <- name |
| 3902700176 | log write(odd) | group# | Other | <- name | ||
| 1156678023 | log write(even) | group# | Other | <- name | ||
| 2188655897 | checkpoint advanced | group# | Other | <- name | ||
| 1893664477 | enq: FR - contention | name|mode | disk group | thread | Other | <- name |
| 3144887602 | enq: FR - use the thread | name|mode | disk group | thread | Other | <- name |
| 2085113153 | enq: FR - recover the thread | name|mode | disk group | thread | Other | <- name |
| 1457820412 | enq: FG - serialize ACD relocate | name|mode | disk group | type | Other | <- name |
| 903153076 | enq: FG - FG redo generation enq race | name|mode | disk group | type | Other | <- name |
| 3282679649 | enq: FG - LGWR redo generation enq race | name|mode | disk group | type | Other | <- name |
| 4166969980 | enq: FT - allow LGWR writes | name|mode | disk group | thread | Other | <- name |
| 3784147810 | enq: FT - disable LGWR writes | name|mode | disk group | thread | Other | <- name |
| 1342373550 | enq: FC - open an ACD thread | name|mode | disk group | thread | Other | <- name |
| 4041110320 | enq: FC - recover an ACD thread | name|mode | disk group | thread | Other | <- name |
| 642072527 | enq: FX - issue ACD Xtnt Relocation CIC | name|mode | disk group | unused | Other | <- name |
| 1290945549 | rollback operations block full | max operations | Other | <- name | ||
| 3090342480 | rollback operations active | operation count | Other | <- name | ||
| 11871430 | enq: RB - contention | name|mode | disk group | 0 | Other | <- name |
| 2388386205 | ASM: MARK subscribe to msg channel | Other | <- name | |||
| 356559202 | ASM: Send msg to MARK | group# | dginc | Other | <- name | |
| 1863410699 | IOS client reconnect to dif IOS | Other | <- name | |||
| 2796523246 | enq: II - contention | type|mode | id1 | id2 | Other | <- name |
| 2402091651 | enq: IK - contention | type|mode | id1 | id2 | Other | <- name |
| 3763393154 | IOS worker process startup | process type | process number | Other | <- name | |
| 2169926259 | IOS worker process exit | process type | process number | Other | <- name | |
| 2526851348 | call | action | Other | <- name | ||
| 1149393865 | enq: IC - IOServer clientID | name|mode | client id | none | Other | <- name |
| 2190180976 | enq: IF - file open | name|mode | client id/group num | File number | Other | <- name |
| 143253470 | enq: IF - file close | name|mode | client id/group num | File number | Other | <- name |
| 1698021162 | enq: PT - contention | name|mode | disk group # | type | Other | <- name |
| 1341347015 | enq: PT - ASM Storage May Split | name|mode | disk group # | type | Other | <- name |
| 4005116367 | enq: PM - contention | type|mode | id1 | id2 | Other | <- name |
| 1675551899 | ASM concurrent diskgroup dismount | Other | <- name | |||
| 1641349801 | ASM PST operation | op | Other | <- name | ||
| 165998259 | global cache busy | group | file# | block# | Other | <- name |
| 1178367029 | lock release pending | group | file# | block# | Other | <- name |
| 768347202 | dma prepare busy | group | obj# | block# | Other | <- name |
| 882942043 | GCS lock cancel | le | Other | <- name | ||
| 1614997189 | GCS lock open S | group | obj# | block# | Other | <- name |
| 2914709075 | GCS lock open X | group | obj# | block# | Other | <- name |
| 2319975598 | GCS lock open | group | obj# | block# | Other | <- name |
| 4196128727 | GCS lock cvt S | group | obj# | block# | Other | <- name |
| 1477609608 | GCS lock cvt X | group | obj# | block# | Other | <- name |
| 526018501 | GCS lock esc X | group | obj# | block# | Other | <- name |
| 3407862862 | GCS lock esc | group | obj# | block# | Other | <- name |
| 3438313554 | GCS recovery lock open | group | obj# | block# | Other | <- name |
| 3795772310 | GCS recovery lock convert | group | obj# | block# | Other | <- name |
| 2200249458 | kfcl: instance recovery | group | obj# | block# | Other | <- name |
| 1446952136 | no free locks | Other | <- name | |||
| 3946320739 | lock close | group | lms# | Other | <- name | |
| 4237717925 | enq: KE - contention | type|mode | id1 | id2 | Other | <- name |
| 3738539678 | enq: KQ - access ASM attribute | name|mode | group | entry | Other | <- name |
| 3252202162 | ASM Volume Background | Other | <- name | |||
| 1040863550 | ASM volume directive send | msgop | dg | vol | Other | <- name |
| 1113408825 | ASM Volume Resource Action | Other | <- name | |||
| 1869608638 | enq: AV - persistent DG number | name|mode | persistent DG number | non-DG number enqs | Other | <- name |
| 3917752439 | enq: AV - volume relocate | name|mode | persistent DG number | non-DG number enqs | Other | <- name |
| 1293149770 | enq: AV - AVD client registration | name|mode | persistent DG number | non-DG number enqs | Other | <- name |
| 845350487 | enq: AV - add/enable first volume in DG | name|mode | persistent DG number | non-DG number enqs | Other | <- name |
| 2067455519 | ASM Scrubbing I/O | blkno | bytes | filetype | Other | <- name |
| 1981525493 | ASM Async Scrub | Other | <- name | |||
| 1128811488 | ASM Scrub Stop | Other | <- name | |||
| 1140319009 | ASM Scrub Running | Other | <- name | |||
| 4059731982 | ASM: VAM activation | group# | Other | <- name | ||
| 594948517 | DB Split Delay | Other | <- name | |||
| 1641438405 | enq: WF - contention | name|mode | 0 | 0 | Other | <- name |
| 1872744606 | enq: WT - contention | name|mode | 0 | 0 | Other | <- name |
| 2389341073 | enq: WP - contention | name|mode | 0 | 0 | Other | <- name |
| 2941830639 | enq: FU - contention | name|mode | 0 | 0 | Other | <- name |
| 2821914527 | enq: UF - undo stat flush per PDB | name|mode | 0 | 0 | Other | <- name |
| 3539930272 | enq: WI - AWR import | name|mode | 0 | 0 | Other | <- name |
| 1743780004 | enq: WE - AWR auto-export | name|mode | 0 | 0 | Other | <- name |
| 2716218059 | enq: WD - AWR mail package retrieval | name|mode | 0 | 0 | Other | <- name |
| 2288329625 | AWR Flush | Other | <- name | |||
| 2618836277 | AWR Metric Capture | Other | <- name | |||
| 3315745697 | enq: TB - SQL Tuning Base Cache Update | name|mode | 1 | 2 | Other | <- name |
| 2878002362 | enq: TB - SQL Tuning Base Cache Load | name|mode | 1 | 2 | Other | <- name |
| 3691188946 | enq: SH - contention | name|mode | 0 | 0 | Other | <- name |
| 955173113 | enq: AF - task serialization | name|mode | task id | 0 | Other | <- name |
| 761672870 | MMON slave messages | Other | <- name | |||
| 3694317464 | MMON (Lite) shutdown | process# | waited | Other | <- name | |
| 3932123875 | enq: MO - contention | name|mode | 0 | 0 | Other | <- name |
| 4246084819 | enq: MM - MMON Autotask scheduling | name|mode | 0 | 0 | Other | <- name |
| 2407027636 | enq: TL - contention | name|mode | 0 | 0 | Other | <- name |
| 3243557671 | enq: TH - metric threshold evaluation | name|mode | 0 | 0 | Other | <- name |
| 917975477 | enq: TK - Auto Task Serialization | name|mode | 0-MMON, 1-MMON Slave | 0 | Other | <- name |
| 1739764420 | enq: TK - Auto Task Slave Lockout | name|mode | 0-MMON, 1-MMON Slave | 0 | Other | <- name |
| 2152050500 | enq: RR - contention | name|mode | lock# | not used | Other | <- name |
| 1171942730 | WCR: RAC message context busy | Other | <- name | |||
| 1692125788 | WCR: capture file IO write | Other | <- name | |||
| 2064810505 | WCR: Sync context busy | Other | <- name | |||
| 339324686 | latch: WCR: sync | address | number | why | Other | <- name |
| 1606818110 | latch: WCR: processes HT | address | number | why | Other | <- name |
| 3397007672 | enq: RA - RT ADDM flood control | name|mode | 0 | 0 | Other | <- name |
| 3384888932 | enq: MW - contention | name|mode | Schedule Id | 0 | Other | <- name |
| 1964249173 | enq: TU - UMF topology | name|mode | 0 | 0 | Other | <- name |
| 3857332111 | SPA slave messages | Other | <- name | |||
| 6961751 | enq: JS - job run lock - synchronize | name|mode | service ID | queue type | Other | <- name |
| 1043516589 | enq: JS - job recov lock | name|mode | service ID | queue type | Other | <- name |
| 3418411601 | enq: JS - wdw op | name|mode | service ID | queue type | Other | <- name |
| 3478457902 | enq: JS - evt notify | name|mode | service ID | queue type | Other | <- name |
| 903782161 | enq: JS - aq sync | name|mode | service ID | queue type | Other | <- name |
| 1946447820 | enq: JG - queue lock | name|mode | service ID | queue type | Other | <- name |
| 4268683640 | enq: JG - q mem clnup lck | name|mode | service ID | queue type | Other | <- name |
| 3206939239 | enq: JG - contention | name|mode | service ID | queue type | Other | <- name |
| 4137510178 | enq: JG - sch locl enqs | name|mode | service ID | queue type | Other | <- name |
| 561979420 | enq: JG - evt notify | name|mode | service ID | queue type | Other | <- name |
| 3768795743 | enq: JG - evtsub add | name|mode | service ID | queue type | Other | <- name |
| 3926916813 | enq: JG - evtsub drop | name|mode | service ID | queue type | Other | <- name |
| 1953322323 | enq: AU - ADR Purge Operation | name|mode | 0 | 0 | Other | <- name |
| 3791535926 | enq: XD - ASM disk drop/add | name|mode | opcode | notused | Other | <- name |
| 3849855823 | enq: XD - ASM disk ONLINE | name|mode | opcode | notused | Other | <- name |
| 1707790998 | enq: XD - ASM disk OFFLINE | name|mode | opcode | notused | Other | <- name |
| 1178543798 | cell worker online completion | cellhash# | Other | <- name | ||
| 799178018 | cell worker retry | cellhash# | Other | <- name | ||
| 3247799346 | cell manager cancel work request | Other | <- name | |||
| 3295957859 | cell manager: CRS DG unmounted list | Other | <- name | |||
| 4128858080 | cell manager: CRS DG start | Other | <- name | |||
| 3539423858 | opening cell offload device | cellhash# | Other | <- name | ||
| 3591236115 | ioctl to cell offload device | cellhash# | Other | <- name | ||
| 3649276447 | reap block level offload operations | slowcellhash# | Other | <- name | ||
| 1625602236 | enq: SN - PDB SGA allocation | name|mode | pdbid | 0 | Other | <- name |
| 1423149423 | enq: SN - PDB SGA free | name|mode | pdbid | 0 | Other | <- name |
| 3660194637 | enq: SN - PDB SGA protection | name|mode | pdbid | 0 | Other | <- name |
| 3137068004 | CDB: Per Instance Query for PDB Info | Other | <- name | |||
| 4266840842 | PDB relocate completion | pdbid | Other | <- name | ||
| 2667320203 | enq: PB - PDB Lock | name|mode | 0 | type | Other | <- name |
| 1664976218 | chunk move metadata prefetch | Other | <- name | |||
| 3014224958 | secondary event | event # | wait time | Other | <- name |
Keine Kommentare:
Kommentar veröffentlichen