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