2020-06-08

V$EVENT_NAME

This post is a simple content of V$EVENT_NAME as of 19.7. 
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: