待機イベント一覧

12cR2までの待機ベント一覧です。
・P1~P3は待機イベントの補足情報でV$SESSION_WAITやV$ACTIVE_SESSION_HISTORY(10g~)を問い合わせることでそのタイミングの補足情報を確認することができます。
・wait classは待機イベントの分類を表します。
・バージョン間でP1~P3の値が変更されたものは重複表示されます。



 version:  class:
versionnamep1p2p3class
12cR2-12cR2ADG instance recovery completeOther
12cR2-12cR2ADG query scn advanceOther
12cR2-12cR2ADG switchover completionpdbidOther
11gR2-12cR2ADR block file readOther
11gR2-12cR2ADR block file writeOther
11gR2-12cR2ADR file lockOther
12cR1-12cR2AQ Background Master: slave startOther
12cR1-12cR2AQ Cross Master idleIdle
10gR1-10gR1AQ Deallocate WaitConfiguration
12cR2-12cR2AQ OPT Operation CompletesubshardskiplistOther
10gR1-10gR1AQ Proxy Cleanup WaitIdle
12cR1-12cR2AQ master shutdownOther
12cR1-12cR2AQ master: time mgmt/task cleanupOther
11gR1-12cR2AQ propagation connectionOther
12cR1-12cR2AQ reload SO releaseOther
12cR1-12cR2AQ slave: time mgmt/task cleanupOther
11gR2-12cR2AQ spill debug idleOther
12cR1-12cR2AQ: 12c message cache init waitIdle
12cR2-12cR2AQ: RAC AQ NetworkOther
12cR1-12cR2AQ:non durable subscriber add or dropOther
12cR1-12cR2AQPC idleIdle
12cR1-12cR2AQPC: new masterOther
12cR1-12cR2ARCH Remote WriteOther
9i-11gR1ARCH random i/oSystem I/O
9i-11gR1ARCH sequential i/oSystem I/O
10gR1-12cR1ARCH wait for archivelog lockOther
10gR1-12cR2ARCH wait for flow-controlNetwork
10gR1-12cR2ARCH wait for net re-connectNetwork
10gR1-12cR2ARCH wait for netserver detachNetwork
10gR1-11gR1ARCH wait for netserver init 1Network
10gR1-12cR2ARCH wait for netserver init 2Network
10gR1-12cR2ARCH wait for netserver startNetwork
10gR1-10gR2ARCH wait for pending I/OsSystem I/O
10gR1-12cR2ARCH wait for process death 1Other
10gR1-11gR1ARCH wait for process death 2Other
10gR1-11gR1ARCH wait for process death 3Other
10gR1-11gR1ARCH wait for process death 4Other
10gR1-11gR1ARCH wait for process death 5Other
10gR1-12cR2ARCH wait for process start 1Other
10gR1-11gR1ARCH wait for process start 2Other
10gR1-12cR2ARCH wait for process start 3Other
10gR1-11gR1ARCH wait for process start 4Other
9i-11gR2ARCH wait on ATTACHNetwork
9i-11gR2ARCH wait on DETACHNetwork
9i-11gR2ARCH wait on SENDREQNetwork
10gR1-12cR2ARCH wait on c/f tx acquire 1Other
10gR1-11gR1ARCH wait on c/f tx acquire 2Other
12cR2-12cR2ASM Async ScrubOther
10gR2-12cR2ASM COD rollback operation completiondismount forceAdministrative
11gR2-12cR1ASM DG UnblockOther
11gR2-12cR2ASM Fixed Package I/OblknobytesfiletypeUser I/O
11gR2-12cR2ASM Instance startupOther
12cR1-12cR2ASM PST operationopOther
10gR1-12cR2ASM PST query : wait for [PM][grp][0] grantCluster
12cR2-12cR2ASM Scrub StopOther
12cR1-12cR2ASM Scrubbing I/OblknobytesfiletypeOther
11gR2-12cR2ASM Staleness File I/Oblkno#blksdisknoUser I/O
11gR1-12cR2ASM Volume BackgroundOther
12cR1-12cR2ASM Volume Resource ActionOther
12cR1-12cR2ASM async relocation I/OcountwherefileSystem I/O
10gR1-11gR1ASM background runningOther
10gR1-12cR2ASM background startingOther
10gR1-12cR2ASM background timerIdle
12cR2-12cR2ASM check disk slicesgroup#Other
11gR2-12cR2ASM cluster file accesslockmodeOther
12cR2-12cR2ASM cluster membership changesIdle
12cR2-12cR2ASM concurrent diskgroup dismountOther
10gR1-12cR2ASM db client existsOther
11gR1-12cR2ASM file metadata operationmsgoplocnOther
10gR2-12cR2ASM internal hang testtest #Other
11gR1-12cR2ASM metadata cache frozengroup#Other
10gR1-12cR2ASM mount : wait for heartbeatAdministrative
11gR1-12cR2ASM network foreground exitsgroup#Other
12cR1-12cR2ASM remote SQLNetwork
12cR1-12cR2ASM sync cache disk readgroupobjblockUser I/O
12cR1-12cR2ASM sync relocation I/OcountwherefileSystem I/O
12cR1-12cR2ASM volume directive sendmsgopdgvolOther
11gR2-12cR2ASM: MARK subscribe to msg channelOther
11gR1-12cR2ASM: OFS Cluster membership updateOther
12cR1-12cR2ASM: Send msg to MARKgroup#dgincOther
12cR1-12cR2ASYNC Remote WriteOther
10gR2-12cR2AWR FlushOther
10gR2-12cR2AWR Metric CaptureOther
12cR2-12cR2Analyze hash compareOther
11gR2-12cR2Archive Manager file transfer I/OcountintrtimeoutUser I/O
11gR1-12cR2Archiver slave I/Owait countwait flagstimeoutSystem I/O
11gR2-12cR2Auto BMR RPC standby catchupwrapbaseOther
11gR2-12cR2Auto BMR completionfile#block#Other
12cR1-12cR1Availability Machine container I/OrequestsOther
12cR1-12cR1Availability Machine container synchronous readblock#blocksOther
12cR1-12cR1Availability Machine container synchronous writeblock#blocksOther
12cR2-12cR2BA: Performance APIAdministrative
8i-12cR2BFILE check if existsOther
8i-12cR2BFILE check if openOther
8i-12cR2BFILE closureOther
8i-12cR2BFILE get lengthOther
8i-12cR2BFILE get name objectOther
8i-12cR2BFILE get path objectOther
8i-12cR2BFILE internal seekOther
8i-12cR2BFILE openOther
8i-12cR2BFILE readUser I/O
12cR2-12cR2Backup Appliance Comm SGA setup waitsession_idserialIdle
12cR2-12cR2Backup Appliance Servlet waitsession_idserialIdle
12cR2-12cR2Backup Appliance Surrogate waitsession_idserialIdle
12cR2-12cR2Backup Appliance container I/OrequestsOther
12cR2-12cR2Backup Appliance container synchronous readblock#blocksOther
12cR2-12cR2Backup Appliance container synchronous writeblock#blocksOther
12cR2-12cR2Backup Appliance waiting for worksession_idserialIdle
12cR2-12cR2Backup Appliance waiting restore startsession_idserialIdle
11gR2-12cR1Backup Restore Event 19778 sleepsession_idserialOther
12cR2-12cR2Backup Restore Event sleepsession_idserialOther
11gR2-12cR2Backup Restore Switch Bitmap sleepsession_idserialOther
11gR2-12cR2Backup Restore Throttle sleepsession_idserialOther
11gR2-12cR2Backup: MML command to channelAdministrative
11gR2-12cR2Backup: MML commit backup pieceAdministrative
11gR2-12cR2Backup: MML create a backup pieceAdministrative
11gR2-12cR2Backup: MML data movement done?Administrative
11gR2-12cR2Backup: MML datafile proxy backup?Administrative
11gR2-12cR2Backup: MML datafile proxy restore?Administrative
11gR2-12cR2Backup: MML delete backup pieceAdministrative
11gR2-12cR2Backup: MML extended initializationAdministrative
11gR2-12cR2Backup: MML get base addressAdministrative
11gR2-12cR2Backup: MML initializationAdministrative
11gR2-12cR2Backup: MML obtain a direct bufferAdministrative
11gR2-12cR2Backup: MML obtain textual errorAdministrative
11gR2-12cR2Backup: MML proxy cancelAdministrative
11gR2-12cR2Backup: MML proxy commit backup pieceAdministrative
11gR2-12cR2Backup: MML proxy initialize backupAdministrative
11gR2-12cR2Backup: MML proxy initialize restoreAdministrative
11gR2-12cR2Backup: MML proxy prepare to startAdministrative
11gR2-12cR2Backup: MML proxy session endAdministrative
11gR2-12cR2Backup: MML proxy start data movementAdministrative
11gR2-12cR2Backup: MML query backup pieceAdministrative
11gR2-12cR2Backup: MML query for direct buffersAdministrative
11gR2-12cR2Backup: MML read backup pieceAdministrative
11gR2-12cR2Backup: MML release a direct bufferAdministrative
11gR2-12cR2Backup: MML restore backup pieceAdministrative
11gR2-12cR2Backup: MML shutdownAdministrative
11gR2-12cR2Backup: MML v1 close backup pieceAdministrative
11gR2-12cR2Backup: MML v1 delete backup pieceAdministrative
11gR2-12cR2Backup: MML v1 open backup pieceAdministrative
11gR2-12cR2Backup: MML v1 query backup pieceAdministrative
11gR2-12cR2Backup: MML v1 read backup pieceAdministrative
11gR2-12cR2Backup: MML v1 write backup pieceAdministrative
11gR2-12cR2Backup: MML write backup pieceAdministrative
10gR1-11gR1Backup: sbtbackupAdministrative
11gR1-11gR1Backup: sbtbufinfoAdministrative
10gR1-11gR1Backup: sbtcloseAdministrative
10gR1-11gR1Backup: sbtclose2Administrative
10gR1-11gR1Backup: sbtcommandAdministrative
10gR1-11gR1Backup: sbtendAdministrative
10gR1-11gR1Backup: sbterrorAdministrative
11gR1-11gR1Backup: sbtgetbufAdministrative
10gR1-11gR1Backup: sbtinfoAdministrative
10gR1-11gR1Backup: sbtinfo2Administrative
10gR1-11gR1Backup: sbtinitAdministrative
10gR1-11gR1Backup: sbtinit2Administrative
11gR1-11gR1Backup: sbtmapbufAdministrative
10gR1-11gR1Backup: sbtopenAdministrative
10gR1-11gR1Backup: sbtpcbackupAdministrative
10gR1-11gR1Backup: sbtpccancelAdministrative
10gR1-11gR1Backup: sbtpccommitAdministrative
10gR1-11gR1Backup: sbtpcendAdministrative
10gR1-11gR1Backup: sbtpcquerybackupAdministrative
10gR1-11gR1Backup: sbtpcqueryrestoreAdministrative
10gR1-11gR1Backup: sbtpcrestoreAdministrative
10gR1-11gR1Backup: sbtpcstartAdministrative
10gR1-11gR1Backup: sbtpcstatusAdministrative
10gR1-11gR1Backup: sbtpcvalidateAdministrative
10gR1-11gR1Backup: sbtreadAdministrative
10gR1-11gR1Backup: sbtread2Administrative
11gR1-11gR1Backup: sbtrelbufAdministrative
10gR1-11gR1Backup: sbtremoveAdministrative
10gR1-11gR1Backup: sbtremove2Administrative
10gR1-11gR1Backup: sbtrestoreAdministrative
10gR1-11gR1Backup: sbtwriteAdministrative
10gR1-11gR1Backup: sbtwrite2Administrative
12cR1-12cR2CDB: Per Instance Query for PDB InfoOther
12cR2-12cR2CGS ping operationlocationOther
9i-12cR2CGS skgxn join retryretry countOther
9i-12cR2CGS wait for IPC msgOther
11gR2-12cR2CRS call completionclsrrestypekjha_actionOther
11gR2-12cR2CSS Xgrp shared operationfunction_idOther
11gR2-12cR2CSS group membership querygroup_name1group_name2group_name3Other
11gR2-12cR2CSS group registrationgroup_name1group_name2mem_idOther
11gR2-12cR2CSS initializationOther
11gR2-12cR2CSS operation: actionfunction_idOther
11gR2-12cR2CSS operation: data queryfunction_idOther
11gR2-12cR2CSS operation: data updatefunction_idOther
11gR2-12cR2CSS operation: diagnosticfunction_idOther
11gR2-12cR2CSS operation: queryfunction_idOther
11gR2-12cR2CTWR media recovery checkpoint requestOther
8i-8iCache simulator heap
12cR1-12cR2Clonedb bitmap file writeblknosizeSystem I/O
10gR1-12cR2Cluster Suspension waitOther
11gR1-12cR2Cluster stabilization waitOther
10gR1-10gR2Cluster stablization waitOther
11gR2-12cR2Compression analysisOther
8i-8iContacting SCN server or SCN lock master
12cR2-12cR2Cube Build Master Wait for JobsConcurrency
10gR1-11gR1DBFG waiting for replyOther
10gR1-12cR2DBMS_LDAP: LDAP operationOther
12cR1-12cR2DBMS_ROLLING instruction completionInstruction idOther
11gR1-12cR2DBWR range invalidation syncdbwr#Other
11gR1-12cR2DBWR slave I/Owait countwait flagstimeoutSystem I/O
8i-12cR2DFS db file lockfile#Other
8i-12cR2DFS lock handletype|modeid1id2Other
10gR2-12cR2DG Broker configuration file I/OcountintrtimeoutUser I/O
9i-9iDIAG dummy wait
10gR1-12cR2DIAG idle waitcomponentwherewait time(millisec)Idle
12cR1-12cR1DIAG lock acquisitionOther
12cR2-12cR2DIAG lock acquisitionwhereOther
12cR1-12cR2DLM Omni Enq Owner replicationOwner IDOther
12cR1-12cR2DLM cross inst call completioncaller instance numbercluster incarnation numberrequest identifierOther
12cR1-12cR2DLM enqueue copy completionOwner IDop|restypeid1|id2Other
8i-8iDLM generic wait event
10gR1-10gR1DLM lock cancelleOther
10gR1-10gR1DLM lock cvt Sgroupobj#block#Other
10gR1-10gR1DLM lock cvt Xgroupobj#block#Other
10gR1-10gR1DLM lock escgroupobj#block#Other
10gR1-10gR1DLM lock esc Xgroupobj#block#Other
10gR1-10gR1DLM lock opengroupobj#block#Other
10gR1-10gR1DLM lock open Sgroupobj#block#Other
10gR1-10gR1DLM lock open Xgroupobj#block#Other
10gR1-10gR1DLM recovery lock convertgroupobj#block#Other
10gR1-10gR1DLM recovery lock opengroupobj#block#Other
12cR1-12cR2DLM: shared instance mode initOther
12cR2-12cR2DNFS disp IO slave cleanupclmn pnumOther
12cR2-12cR2DNFS disp IO slave completionpnumUser I/O
12cR2-12cR2DNFS disp IO slave idleIdle
12cR1-12cR2DSKM to complete cell health checkOther
11gR1-12cR2Data Guard Broker WaitBroker ComponentWait Argument 1Wait Argument 2Other
10gR2-10gR2Data Guard broker: single instanceData Guard broker: single instanceOther
10gR1-10gR2Data Guard broker: wait upon ORA-12850 errorwaiting for retrying the query to mask ORA-12850 errorOther
12cR2-12cR2Data Guard network buffer stall reapNetwork
12cR1-12cR2Data Guard server operation completionOther
12cR2-12cR2Data Guard: Gap ManagerIdle
12cR1-12cR2Data Guard: RFS disk I/OOther
12cR2-12cR2Data Guard: TimerIdle
12cR2-12cR2Data Guard: controlfile updateIdle
10gR2-12cR2Data Guard: process clean upOther
10gR2-12cR2Data Guard: process exitOther
12cR2-12cR2Data Guard: rtrt workOther
11gR2-12cR2Data Pump slave initOther
11gR2-12cR2Data Pump slave startupOther
10gR2-12cR2Data file init writecountintrtimeoutUser I/O
10gR2-12cR2Datapump dump file I/OcountintrtimeoutUser I/O
11gR2-12cR2Disk file I/O CalibrationcountUser I/O
11gR2-12cR2Disk file Mirror ReadfilenoblknofiletypeUser I/O
11gR2-12cR2Disk file Mirror/Media Repair WritefilenoblknofiletypeUser I/O
11gR2-12cR2Disk file operations I/OFileOperationfilenofiletypeUser I/O
10gR2-10gR2EMON idle waitIdle
11gR1-12cR2EMON slave idle waitIdle
11gR1-11gR2EMON slave messagesOther
11gR1-12cR2EMON terminationOther
12cR1-12cR2Emon coordinator main loopIdle
12cR1-12cR2Emon coordinator startupOther
12cR1-12cR2Emon slave main loopIdle
11gR2-12cR1External Procedure callApplication
12cR2-12cR2External Procedure callHS_SESSION_IDApplication
11gR2-12cR2External Procedure initial connectionApplication
10gR2-12cR2FAL archive wait 1 sec for REOPEN minimumOther
12cR2-12cR2Failed Logon DelayOther
12cR1-12cR2File CopycountintrtimeoutUser I/O
12cR2-12cR2File Repopulation Writefilename_hashblknoSystem I/O
10gR1-10gR1Flow Control EventOther
12cR2-12cR2GCR CSS group joinretry countOther
12cR2-12cR2GCR CSS group leaveOther
12cR2-12cR2GCR CSS group lockOther
12cR2-12cR2GCR CSS group queryOther
12cR2-12cR2GCR CSS group updateOther
12cR1-12cR1GCR CSS join retryretry countOther
12cR1-12cR2GCR ctx lock acquisitionretry countOther
12cR1-12cR1GCR lock acquisitionOther
12cR1-12cR1GCR member Data from CSSretry countOther
12cR1-12cR1GCR sleeplock retry countIdle
12cR2-12cR2GCR sleepIdle
10gR2-12cR2GCS lock cancelleOther
10gR2-12cR2GCS lock cvt Sgroupobj#block#Other
10gR2-12cR2GCS lock cvt Xgroupobj#block#Other
10gR2-12cR2GCS lock escgroupobj#block#Other
10gR2-12cR2GCS lock esc Xgroupobj#block#Other
10gR2-12cR2GCS lock opengroupobj#block#Other
10gR2-12cR2GCS lock open Sgroupobj#block#Other
10gR2-12cR2GCS lock open Xgroupobj#block#Other
10gR2-12cR2GCS recovery lock convertgroupobj#block#Other
10gR2-12cR2GCS recovery lock opengroupobj#block#Other
11gR2-12cR2GIPC operation: dumpfunction_idOther
12cR2-12cR2GL: cross instance latch freeOther
11gR2-12cR2GPnP Get ErrorOther
11gR2-12cR2GPnP Get ItemOther
11gR2-12cR2GPnP InitializationOther
11gR2-12cR2GPnP Set ItemOther
11gR2-12cR2GPnP TerminationOther
10gR1-12cR2GV$: slave acquisition retry wait timeOther
11gR1-12cR2Global transaction acquire instance locksretriesConfiguration
9i-12cR2HS message to agentIdle
12cR2-12cR2IM ADO scheduler retryOther
12cR2-12cR2IM CU busyOther
12cR2-12cR2IM FastStart deadlock retryOther
12cR2-12cR2IM buffer busyConcurrency
12cR2-12cR2IM buffer busy SHRConcurrency
12cR2-12cR2IM buffer busy TXNConcurrency
12cR2-12cR2IM populate completionOther
12cR2-12cR2IMFS Flush defer writesOther
12cR2-12cR2IMFS defer writes schedulerIdle
11gR2-12cR2IMR CSS join retryretry countOther
11gR2-12cR2IMR disk votesOther
11gR2-12cR2IMR membership resolutionOther
11gR2-12cR2IMR mount phase II completionOther
11gR2-12cR2IMR net-check message ackOther
11gR2-12cR2IMR rr lock releaseOther
11gR2-12cR2IMR rr updateOther
12cR2-12cR2IMR slave acknowledgement msgOther
12cR2-12cR2IMR slave process initOther
12cR2-12cR2IMR slave process shutdownlocationOther
8i-8iIO clients wait for LMON to join GMS group
11gR1-12cR2IORM Scheduler Slave Idle WaitIdle
12cR2-12cR2IOS client reconnect to dif IOSOther
12cR2-12cR2IOS worker process exitprocess typeprocess numberOther
12cR2-12cR2IOS worker process startupprocess typeprocess numberOther
9i-12cR2IPC busy async requestOther
9i-12cR2IPC send completion syncsend countOther
9i-12cR2IPC wait for name service busyOther
9i-12cR2IPC waiting for OSD resourcesOther
12cR1-12cR2Image redo gen delayOther
12cR2-12cR2In-Memory populate: over pga limitprocess numberserial numberOther
12cR2-12cR2Inmemory Populate: get loadscnConcurrency
12cR2-12cR2JAVA patchingOther
11gR1-12cR2JOX Jit Process SleepIdle
10gR1-12cR2JS coord start waitOther
10gR1-12cR2JS external jobIdle
10gR1-12cR2JS kgl get object waitOther
10gR1-12cR2JS kill job waitOther
12cR2-12cR2KA: shared KGA not initializedOther
9i-9iKJC: Wait for msg sends to complete
10gR1-12cR2KJC: Wait for msg sends to completemsgdest|rcvrmtypeOther
8i-8iKSIM GDS request cancel
10gR1-11gR2KSV master waitIdle
12cR1-12cR2KSV master waitindicatorOther
10gR1-12cR2Kupp process shutdownnalivesleeptimeloopOther
9i-12cR2L1 validationseghdrl1bmbOther
12cR2-12cR2LCK0 row cache object freeheap dsmin_sizeclatchConcurrency
11gR2-12cR2LGWR ORL/NoExp FAL archivalOther
12cR1-12cR2LGWR all worker groupsOther
12cR1-12cR2LGWR any worker groupOther
12cR1-12cR2LGWR intra group IO completionwheregroupidslaveidOther
12cR1-12cR2LGWR intra group syncwheregroupidslaveidOther
9i-11gR1LGWR random i/oSystem I/O
11gR2-12cR2LGWR real time apply syncIdle
9i-11gR1LGWR sequential i/oSystem I/O
9i-12cR2LGWR simulation latency waitOther
11gR1-12cR2LGWR slave I/Owait countwait flagstimeoutSystem I/O
8i-12cR2LGWR wait for redo copycopy latch #Other
9i-11gR2LGWR wait on ATTACHNetwork
9i-11gR2LGWR wait on DETACHNetwork
9i-12cR2LGWR wait on LNSNetwork
9i-11gR2LGWR wait on SENDREQNetwork
9i-11gR1LGWR wait on full LNS bufferOther
12cR1-12cR2LGWR worker group idlegroup_idslave_idIdle
12cR1-12cR2LGWR worker group orderinglwn_idphaseOther
9i-12cR2LGWR-LNS wait on channelOther
10gR2-12cR2LMON global data updateOther
8i-8iLMON wait for LMD to inherit communication channels
12cR2-12cR2LMS CR slave timertypeIdle
10gR2-12cR2LNS ASYNC archive logIdle
10gR2-11gR1LNS ASYNC control file txnSystem I/O
10gR2-12cR2LNS ASYNC dest activationIdle
10gR2-12cR2LNS ASYNC end of logIdle
9i-12cR2LNS simulation latency waitOther
9i-11gR1LNS wait for LGWR redoOther
9i-11gR2LNS wait on ATTACHNetwork
9i-11gR2LNS wait on DETACHNetwork
9i-12cR2LNS wait on LGWRNetwork
9i-11gR2LNS wait on SENDREQNetwork
10gR2-12cR2Log archive I/OcountintrtimeoutSystem I/O
10gR2-12cR2Log file init writecountintrtimeoutUser I/O
12cR2-12cR2LogMiner FSC: dictionary load completionSession IDOther
11gR2-12cR2LogMiner builder: DDLSession IDQueueing
11gR2-12cR2LogMiner builder: branchSession IDIdle
11gR2-12cR2LogMiner builder: idleSession IDIdle
11gR2-12cR2LogMiner builder: memorySession IDQueueing
11gR2-12cR2LogMiner client: transactionSession IDIdle
11gR2-12cR2LogMiner preparer: idleSession IDIdle
11gR2-12cR2LogMiner preparer: memorySession IDQueueing
11gR2-12cR2LogMiner reader: bufferSession IDQueueing
11gR2-12cR2LogMiner reader: log (idle)Session IDThreadSequenceIdle
11gR2-12cR2LogMiner reader: redo (idle)Session IDThreadSequenceIdle
11gR2-12cR2LogMiner: activateSession IDIdle
11gR1-11gR1LogMiner: builder idleSession IDIdle
10gR2-10gR2LogMiner: client waiting for transactionIdle
11gR1-11gR1LogMiner: client waiting for transactionSession IDIdle
11gR2-12cR2LogMiner: find sessionSession IDIdle
11gR1-11gR1LogMiner: generic process sleepCaller IDIdle
11gR2-12cR2LogMiner: internalCaller IDIdle
11gR2-12cR2LogMiner: otherSession IDIdle
11gR1-11gR1LogMiner: preparer idleSession IDIdle
11gR1-11gR1LogMiner: reader idleSession IDIdle
10gR2-11gR1LogMiner: reader waiting for more redoSession IDThreadSequenceIdle
11gR2-12cR2LogMiner: resetCaller IDIdle
10gR2-10gR2LogMiner: slave waiting for activate messageIdle
11gR1-11gR1LogMiner: slave waiting for activate messageSession IDIdle
11gR1-11gR1LogMiner: waiting for processes to soft detachCaller IDIdle
11gR1-11gR1LogMiner: waiting for redo from new branchOther
11gR1-11gR1LogMiner: waiting for session to become visibleOther
10gR2-10gR2LogMiner: wakeup event for builderIdle
10gR2-10gR2LogMiner: wakeup event for preparerIdle
10gR2-10gR2LogMiner: wakeup event for readerIdle
11gR1-12cR2Logical Standby Apply DelayIdle
10gR2-12cR2Logical Standby Apply shutdownOther
11gR1-12cR2Logical Standby DebugeventOther
10gR2-12cR2Logical Standby Terminal ApplystageOther
10gR2-12cR2Logical Standby dictionary buildOther
10gR2-12cR2Logical Standby pin transactionxidusnxidsltxidsqnOther
10gR1-12cR2MMON (Lite) shutdownprocess#waitedOther
10gR1-12cR2MMON slave messagesOther
12cR1-12cR2MRP inactivationOther
11gR1-12cR2MRP redo arrivalIdle
12cR1-12cR1MRP state inspectionOther
12cR2-12cR2MRP stopOther
12cR1-12cR1MRP terminationOther
10gR1-12cR2MRP wait on archivelog archivalOther
10gR1-12cR2MRP wait on archivelog arrivalOther
10gR1-11gR2MRP wait on archivelog delayOther
10gR1-11gR2MRP wait on process deathOther
10gR1-12cR2MRP wait on process restartOther
10gR1-12cR2MRP wait on process startOther
10gR1-12cR2MRP wait on startup clearOther
10gR1-11gR2MRP wait on state changeOther
10gR1-11gR2MRP wait on state n_aOther
10gR1-11gR2MRP wait on state resetOther
12cR2-12cR2Monitor testingOther
11gR1-12cR2NFS read delegation outstandingdelegation countOther
11gR1-12cR2Network file transfercountintrtimeoutSystem I/O
12cR2-12cR2Nonlogged block fetchAbsolute fileStart blockRequest numberOther
8i-8iNull event
12cR2-12cR2OFS Receive QueueIdle
12cR1-12cR2OFS idleIdle
12cR2-12cR2OFS interrupted req not foundOther
12cR1-12cR2OFS operation completionAdministrative
11gR2-12cR2OJVM: GenericOther
10gR1-12cR1OLAP Aggregate Client Deqsleeptime/senderidpassesOther
10gR1-12cR1OLAP Aggregate Client Enqsleeptime/senderidpassesOther
10gR1-12cR1OLAP Aggregate Master Deqsleeptime/senderidpassesOther
10gR1-12cR1OLAP Aggregate Master Enqsleeptime/senderidpassesOther
11gR1-12cR2OLAP DML SleepdurationApplication
10gR1-12cR1OLAP Null PQ Reasonsleeptime/senderidpassesOther
10gR1-12cR1OLAP Parallel Temp Grewsleeptime/senderidpassesOther
10gR1-12cR1OLAP Parallel Temp Grow Requestsleeptime/senderidpassesOther
10gR1-12cR1OLAP Parallel Temp Grow Waitsleeptime/senderidpassesOther
10gR1-12cR1OLAP Parallel Type Deqsleeptime/senderidpassesOther
12cR1-12cR1ORS: Performance APIAdministrative
11gR1-12cR2OSD IPC libraryrolling migOther
12cR2-12cR2PCFC: recovery domain validOther
12cR2-12cR2PDB close abort completionOther
12cR2-12cR2PDB lock domain invalidationOther
12cR2-12cR2PDB relocate completionpdbidOther
12cR2-12cR2PGA memory operationOther
11gR1-12cR2PINGIdle
8i-12cR2PL/SQL lock timerdurationIdle
11gR1-12cR2PMON to cleanup detached branches at shutdownOther
10gR2-12cR2PMON to cleanup pseudo-branches at svc stop timeOther
11gR1-12cR2PX Deq Credit: Session Statssleeptime/senderidpassesOther
8i-12cR2PX Deq Credit: free buffersleeptime/senderidpassesqrefOther
8i-12cR2PX Deq Credit: need buffersleeptime/senderidpassesqrefIdle
8i-12cR2PX Deq Credit: send blkdsleeptime/senderidpassesqrefOther
8i-12cR2PX Deq: Execute Replysleeptime/senderidpassesIdle
8i-12cR2PX Deq: Execution Msgsleeptime/senderidpassesIdle
8i-12cR2PX Deq: Index Merge Closesleeptime/senderidpassesIdle
8i-12cR2PX Deq: Index Merge Executesleeptime/senderidpassesIdle
8i-12cR2PX Deq: Index Merge Replysleeptime/senderidpassesIdle
8i-12cR2PX Deq: Join ACKsleeptime/senderidpassesOther
11gR2-12cR2PX Deq: Metadata Updatektelc_wait1sIdle
8i-12cR2PX Deq: Msg Fragmentsleeptime/senderidpassesIdle
9i-12cR2PX Deq: OLAP Update Closesleeptime/senderidpassesOther
9i-12cR2PX Deq: OLAP Update Executesleeptime/senderidpassesOther
9i-12cR2PX Deq: OLAP Update Replysleeptime/senderidpassesOther
8i-10gR2PX Deq: Par Recov Change Vectorsleeptime/senderidpassesIdle
8i-10gR2PX Deq: Par Recov Executesleeptime/senderidpassesIdle
8i-10gR2PX Deq: Par Recov Replysleeptime/senderidpassesIdle
8i-12cR2PX Deq: Parse Replysleeptime/senderidpassesIdle
8i-10gR2PX Deq: Signal ACKsleeptime/senderidpassesOther
11gR1-12cR2PX Deq: Signal ACK EXTsleeptime/senderidpassesOther
11gR1-12cR2PX Deq: Signal ACK RSGsleeptime/senderidpassesOther
11gR1-12cR2PX Deq: Slave Join Fragsleeptime/senderidpassesOther
11gR1-12cR2PX Deq: Slave Session Statssleeptime/senderidpassesOther
8i-12cR2PX Deq: Table Q Closesleeptime/senderidpassesOther
8i-12cR2PX Deq: Table Q Get Keyssleeptime/senderidpassesOther
8i-12cR2PX Deq: Table Q Normalsleeptime/senderidpassesIdle
8i-12cR2PX Deq: Table Q Samplesleeptime/senderidpassesIdle
8i-12cR2PX Deq: Table Q qrefsleeptime/senderidpassesOther
11gR1-12cR2PX Deq: Test for creditsleeptime/senderidpassesOther
8i-12cR2PX Deq: Test for msgsleeptime/senderidpassesOther
8i-12cR2PX Deq: Txn Recovery Replysleeptime/senderidpassesIdle
8i-12cR2PX Deq: Txn Recovery Startsleeptime/senderidpassesIdle
10gR1-12cR2PX Deq: kdcph_maikdcph_maiIdle
10gR1-12cR2PX Deq: kdcphc_ackkdcphc_ackIdle
9i-12cR2PX Deq: reap creditOther
8i-12cR2PX Deque waitsleeptime/senderidpassesIdle
8i-12cR2PX Idle Waitsleeptime/senderidpassesIdle
9i-12cR2PX Nsq: PQ descriptor queryOther
9i-12cR2PX Nsq: PQ load info queryOther
11gR2-12cR2PX Queuing: statement queuesleeptimepassesScheduler
9i-12cR2PX Send WaitOther
8i-12cR2PX create servernserverssleeptimeenqueueOther
11gR2-12cR2PX hash elem being insertedhashidelementinsert/updateOther
12cR2-12cR2PX hash key vector mergesleeptimepassesOther
8i-12cR2PX qref latchfunctionsleeptimeqrefOther
8i-12cR2PX server shutdownnalivesleeptimeloopOther
8i-12cR2PX signal serverserialerrornbusyOther
9i-12cR2PX slave connectionOther
9i-12cR2PX slave releaseOther
11gR2-12cR2Parameter File I/Oblkno#blksread/writeUser I/O
12cR1-12cR2Pluggable Database file copycountintrtimeoutUser I/O
10gR1-10gR1Queue Monitor IPC waitIdle
10gR1-10gR1Queue Monitor Shutdown WaitIdle
10gR1-10gR1Queue Monitor Slave WaitIdle
10gR1-10gR1Queue Monitor Task WaitOther
10gR1-10gR1Queue Monitor WaitIdle
12cR2-12cR2RAC reference partitioning descendants lockmaximum attemptsattempt countOther
12cR1-12cR2RAC referential constraint parent lockmaximum attemptsattempt countOther
12cR2-12cR2RAC: constraint DDL lockmaximum attemptsattempt countOther
12cR1-12cR2REPL Apply: apply DDL2=>GoldenGate 1=>XStream 0=>Streamssleep timeApplication
12cR1-12cR2REPL Apply: commit2=>GoldenGate 1=>XStream 0=>StreamsConfiguration
12cR1-12cR2REPL Apply: dependency2=>GoldenGate 1=>XStream 0=>StreamsConcurrency
12cR1-12cR2REPL Apply: txnsIdle
12cR1-12cR2REPL Capture/Apply: RAC AQ qmn coordinator1=>MASTER 2=>SLAVEIdle
12cR1-12cR2REPL Capture/Apply: RAC inter-instance ack2=>GoldenGate 1=>XStream 0=>StreamsOther
12cR1-12cR2REPL Capture/Apply: database startup2=>GoldenGate 1=>XStream 0=>StreamsOther
12cR1-12cR2REPL Capture/Apply: flow control2=>GoldenGate 1=>XStream 0=>StreamsQueueing
12cR1-12cR2REPL Capture/Apply: memory2=>GoldenGate 1=>XStream 0=>StreamsQueueing
12cR1-12cR2REPL Capture/Apply: messages2=>GoldenGate 1=>XStream 0=>StreamsIdle
12cR1-12cR2REPL Capture/Apply: miscellaneous2=>GoldenGate 1=>XStream 0=>StreamsTYPEOther
12cR1-12cR2REPL Capture: archive log2=>GoldenGate 1=>XStream 0=>StreamsTYPEIdle
12cR1-12cR2REPL Capture: filter callback ruleset2=>GoldenGate 1=>XStream 0=>StreamsApplication
12cR1-12cR2REPL Capture: subscribers to catch up2=>GoldenGate 1=>XStream 0=>StreamsTYPEQueueing
10gR2-10gR2RF - FSFO Wait for AckOther
10gR1-12cR2RFS announceOther
10gR1-12cR2RFS attachOther
10gR1-12cR2RFS closeOther
10gR1-12cR2RFS createOther
10gR1-12cR2RFS detachOther
10gR1-12cR2RFS dispatchOther
10gR1-12cR2RFS pingOther
9i-12cR2RFS random i/oSystem I/O
10gR1-12cR2RFS registerOther
9i-12cR2RFS sequential i/oSystem I/O
10gR1-12cR2RFS writeSystem I/O
12cR2-12cR2RMA: IPC0 completion syncsend countOther
12cR2-12cR2RMA: RAC reconfigOther
12cR2-12cR2RMA: latchRMA LatchLatch ValOther
12cR2-12cR2RMA: rlog allocateState ObjectInstanceOther
11gR1-12cR2RMAN Disk slave I/Owait countwait flagstimeoutSystem I/O
11gR1-12cR2RMAN Tape slave I/Otape operationoperation flagstimeoutSystem I/O
10gR2-12cR2RMAN backup & recovery I/OcountintrtimeoutSystem I/O
12cR2-12cR2RMAN wallet access limitOther
11gR2-12cR2RSGA: RAC reconfigurationOther
10gR1-12cR2RVWR wait for flashback copycopy latch #Other
12cR1-12cR1Recovery Server Comm SGA setup waitsession_idserialIdle
12cR1-12cR1Recovery Server Servlet waitsession_idserialIdle
12cR1-12cR1Recovery Server Surrogate waitsession_idserialIdle
12cR1-12cR1Recovery Server waiting for worksession_idserialIdle
12cR1-12cR1Recovery Server waiting restore startsession_idserialIdle
12cR2-12cR2Recovery: scn growth limitOther
12cR1-12cR2Redo Transport AttachOther
12cR1-12cR2Redo Transport CloseOther
12cR1-12cR2Redo Transport DetachOther
12cR1-12cR2Redo Transport MISCOther
12cR2-12cR2Redo Transport Network ThrottleOther
12cR1-12cR2Redo Transport OpenOther
12cR1-12cR2Redo Transport PingOther
12cR1-12cR2Redo Transport Slave ShutdownOther
12cR1-12cR2Redo Transport Slave StartupOther
12cR1-12cR2Redo Writer Remote Sync CompleteOther
12cR1-12cR2Redo Writer Remote Sync NotifyOther
12cR2-12cR2Redo transport testingOther
12cR1-12cR2Remote SYNC PingOther
12cR2-12cR2Remote Tool Request Free ListOther
12cR2-12cR2Remote Tool Request ReplyOther
8i-12cR2Replication Dequeuesleeptime/senderidpassesOther
12cR1-12cR2Resolution of in-doubt txnsSCNOther
12cR2-12cR2Row cache for Grant or Revokemaximum timeamount of timeOther
12cR2-12cR2SCM slave idleIdle
12cR1-12cR2SGA Allocator terminationOther
10gR2-12cR2SGA: MMAN sleep for component shrinkcomponent idcurrent sizetarget sizeIdle
10gR2-12cR2SGA: allocation forcing component growthOther
10gR2-12cR2SGA: sga_target resizeOther
8i-12cR2SQL*Net break/reset to clientdriver idbreak?Application
8i-12cR2SQL*Net break/reset to dblinkdriver idbreak?Application
8i-12cR2SQL*Net message from clientdriver id#bytesIdle
8i-12cR2SQL*Net message from dblinkdriver id#bytesNetwork
8i-12cR2SQL*Net message to clientdriver id#bytesNetwork
8i-12cR2SQL*Net message to dblinkdriver id#bytesNetwork
8i-12cR2SQL*Net more data from clientdriver id#bytesNetwork
8i-12cR2SQL*Net more data from dblinkdriver id#bytesNetwork
8i-12cR2SQL*Net more data to clientdriver id#bytesNetwork
8i-12cR2SQL*Net more data to dblinkdriver id#bytesNetwork
11gR1-12cR2SQL*Net vector data from clientdriver id#bytesNetwork
11gR1-12cR2SQL*Net vector data from dblinkdriver id#bytesNetwork
11gR1-12cR2SQL*Net vector data to clientdriver id#bytesNetwork
11gR1-12cR2SQL*Net vector data to dblinkdriver id#bytesNetwork
11gR2-12cR2SQL*Net vector message from clientdriver id#bytesIdle
11gR2-12cR2SQL*Net vector message from dblinkdriver id#bytesIdle
9i-10gR1STREAMS apply coord waiting for slave messageIdle
9i-9iSTREAMS apply coord waiting for some work to finish
10gR1-10gR1STREAMS apply slave idle waitIdle
9i-10gR1STREAMS apply slave waiting for coord messageApplication
9i-10gR1STREAMS capture process filter callback wait for rulesetIdle
9i-10gR1STREAMS capture process waiting for archive logOther
9i-10gR1STREAMS fetch slave waiting for txnsIdle
11gR1-12cR2SUPLOG PL wait for inflight pragma-d PL/SQLsession_numOther
10gR1-10gR1SWRF RWM Auto Capture EventOther
10gR1-10gR1SWRF Wait on FlushingOther
12cR1-12cR2SYNC Remote WriteOther
12cR1-12cR2SecureFile log bufferConfiguration
11gR2-12cR2SecureFile mutexConcurrency
12cR2-12cR2Service operation completionCluster
12cR1-12cR2Sharded Queues : Part Maintenance idleIdle
12cR2-12cR2Sharded Queues : Part Truncate idleIdle
11gR1-12cR2Shared IO Pool IO CompletionUser I/O
11gR1-12cR2Shared IO Pool MemoryConcurrency
11gR1-12cR2Space Manager: slave idle waitSlave IDIdle
11gR1-12cR2Space Manager: slave messagesOther
10gR2-12cR2Standby redo I/OcountintrtimeoutSystem I/O
10gR2-12cR2Streams AQ: QueueTable kgl locksOther
10gR2-11gR2Streams AQ: RAC qmn coordinator idle waitIdle
10gR2-12cR2Streams AQ: deallocate messages from Streams PoolIdle
10gR2-12cR2Streams AQ: delete acknowledged messagesIdle
11gR1-12cR2Streams AQ: emn coordinator idle waitIdle
11gR1-11gR2Streams AQ: emn coordinator waiting for slave to startOther
10gR2-12cR2Streams AQ: enqueue blocked due to flow controlQueueing
10gR2-12cR2Streams AQ: enqueue blocked on low memoryQueueing
12cR2-12cR2Streams AQ: index block pin/row lockOtherOther
12cR1-12cR2Streams AQ: load balancer idleIdle
12cR2-12cR2Streams AQ: opt idle1=>SLAVE0 2=>SLAVE1 3=>SLAVE2 4=>SLAVE3 5=>MASTERIdle
10gR2-12cR2Streams AQ: qmn coordinator idle waitIdle
10gR2-11gR2Streams AQ: qmn coordinator waiting for slave to startOther
10gR2-11gR1Streams AQ: qmn slave idle waitIdle
11gR2-12cR2Streams AQ: qmn slave idle waitTypeIdle
10gR2-12cR2Streams AQ: waiting for busy instance for instance_namewherewait_countOther
10gR2-12cR2Streams AQ: waiting for messages in the queuequeue idprocess#wait timeIdle
10gR2-12cR2Streams AQ: waiting for time management or cleanup tasksIdle
11gR1-11gR2Streams apply: waiting for dependencyConcurrency
11gR1-11gR2Streams apply: waiting to commitConfiguration
10gR2-11gR2Streams capture: filter callback waiting for rulesetApplication
10gR2-10gR2Streams capture: resolve low memory conditionConfiguration
10gR2-11gR2Streams capture: waiting for archive logOther
10gR2-11gR2Streams capture: waiting for database startupOther
10gR2-11gR2Streams capture: waiting for subscribers to catch upQueueing
10gR2-11gR2Streams fetch slave: waiting for txnsIdle
10gR2-11gR2Streams miscellaneous eventTYPEOther
10gR2-11gR2Streams: RAC waiting for inter instance ackOther
10gR1-10gR1Streams: Wait for inter instance ackOther
9i-10gR1Streams: Wating for DDL to applysleep timeApplication
10gR2-11gR2Streams: apply reader waiting for DDL to applysleep timeApplication
11gR1-11gR2Streams: flow controlQueueing
11gR1-11gR2Streams: resolve low memory conditionQueueing
11gR1-11gR2Streams: waiting for messagesIdle
12cR2-12cR2Supplemental logging rolesrole idOther
12cR1-12cR2Sync ASM discoveryOther
10gR1-12cR2Sync ASM rebalanceOther
10gR2-12cR2TCP Socket (KGAS)Network
11gR2-12cR2TEST: action hangOther
11gR2-12cR2TEST: action syncOther
12cR1-12cR2TEXT: File System I/OUser I/O
10gR2-12cR2TEXT: URL_DATASTORE network waitNetwork
12cR1-12cR1TPZ test processOther
11gR2-12cR2TSE SSO wallet reopenOther
11gR2-12cR1TSE master key rekeyts#Other
12cR2-12cR2Unpin a recreatable chunkchunk addrmax attemptattemptedConcurrency
11gR2-12cR2VKRM IdleIdle
11gR1-12cR2VKTM Init Wait for GSGAIdle
11gR1-12cR2VKTM Logical Idle WaitIdle
10gR2-12cR2WCR: RAC message context busyOther
11gR1-12cR2WCR: Sync context busyOther
11gR2-12cR2WCR: capture file IO writeOther
11gR1-12cR2WCR: replay client notifywho am IIdle
11gR1-12cR1WCR: replay clockwait for scn's hi 4 byteswait for scn's lo 4 bytesIdle
12cR2-12cR2WCR: replay clockwait for scn's hi 4 byteswait for scn's lo 4 bytesschedule capture IDIdle
11gR1-12cR2WCR: replay lock orderwait for scn's hi 4 byteswait for scn's lo 4 bytesApplication
11gR1-12cR2WCR: replay pausedIdle
9i-10gR1Wait for Dictionary Build to lock all tablesOther
10gR1-12cR2Wait for TT enqueuetsnOther
9i-12cR2Wait for Table LockApplication
8i-8iWait for a paralle reco to abort
8i-8iWait for a undo record
10gR1-12cR2Wait for shrink lockobject_idlock_modeOther
10gR1-12cR2Wait for shrink lock2object_idlock_modeOther
8i-8iWait for stopper event to be increased
10gR1-12cR1Wait on stby instance closeOther
11gR1-12cR2XDB SGA initializationOther
12cR1-12cR2ack for a broadcasted res from a remote instanceOther
12cR1-12cR2acknowledge over PGA limitlimitmargingrowthScheduler
10gR2-12cR2affinity expansion in replayOther
10gR1-12cR2alter rbs offlineAdministrative
9i-12cR2alter system set dispatcherwaitedAdministrative
8i-8ialter system set mts_dispatcherwaited
9i-9iasync disk IOcountintrtimeout
11gR2-12cR2asynch descriptor resizeoutstanding #aiocurrent aio limitnew aio limitOther
11gR1-12cR2auto-sqltune: wait graph updateIdle
9i-9ibackground parameter adjustmentparameter number
10gR1-12cR2block change tracking buffer spaceOther
12cR2-12cR2block compare coord process idleIdle
11gR1-12cR2blocking txn id for DDLtablescnonly dmlOther
11gR1-12cR2broadcast mesg queue transitionchannel handlemessagelocationOther
11gR1-12cR2broadcast mesg recovery queue transitionchannel handlemessagelocationOther
10gR1-12cR2buffer busygroup#obj#block#Other
8i-8ibuffer busy due to global cachefile#block#id
9i-9ibuffer busy global CRfile#block#id
9i-9ibuffer busy global cachefile#block#id
8i-9ibuffer busy waitsfile#block#id
10gR1-12cR2buffer busy waitsfile#block#class#Concurrency
8i-12cR2buffer deadlockdbaclass*10+modeflagOther
10gR1-12cR2buffer dirty disabledgroup#Other
9i-12cR2buffer exterminatefile#block#buf_ptrOther
10gR1-12cR2buffer freelistbusygroup#obj#block#Other
10gR1-12cR2buffer invalidation waitgroup#obj#block#Other
8i-12cR2buffer latchlatch addrchain#Other
9i-11gR1buffer pool resizebuffer pool idcurrent sizenew sizeAdministrative
8i-12cR2buffer read retryfile#block#User I/O
10gR1-12cR2buffer rememberlist busygroup#obj#block#Other
9i-12cR2buffer resizeOther
10gR1-12cR2buffer write waitgroup#obj#block#Other
10gR1-12cR2buffer writeList fullgroup#obj#block#Other
9i-9icache simulator heap
12cR1-12cR2callactionOther
12cR2-12cR2cancel media recovery on switchoverOther
12cR2-12cR2cell external table smart scancellhash#User I/O
11gR2-12cR2cell list of blocks physical readcellhash#diskhash#blocksUser I/O
12cR2-12cR2cell list of blocks read requestcellhash#diskhash#blocksUser I/O
11gR2-12cR2cell manager cancel work requestOther
11gR2-12cR2cell manager closing cellcellhash#System I/O
11gR2-12cR2cell manager discovering diskscellhash#System I/O
11gR2-12cR2cell manager opening cellcellhash#System I/O
11gR1-12cR2cell multiblock physical readcellhash#diskhash#bytesUser I/O
12cR2-12cR2cell multiblock read requestcellhash#diskhash#bytesUser I/O
12cR2-12cR2cell physical read no I/Ocellhash#diskhash#bytesUser I/O
11gR1-12cR2cell single block physical readcellhash#diskhash#bytesUser I/O
12cR2-12cR2cell single block read requestcellhash#diskhash#bytesUser I/O
11gR1-12cR2cell smart file creationcellhash#User I/O
12cR2-12cR2cell smart flash keepcellhash#Other
11gR2-12cR2cell smart flash unkeepcellhash#Other
11gR1-12cR2cell smart incremental backupcellhash#System I/O
11gR1-12cR2cell smart index scancellhash#User I/O
11gR1-12cR2cell smart restore from backupcellhash#System I/O
11gR1-12cR2cell smart table scancellhash#User I/O
11gR1-12cR2cell statistics gathercellhash#User I/O
11gR2-12cR2cell worker idleIdle
11gR2-12cR2cell worker online completioncellhash#Other
11gR2-12cR2cell worker retrycellhash#Other
10gR1-12cR2change tracking file parallel writeblocksrequestsOther
10gR1-12cR2change tracking file synchronous readblock#blocksOther
10gR1-12cR2change tracking file synchronous writeblock#blocksOther
10gR1-12cR2check CPU wait timesOther
10gR1-12cR2checkpoint advancedgroup#Other
8i-12cR2checkpoint completedConfiguration
10gR1-12cR2class slave waitslave idIdle
10gR2-12cR2cleanup of aborted processlocationOther
11gR1-12cR2cmon timersleep timeIdle
11gR2-12cR2concurrent I/O completionAdministrative
12cR1-12cR2connection broker handoffconnection brokerconnectionopNetwork
11gR1-11gR2connection pool waitopnum serversAdministrative
12cR1-12cR2connection pool waitopnum procsAdministrative
9i-10gR1contacting SCN server or SCN lock masterCluster
12cR1-12cR2control file backup creationAdministrative
10gR2-12cR2control file diagnostic dumptypeparamOther
9i-12cR2control file heartbeatOther
8i-9icontrol file parallel writefilesblocksrequests
10gR1-12cR2control file parallel writefilesblock#requestsSystem I/O
8i-12cR2control file sequential readfile#block#blocksSystem I/O
8i-12cR2control file single writefile#block#blocksSystem I/O
8i-8iconversion file readfile#block#blocks
9i-9iconversion file readblock#blocks
9i-12cR2cr request retryfile#block#Other
10gR2-11gR1cursor: mutex Sidnvaluewhere|sleepsConcurrency
11gR2-12cR2cursor: mutex SidnvaluewhereConcurrency
10gR2-11gR1cursor: mutex Xidnvaluewhere|sleepsConcurrency
11gR2-12cR2cursor: mutex XidnvaluewhereConcurrency
10gR2-11gR1cursor: pin Sidnvaluewhere|sleepsOther
11gR2-12cR2cursor: pin SidnvaluewhereConcurrency
10gR2-11gR1cursor: pin S wait on Xidnvaluewhere|sleepsConcurrency
11gR2-12cR2cursor: pin S wait on XidnvaluewhereConcurrency
10gR2-11gR1cursor: pin Xidnvaluewhere|sleepsOther
11gR2-12cR2cursor: pin XidnvaluewhereConcurrency
12cR2-12cR2database open on read-write instanceOther
11gR2-12cR2datafile copy range completionAdministrative
11gR2-12cR2datafile move cleanup during resizeOther
11gR2-12cR2db file async I/O submitrequestsinterrupttimeoutSystem I/O
8i-12cR2db file parallel readfilesblocksrequestsUser I/O
8i-8idb file parallel writefilesblocksrequests
9i-12cR2db file parallel writerequestsinterrupttimeoutSystem I/O
8i-12cR2db file scattered readfile#block#blocksUser I/O
8i-12cR2db file sequential readfile#block#blocksUser I/O
8i-12cR2db file single writefile#block#blocksUser I/O
11gR2-12cR2db flash cache dynamic disabling waitAdministrative
11gR2-12cR1db flash cache invalidate waitConcurrency
12cR2-12cR2db flash cache invalidate waitfile#block#Concurrency
11gR2-12cR2db flash cache multiblock physical readUser I/O
11gR2-12cR2db flash cache single block physical readUser I/O
11gR2-12cR2db flash cache writeUser I/O
10gR2-12cR2dbms_file_transfer I/OcountintrtimeoutUser I/O
10gR2-12cR2dbverify readscountintrtimeoutUser I/O
8i-12cR2debugger commandOther
10gR1-12cR2dedicated server timerwait eventNetwork
12cR1-12cR1defer SGA allocation slavenum of defer segmentsOther
12cR2-12cR2defer SGA allocation slavedefer segment indexallocation modeOther
8i-12cR2direct path readfile numberfirst dbablock cntUser I/O
8i-9idirect path read (lob)file numberfirst dbablock cnt
10gR1-12cR2direct path read tempfile numberfirst dbablock cntUser I/O
11gR1-12cR2direct path syncFile numberFlagsUser I/O
8i-12cR2direct path writefile numberfirst dbablock cntUser I/O
8i-9idirect path write (lob)file numberfirst dbablock cnt
10gR1-12cR2direct path write tempfile numberfirst dbablock cntUser I/O
8i-12cR2dispatcher listen timersleep timeNetwork
8i-12cR2dispatcher shutdownwaitedOther
8i-12cR2dispatcher timersleep timeIdle
10gR1-12cR2dma prepare busygroupobj#block#Other
8i-12cR2dupl. cluster keydbaOther
11gR2-12cR2enq: AB - ABMR process initializedname|modeoperationoperation parmOther
11gR2-12cR2enq: AB - ABMR process start/stopname|modeoperationoperation parmOther
12cR1-12cR2enq: AC - acquiring partition idname|mode00Other
10gR1-12cR2enq: AD - allocate AUname|modegroup and disk numberAU numberOther
10gR1-12cR2enq: AD - deallocate AUname|modegroup and disk numberAU numberOther
12cR2-12cR2enq: AD - flush writes to AUname|modegroup and disk numberAU numberOther
11gR1-12cR2enq: AD - relocate AUname|modegroup and disk numberAU numberOther
11gR1-12cR1enq: AE - lockname|modeedition obj#0Other
12cR2-12cR2enq: AE - lockname|modeedition obj#pdbuidOther
10gR1-12cR2enq: AF - task serializationname|modetask id0Other
10gR1-12cR2enq: AG - contentionname|modeworkspace #generationOther
12cR2-12cR2enq: AH - contentiontype|modeid1id2Other
12cR1-12cR2enq: AK - contentiontype|modeid1id2Other
11gR1-12cR2enq: AM - ASM ACD Relocationname|modeid1id2Other
12cR1-12cR2enq: AM - ASM ATB COD creationname|modeid1id2Other
11gR2-12cR2enq: AM - ASM Amdu Dumpname|modeid1id2Other
12cR1-12cR2enq: AM - ASM Audit file Cleanupname|modeid1id2Other
12cR1-12cR2enq: AM - ASM Audit file Deletename|modeid1id2Other
12cR1-12cR2enq: AM - ASM DD update SrRlocname|modeid1id2Other
11gR1-12cR2enq: AM - ASM File Destroyname|modeid1id2Other
12cR1-12cR2enq: AM - ASM Grow ACDname|modeid1id2Other
11gR2-12cR2enq: AM - ASM Password File Updatename|modeid1id2Other
12cR2-12cR2enq: AM - ASM SR Batch Allocationname|modeid1id2Other
12cR2-12cR2enq: AM - ASM SR Segment Reusename|modeid1id2Other
12cR2-12cR2enq: AM - ASM SR relocationname|modeid1id2Other
12cR2-12cR2enq: AM - ASM Sparse Disk IOCTLname|modeid1id2Other
12cR2-12cR2enq: AM - ASM Split Mirror DB Preparename|modeid1id2Other
12cR2-12cR2enq: AM - ASM Split Mirror File Operationname|modeid1id2Other
12cR2-12cR2enq: AM - ASM Split Mirror Operationname|modeid1id2Other
11gR2-12cR2enq: AM - ASM Username|modeid1id2Other
12cR2-12cR2enq: AM - ASM VAL cachename|modeid1id2Other
12cR2-12cR2enq: AM - ASM VAM Activename|modeid1id2Other
12cR2-12cR2enq: AM - ASM VAT migrationname|modeid1id2Other
11gR1-12cR2enq: AM - ASM cache freezename|modeid1id2Other
12cR1-12cR2enq: AM - ASM client checkname|modeid1id2Other
12cR1-12cR2enq: AM - ASM client operationname|modeid1id2Other
12cR1-12cR2enq: AM - ASM disk based alloc/deallocname|modeid1id2Other
12cR1-12cR2enq: AM - ASM file access reqname|modeid1id2Other
12cR1-12cR2enq: AM - ASM file chownname|modeid1id2Other
12cR1-12cR2enq: AM - ASM file descriptorname|modeid1id2Other
12cR1-12cR2enq: AM - ASM file relocationname|modeid1id2Other
12cR1-12cR2enq: AM - ASM metadata replicationname|modeid1id2Other
12cR1-12cR2enq: AM - ASM reservedname|modeid1id2Other
12cR2-12cR2enq: AM - ASM: group unblockname|modeid1id2Other
12cR2-12cR2enq: AM - ASMB Renewname|modeid1id2Other
12cR2-12cR2enq: AM - ASMB Startupname|modeid1id2Other
12cR1-12cR2enq: AM - Create default DG key in OCRname|modeid1id2Other
12cR1-12cR2enq: AM - Credential creationname|modeid1id2Other
12cR1-12cR2enq: AM - Credential deletionname|modeid1id2Other
12cR1-12cR2enq: AM - Disable Remote ASMname|modeid1id2Other
12cR1-12cR2enq: AM - Enable Remote ASMname|modeid1id2Other
11gR2-11gR2enq: AM - PST split checkname|modeid1id2Other
12cR1-12cR2enq: AM - Register with IOServername|modeid1id2Other
12cR1-12cR2enq: AM - SR slice Clear/Markname|modeid1id2Other
12cR2-12cR2enq: AM - Update SR nomark flagname|modeid1id2Other
11gR1-12cR2enq: AM - background COD reservationname|modeid1id2Other
12cR1-12cR2enq: AM - block repairname|modeid1id2Other
10gR2-12cR2enq: AM - client registrationname|modeid1id2Other
11gR2-12cR2enq: AM - disk offlinename|modeid1id2Other
11gR2-12cR2enq: AM - group blockname|modeid1id2Other
11gR2-12cR2enq: AM - group usename|modeid1id2Other
10gR2-12cR2enq: AM - rollback COD reservationname|modeid1id2Other
10gR2-12cR2enq: AM - shutdownname|modeid1id2Other
10gR1-12cR2enq: AO - contentionname|modeworkspace #object #Other
12cR1-12cR2enq: AP - contentionname|mode00Other
12cR1-12cR2enq: AQ - QPT fg map dqptname|modeQT_OBJ#0Other
12cR1-12cR2enq: AQ - QPT fg map qptname|modeQT_OBJ#0Other
12cR1-12cR2enq: AR - contentiontype|modeid1id2Other
10gR1-10gR1enq: AS - contentionname|mode00Other
10gR2-10gR2enq: AS - modify servicename|mode00Other
10gR2-12cR2enq: AS - service activationname|mode00Other
10gR1-12cR2enq: AT - contentionname|mode00Other
12cR2-12cR2enq: AU - ADR Purge Operationname|mode00Other
10gR2-11gR2enq: AU - audit index filename|modeXML audit index file0Other
11gR2-12cR2enq: AV - AVD client registrationname|modepersistent DG numbernon-DG number enqsOther
11gR2-12cR2enq: AV - add/enable first volume in DGname|modepersistent DG numbernon-DG number enqsOther
11gR1-11gR1enq: AV - persistent DG numbername|modeunusedpersistent DG numberOther
11gR2-12cR2enq: AV - persistent DG numbername|modepersistent DG numbernon-DG number enqsOther
11gR2-12cR2enq: AV - volume relocatename|modepersistent DG numbernon-DG number enqsOther
10gR1-12cR2enq: AW - AW generation lockname|modeoperationworkspace #Other
10gR1-12cR2enq: AW - AW state lockname|modeoperationworkspace #Other
10gR1-12cR2enq: AW - AW$ table lockname|modeoperationworkspace #Other
10gR1-12cR2enq: AW - user access for AWname|modeoperationworkspace #Other
11gR1-12cR2enq: AY - contentionname|modeOp1Op2Other
12cR2-12cR2enq: AZ - AQ_SRVNTFN_Q Creationname|mode00Other
12cR1-12cR2enq: BA - SUBBMAP contentionname|mode00Other
11gR1-12cR2enq: BB - 2PC across RAC instancesname|modegtrid hash valuebqual hash valueCommit
12cR1-12cR2enq: BC - create containername|modecontainer groupcontainer idOther
12cR1-12cR2enq: BC - drop containername|modecontainer groupcontainer idOther
12cR1-12cR2enq: BC - drop container groupname|modecontainer groupcontainer idOther
12cR1-12cR2enq: BC - group - create containername|modecontainer groupcontainer idOther
12cR1-12cR2enq: BC - group - create filename|modecontainer groupcontainer idOther
12cR2-12cR2enq: BE - Critical Block Allocationname|modetablespace#block#Concurrency
10gR2-12cR2enq: BF - PMON Join Filter cleanupname|modenode#/parallelizer#bloom#Other
10gR2-12cR2enq: BF - allocation contentionname|modenode#/parallelizer#bloom#Other
12cR1-12cR2enq: BI - create filename|modegroup ID / file IDfile IDOther
12cR1-12cR2enq: BI - delete filename|modegroup ID / file IDfile IDOther
12cR1-12cR2enq: BI - identify filename|modegroup ID / file IDfile IDOther
12cR1-12cR2enq: BM - clonedb bitmap file writename|modeblock numbernumber of blocksOther
12cR2-12cR2enq: BO - contentiontype|modeid1id2Other
12cR1-12cR1enq: BR - RS check quiescencename|modeoperationfile #Other
12cR1-12cR1enq: BR - RS invalidate plansname|modeoperationfile #Other
12cR1-12cR1enq: BR - RS lock APIname|modeoperationfile #Other
12cR1-12cR1enq: BR - RS lock dbname|modeoperationfile #Other
12cR1-12cR1enq: BR - RS lock schedulername|modeoperationfile #Other
12cR1-12cR1enq: BR - RS lock storage locname|modeoperationfile #Other
12cR1-12cR1enq: BR - RS lock timer queuename|modeoperationfile #Other
12cR1-12cR1enq: BR - RS protect plansname|modeoperationfile #Other
12cR1-12cR1enq: BR - RS purge storage locname|modeoperationfile #Other
12cR1-12cR1enq: BR - RS quiesce storagename|modeoperationfile #Other
12cR1-12cR1enq: BR - RS run schedulername|modeoperationfile #Other
10gR1-12cR2enq: BR - file shrinkname|modeoperationfile #Other
11gR1-12cR2enq: BR - multi-section restore headername|modeoperationfile #Other
11gR1-12cR2enq: BR - multi-section restore sectionname|modeoperationfile #Other
11gR2-12cR2enq: BR - perform autobackupname|modeoperationfile #Other
10gR1-12cR2enq: BR - proxy-copyname|modeoperationfile #Other
11gR2-12cR2enq: BR - request autobackupname|modeoperationfile #Other
11gR1-12cR2enq: BR - space info datafile hdr updatename|modeoperationfile #Other
12cR2-12cR2enq: BS - Backup spare0name|modeid1id2Other
12cR2-12cR2enq: BS - Backup spare1name|modeid1id2Other
12cR2-12cR2enq: BS - Backup spare2name|modeid1id2Other
12cR2-12cR2enq: BS - Backup spare3name|modeid1id2Other
12cR2-12cR2enq: BS - Backup spare4name|modeid1id2Other
12cR2-12cR2enq: BS - Backup spare5name|modeid1id2Other
12cR2-12cR2enq: BS - Backup spare6name|modeid1id2Other
12cR2-12cR2enq: BS - Backup spare7name|modeid1id2Other
12cR2-12cR2enq: BS - Backup spare8name|modeid1id2Other
12cR2-12cR2enq: BS - Backup spare9name|modeid1id2Other
12cR2-12cR2enq: BU - recovery set constructname|mode00Other
12cR2-12cR2enq: BU - recovery set takeovername|mode00Other
12cR1-12cR2enq: BV - rebuild/validate groupname|modeamrv$ keyOther
12cR1-12cR2enq: BZ - resize filename|modegroup ID / file IDfile IDOther
11gR1-12cR2enq: CA - contentionname|mode00Other
12cR1-12cR2enq: CB - role operationname|mode00Concurrency
12cR1-12cR2enq: CC - decryptionname|mode00Other
10gR1-12cR2enq: CF - contentionname|mode0operationOther
10gR1-12cR2enq: CI - contentionname|modeopcodetypeOther
10gR1-12cR2enq: CL - compare labelsname|modeobject #0Other
10gR1-12cR2enq: CL - drop labelname|modeobject #0Other
12cR1-12cR2enq: CM - diskgroup dismountname|modedisk group #typeOther
10gR1-12cR2enq: CM - gatename|modedisk group #typeOther
10gR1-12cR2enq: CM - instancename|modedisk group #typeOther
10gR2-12cR2enq: CN - race with initname|modereg id0Other
10gR2-12cR2enq: CN - race with regname|modereg id0Other
10gR2-12cR2enq: CN - race with txnname|modereg id0Other
11gR1-12cR2enq: CO - master slave detname|modeinst id0Other
12cR1-12cR2enq: CP - Pluggable database resetlogsname|modeInternalInternalOther
11gR1-12cR2enq: CQ - contentionname|mode00Other
11gR2-12cR2enq: CR - block range reuse ckptname|mode20Other
10gR1-12cR2enq: CT - CTWR process start/stopname|modeoperationoperation parmOther
10gR1-12cR2enq: CT - change stream ownershipname|modeoperationoperation parmOther
10gR1-12cR2enq: CT - global space managementname|modeoperationoperation parmOther
10gR1-12cR2enq: CT - local space managementname|modeoperationoperation parmOther
10gR1-12cR2enq: CT - readingname|modeoperationoperation parmOther
10gR1-12cR2enq: CT - statename|modeoperationoperation parmOther
10gR1-12cR2enq: CT - state change gate 1name|modeoperationoperation parmOther
10gR1-12cR2enq: CT - state change gate 2name|modeoperationoperation parmOther
10gR1-12cR2enq: CU - contentionname|modehandlehandleOther
12cR1-12cR2enq: CX - TEXT: Index Specific Lockname|modeIndex IdPartition IdOther
10gR1-12cR2enq: DB - contentionname|modeEnqMode0Administrative
10gR1-12cR2enq: DD - contentionname|modedisk grouptypeOther
10gR1-12cR2enq: DF - contentionname|mode0file #Other
10gR1-12cR2enq: DG - contentionname|modedisk grouptypeOther
12cR1-12cR2enq: DI - contentiontype|modeid1id2Other
10gR1-12cR2enq: DL - contentionname|modeobject #0Other
12cR2-12cR2enq: DM - access controlname|modetypetypeOther
10gR1-12cR2enq: DM - contentionname|modetypetypeOther
10gR1-12cR2enq: DN - contentionname|mode00Other
11gR1-12cR2enq: DO - Staleness Registry createname|modedisk group #disk #Other
11gR1-12cR2enq: DO - disk onlinename|modedisk group #disk #Other
11gR1-11gR2enq: DO - disk online operationname|modedisk group #disk #Other
11gR1-12cR2enq: DO - disk online recoveryname|modedisk group #disk #Other
11gR1-12cR2enq: DO - startup of MARK processname|modedisk group #disk #Other
10gR1-12cR2enq: DP - contentionname|mode00Other
12cR1-12cR2enq: DQ - contentiontype|modeid1id2Other
10gR1-12cR2enq: DR - contentionname|mode00Other
10gR1-12cR2enq: DS - contentionname|mode00Other
10gR1-12cR2enq: DT - contentionname|mode00Other
10gR1-12cR2enq: DV - contentionname|modeobject #0Other
11gR1-12cR2enq: DW - contentionname|modetablespace #dbaOther
10gR1-12cR2enq: DX - contentionname|modetransaction entry #0Other
12cR1-12cR2enq: EA - contentiontype|modeid1id2Other
12cR1-12cR2enq: EB - contentiontype|modeid1id2Other
12cR1-12cR2enq: EC - contentiontype|modeid1id2Other
12cR1-12cR2enq: ED - contentiontype|modeid1id2Other
12cR1-12cR2enq: EE - contentiontype|modeid1id2Other
12cR1-12cR2enq: EF - contentiontype|modeid1id2Other
12cR1-12cR2enq: EG - contentiontype|modeid1id2Other
12cR1-12cR2enq: EH - contentiontype|modeid1id2Other
12cR1-12cR2enq: EI - contentiontype|modeid1id2Other
12cR1-12cR2enq: EJ - contentiontype|modeid1id2Other
12cR1-12cR2enq: EK - contentiontype|modeid1id2Other
12cR1-12cR2enq: EL - contentiontype|modeid1id2Other
12cR1-12cR2enq: EM - contentiontype|modeid1id2Other
12cR1-12cR2enq: EN - contentiontype|modeid1id2Other
12cR1-12cR2enq: EO - contentiontype|modeid1id2Other
12cR1-12cR2enq: EP - contentiontype|modeid1id2Other
12cR1-12cR2enq: EQ - contentiontype|modeid1id2Other
12cR1-12cR2enq: ER - contentiontype|modeid1id2Other
12cR1-12cR2enq: ES - contentiontype|modeid1id2Other
12cR1-12cR2enq: ET - contentiontype|modeid1id2Other
12cR1-12cR2enq: EU - contentiontype|modeid1id2Other
12cR1-12cR2enq: EV - contentiontype|modeid1id2Other
12cR1-12cR2enq: EX - contentiontype|modeid1id2Other
12cR1-12cR2enq: EY - contentiontype|modeid1id2Other
12cR1-12cR2enq: EZ - contentiontype|modeid1id2Other
10gR1-12cR2enq: FA - access filename|modedisk group numberfile numberOther
10gR1-12cR2enq: FB - contentionname|modetablespace #dbaOther
10gR1-12cR2enq: FC - open an ACD threadname|modedisk groupthreadOther
10gR1-12cR2enq: FC - recover an ACD threadname|modedisk groupthreadOther
10gR1-12cR2enq: FD - Flashback coordinatorname|modeInternalInternalOther
11gR2-12cR2enq: FD - Flashback logical operationsname|modeInternalInternalOther
10gR1-12cR2enq: FD - Flashback on/offname|modeInternalInternalOther
10gR1-12cR2enq: FD - Marker generationname|modeInternalInternalOther
10gR2-12cR2enq: FD - Restore point create/dropname|modeInternalInternalOther
10gR1-12cR2enq: FD - Tablespace flashback on/offname|modeInternalInternalOther
11gR1-12cR2enq: FE - contentionname|mode00Other
10gR1-12cR2enq: FG - FG redo generation enq racename|modedisk grouptypeOther
10gR1-12cR2enq: FG - LGWR redo generation enq racename|modedisk grouptypeOther
10gR1-12cR2enq: FG - serialize ACD relocatename|modedisk grouptypeOther
12cR1-12cR2enq: FH - contentionname|modeInstance IDOther
10gR1-12cR2enq: FL - Flashback database logname|modeLog #zeroOther
10gR1-12cR2enq: FL - Flashback db commandname|modeLog #zeroOther
10gR1-12cR2enq: FM - contentionname|mode00Other
12cR1-12cR2enq: FO - file system operation contentionname|mode00Other
10gR2-12cR2enq: FP - global fob contentionname|modelow file obj addhigh file obj addOther
10gR1-11gR1enq: FR - contentionname|modedisk groupunusedOther
11gR2-12cR2enq: FR - contentionname|modedisk groupthreadOther
11gR2-12cR2enq: FR - recover the threadname|modedisk groupthreadOther
11gR2-12cR2enq: FR - use the threadname|modedisk groupthreadOther
10gR1-12cR1enq: FS - contentionname|mode0typeOther
12cR2-12cR2enq: FS - contentionname|mode0 or pdbidtypeOther
12cR1-12cR1enq: FS - online log operationname|mode0typeOther
12cR2-12cR2enq: FS - online log operationname|mode0 or pdbidtypeOther
10gR1-12cR2enq: FT - allow LGWR writesname|modedisk groupthreadOther
10gR1-12cR2enq: FT - disable LGWR writesname|modedisk groupthreadOther
10gR1-12cR2enq: FU - contentionname|mode00Other
12cR1-12cR2enq: FW - contentiontype|modeid1id2Other
11gR1-12cR2enq: FX - issue ACD Xtnt Relocation CICname|modedisk groupunusedOther
12cR1-12cR2enq: FZ - contentiontype|modeid1id2Other
12cR1-12cR2enq: GA - contentiontype|modeid1id2Other
12cR1-12cR2enq: GB - contentiontype|modeid1id2Other
12cR1-12cR2enq: GC - contentiontype|modeid1id2Other
12cR1-12cR2enq: GD - contentiontype|modeid1id2Other
12cR1-12cR2enq: GE - contentiontype|modeid1id2Other
12cR1-12cR2enq: GF - contentiontype|modeid1id2Other
12cR1-12cR2enq: GG - contentiontype|modeid1id2Other
12cR1-12cR2enq: GH - contentiontype|modeid1id2Other
12cR1-12cR2enq: GI - contentiontype|modeid1id2Other
12cR1-12cR2enq: GJ - contentiontype|modeid1id2Other
12cR1-12cR2enq: GK - contentiontype|modeid1id2Other
12cR1-12cR2enq: GL - contentiontype|modeid1id2Other
12cR1-12cR2enq: GM - contentiontype|modeid1id2Other
12cR1-12cR2enq: GN - contentiontype|modeid1id2Other
12cR1-12cR2enq: GO - contentiontype|modeid1id2Other
12cR1-12cR2enq: GP - contentiontype|modeid1id2Other
12cR1-12cR2enq: GQ - contentiontype|modeid1id2Other
12cR1-12cR2enq: GR - contentiontype|modeid1id2Other
12cR1-12cR2enq: GS - contentiontype|modeid1id2Other
12cR1-12cR2enq: GT - contentiontype|modeid1id2Other
12cR1-12cR2enq: GU - contentiontype|modeid1id2Other
12cR1-12cR2enq: GV - contentiontype|modeid1id2Other
12cR1-12cR2enq: GX - contentiontype|modeid1id2Other
12cR1-12cR2enq: GY - contentiontype|modeid1id2Other
12cR1-12cR2enq: GZ - contentiontype|modeid1id2Other
12cR2-12cR2enq: HC - HSM cache readname|mode00Other
12cR2-12cR2enq: HC - HSM cache writename|mode00Other
10gR1-12cR2enq: HD - contentionname|modedisk group0Other
12cR1-12cR2enq: HM - contentiontype|modeid1id2Other
10gR1-12cR2enq: HP - contentionname|modetablespace #dbaOther
10gR1-12cR2enq: HQ - contentionname|modeobject #hash valueOther
10gR1-12cR2enq: HV - contentionname|modeobject #0Other
10gR1-12cR2enq: HW - contentionname|modetable space #blockConfiguration
10gR1-12cR2enq: IA - contentionname|mode00Other
12cR1-12cR2enq: IC - IOServer clientIDname|modeclient idnoneOther
10gR1-12cR2enq: ID - contentionname|mode00Other
12cR1-12cR2enq: IF - file closename|modeclient id/group numFile numberOther
12cR1-12cR2enq: IF - file openname|modeclient id/group numFile numberOther
12cR2-12cR2enq: II - contentiontype|modeid1id2Other
12cR2-12cR2enq: IK - contentiontype|modeid1id2Other
10gR1-12cR2enq: IL - contentionname|modeobject #0Other
10gR1-12cR2enq: IM - contention for blrname|modepool #0Other
12cR2-12cR2enq: IN - contentionname|modetablespace #dbaOther
12cR1-12cR1enq: IP - open/close PDBname|mode0typeOther
12cR2-12cR2enq: IP - open/close PDBname|modetypepdbuidOther
12cR1-12cR2enq: IR - arbitrate instance recoveryname|mode00/1Other
10gR1-12cR2enq: IR - contentionname|mode00/1Other
10gR1-12cR2enq: IR - contention2name|mode00/1Other
12cR1-12cR2enq: IR - global serializationname|mode00/1Other
12cR1-12cR2enq: IR - local serializationname|mode00/1Other
10gR1-12cR1enq: IS - contentionname|mode0typeOther
12cR2-12cR2enq: IS - contentionname|mode0 or pdbidtypeOther
10gR1-12cR2enq: IT - contentionname|modeobject #0Other
12cR1-12cR2enq: IV - contentiontype|modeid1id2Other
12cR1-12cR2enq: IZ - contentiontype|modeid1id2Other
10gR1-12cR2enq: JD - contentionname|mode00Other
12cR2-12cR2enq: JG - contentionname|modeservice IDqueue typeOther
12cR2-12cR2enq: JG - evt notifyname|modeservice IDqueue typeOther
12cR2-12cR2enq: JG - evtsub addname|modeservice IDqueue typeOther
12cR2-12cR2enq: JG - evtsub dropname|modeservice IDqueue typeOther
12cR2-12cR2enq: JG - q mem clnup lckname|modeservice IDqueue typeOther
12cR2-12cR2enq: JG - queue lockname|modeservice IDqueue typeOther
12cR2-12cR2enq: JG - sch locl enqsname|modeservice IDqueue typeOther
10gR1-12cR2enq: JI - contentionname|modeview object #0Other
10gR1-12cR2enq: JQ - contentionname|mode00Other
11gR1-12cR2enq: JS - aq syncname|modeservice IDqueue typeOther
10gR1-12cR1enq: JS - contentionname|modeservice IDqueue typeOther
10gR1-10gR1enq: JS - coord post lockname|modeservice IDqueue typeOther
10gR1-10gR1enq: JS - coord rcv lockname|modeservice IDqueue typeOther
10gR2-12cR2enq: JS - evt notifyname|modeservice IDqueue typeOther
10gR2-12cR1enq: JS - evtsub addname|modeservice IDqueue typeOther
10gR2-12cR1enq: JS - evtsub dropname|modeservice IDqueue typeOther
10gR1-10gR1enq: JS - global wdw lockname|modeservice IDqueue typeOther
10gR1-10gR1enq: JS - job chain evaluate lockname|modeservice IDqueue typeOther
10gR1-12cR2enq: JS - job recov lockname|modeservice IDqueue typeOther
10gR1-12cR2enq: JS - job run lock - synchronizename|modeservice IDqueue typeOther
10gR1-12cR1enq: JS - q mem clnup lckname|modeservice IDqueue typeOther
10gR1-12cR1enq: JS - queue lockname|modeservice IDqueue typeOther
10gR1-10gR1enq: JS - running job cnt lockname|modeservice IDqueue typeOther
10gR1-10gR1enq: JS - running job cnt lock2name|modeservice IDqueue typeOther
10gR1-10gR1enq: JS - running job cnt lock3name|modeservice IDqueue typeOther
10gR2-12cR1enq: JS - sch locl enqsname|modeservice IDqueue typeOther
10gR1-10gR1enq: JS - slave enq get lock1name|modeservice IDqueue typeOther
10gR1-10gR1enq: JS - slave enq get lock2name|modeservice IDqueue typeOther
10gR2-12cR2enq: JS - wdw opname|modeservice IDqueue typeOther
11gR2-12cR2enq: JX - SQL statement queuename|modesqlidexecidScheduler
11gR2-12cR2enq: JX - cleanup of queuename|modesqlidexecidScheduler
12cR2-12cR2enq: JZ - Join group dictionaryname|mode00Other
12cR2-12cR2enq: KA - ACL control statusname|mode00Other
11gR2-12cR2enq: KD - determine DBRM mastername|mode00Other
12cR1-12cR2enq: KE - contentiontype|modeid1id2Other
12cR1-12cR2enq: KI - contentionname|modeclient opcode0Other
10gR1-10gR2enq: KK - contextname|mode0redo threadOther
12cR1-12cR2enq: KL - contentiontype|modeid1id2Other
10gR1-12cR2enq: KM - contentionname|modetypetypeOther
10gR2-12cR2enq: KO - fast object checkpointname|mode20Application
10gR1-12cR2enq: KP - contentionname|mode00Other
11gR1-12cR2enq: KQ - access ASM attributename|modegroupentryOther
10gR1-12cR2enq: KT - contentionname|modeplan #0Other
12cR2-12cR2enq: KV - IMA key vector accessname|modenode#+sess#、cursor#+kv#kv #Concurrency
12cR1-12cR2enq: KZ - contentiontype|modeid1id2Other
12cR1-12cR2enq: LA - contentiontype|modeid1id2Other
12cR1-12cR2enq: LB - contentiontype|modeid1id2Other
12cR1-12cR2enq: LC - contentiontype|modeid1id2Other
12cR1-12cR2enq: LD - contentiontype|modeid1id2Other
12cR1-12cR2enq: LE - contentiontype|modeid1id2Other
12cR1-12cR2enq: LF - contentiontype|modeid1id2Other
12cR1-12cR2enq: LG - contentiontype|modeid1id2Other
12cR1-12cR2enq: LH - contentiontype|modeid1id2Other
12cR1-12cR2enq: LI - contentiontype|modeid1id2Other
12cR1-12cR2enq: LJ - contentiontype|modeid1id2Other
12cR1-12cR2enq: LK - contentiontype|modeid1id2Other
12cR1-12cR2enq: LL - contentiontype|modeid1id2Other
12cR1-12cR2enq: LM - contentiontype|modeid1id2Other
12cR1-12cR2enq: LN - contentiontype|modeid1id2Other
12cR1-12cR2enq: LO - contentiontype|modeid1id2Other
12cR1-12cR2enq: LP - contentiontype|modeid1id2Other
12cR1-12cR2enq: LQ - contentiontype|modeid1id2Other
12cR1-12cR2enq: LR - contentiontype|modeid1id2Other
12cR1-12cR2enq: LS - contentiontype|modeid1id2Other
12cR1-12cR2enq: LT - contentiontype|modeid1id2Other
12cR1-12cR2enq: LU - contentiontype|modeid1id2Other
12cR1-12cR2enq: LV - contentiontype|modeid1id2Other
12cR1-12cR2enq: LX - contentiontype|modeid1id2Other
12cR1-12cR2enq: LY - contentiontype|modeid1id2Other
12cR1-12cR2enq: LZ - contentiontype|modeid1id2Other
12cR1-12cR2enq: MC - Securefile logname|mode0hash(logname)Other
10gR1-12cR2enq: MD - contentionname|modemaster object #0Other
12cR1-12cR2enq: MF - creating swap in instancename|modelogidbktId<<16|instidOther
12cR1-12cR2enq: MF - flush bkgnd periodicname|modelogidbktId<<16|instidOther
12cR1-12cR2enq: MF - flush clientname|modelogidbktId<<16|instidOther
12cR1-12cR2enq: MF - flush destroyname|modelogidbktId<<16|instidOther
12cR1-12cR2enq: MF - flush prior errorname|modelogidbktId<<16|instidOther
12cR1-12cR2enq: MF - flush spacename|modelogidbktId<<16|instidOther
10gR1-12cR2enq: MH - contentionname|mode00Other
10gR2-12cR2enq: MK - contentionname|mode00Other
10gR1-12cR2enq: ML - contentionname|mode00Other
12cR2-12cR2enq: MM - AWR reply buffername|mode00Other
10gR1-12cR2enq: MN - contentionname|modesession ID0Other
10gR2-12cR2enq: MO - contentionname|mode00Other
12cR1-12cR2enq: MR - PDB openname|mode0 or file #typeOther
12cR1-12cR2enq: MR - adg instance recoveryname|mode0 or file #typeOther
12cR1-12cR2enq: MR - any role transitionname|mode0 or file #typeOther
10gR1-12cR2enq: MR - contentionname|mode0 or file #typeOther
12cR1-12cR2enq: MR - datafile onlinename|mode0 or file #typeOther
12cR1-12cR2enq: MR - multi instance redo applyname|mode0 or file #typeOther
11gR2-12cR2enq: MR - standby role transitionname|mode0 or file #typeOther
10gR1-12cR2enq: MS - contentionname|modemaster object #0Other
11gR2-12cR2enq: MV - datafile movename|modetypefile #Administrative
10gR1-12cR2enq: MW - contentionname|modeSchedule Id0Other
11gR1-12cR2enq: MX - sync storage server infoname|modenodeidinstanceidOther
12cR1-12cR2enq: NA - contentiontype|modeid1id2Other
12cR1-12cR2enq: NB - contentiontype|modeid1id2Other
12cR1-12cR2enq: NC - contentiontype|modeid1id2Other
12cR1-12cR2enq: ND - contentiontype|modeid1id2Other
12cR1-12cR2enq: NE - contentiontype|modeid1id2Other
12cR1-12cR2enq: NF - contentiontype|modeid1id2Other
12cR1-12cR2enq: NG - contentiontype|modeid1id2Other
12cR1-12cR2enq: NH - contentiontype|modeid1id2Other
12cR1-12cR2enq: NI - contentiontype|modeid1id2Other
12cR1-12cR2enq: NJ - contentiontype|modeid1id2Other
12cR1-12cR2enq: NK - contentiontype|modeid1id2Other
12cR1-12cR2enq: NL - contentiontype|modeid1id2Other
12cR1-12cR2enq: NM - contentiontype|modeid1id2Other
12cR1-12cR2enq: NN - contentiontype|modeid1id2Other
12cR1-12cR2enq: NO - contentiontype|modeid1id2Other
12cR1-12cR2enq: NP - contentiontype|modeid1id2Other
12cR1-12cR2enq: NQ - contentiontype|modeid1id2Other
12cR1-12cR2enq: NR - contentiontype|modeid1id2Other
12cR1-12cR2enq: NS - contentiontype|modeid1id2Other
12cR1-12cR2enq: NT - contentiontype|modeid1id2Other
12cR1-12cR2enq: NU - contentiontype|modeid1id2Other
12cR1-12cR2enq: NV - contentiontype|modeid1id2Other
12cR1-12cR2enq: NX - contentiontype|modeid1id2Other
12cR1-12cR2enq: NY - contentiontype|modeid1id2Other
12cR1-12cR2enq: NZ - contentiontype|modeid1id2Other
10gR1-12cR2enq: OC - contentionname|mode12Other
11gR1-12cR2enq: OD - Serializing DDLsname|modeobject #0Other
10gR1-12cR2enq: OL - contentionname|modehash value0Other
12cR1-12cR2enq: OP - OLS Cleanup unused profilesname|modeobject #0Other
12cR1-12cR2enq: OP - OLS Store user entriesname|modeobject #0Other
10gR1-12cR2enq: OQ - xsoq*histrecbname|moderesource id0Other
10gR1-12cR2enq: OQ - xsoqhiAllocname|moderesource id0Other
10gR1-12cR2enq: OQ - xsoqhiClosename|moderesource id0Other
10gR1-12cR2enq: OQ - xsoqhiFlushname|moderesource id0Other
10gR1-12cR2enq: OQ - xsoqhistrecbname|moderesource id0Other
12cR1-12cR2enq: OT - TEXT: Generic Lockname|mode00Other
10gR2-12cR2enq: OW - initializationname|mode00Other
10gR2-12cR2enq: OW - terminationname|mode00Other
12cR1-12cR2enq: PA - modify a privilege capturename|mode00Other
12cR1-12cR2enq: PA - read a privilege capturename|mode00Other
12cR1-12cR2enq: PB - PDB Lockname|mode0typeOther
12cR2-12cR2enq: PC - read privilege capture infoname|mode00Other
12cR2-12cR2enq: PC - update privilege capture infoname|mode00Other
10gR1-12cR2enq: PD - contentionname|modeproperty namekey hashOther
10gR1-12cR2enq: PE - contentionname|modeparno0Other
10gR1-12cR2enq: PF - contentionname|mode00Other
10gR1-12cR2enq: PG - contentionname|mode00Other
10gR1-12cR2enq: PH - contentionname|mode00Other
10gR1-12cR2enq: PI - contentionname|modeoperationserial #Other
12cR2-12cR2enq: PJ - modify DV policyname|mode00Other
12cR2-12cR2enq: PJ - read DV policyname|mode00Other
10gR1-12cR2enq: PL - contentionname|mode00Other
12cR1-12cR2enq: PM - contentiontype|modeid1id2Other
12cR1-12cR2enq: PP - contentiontype|modeid1id2Other
12cR1-12cR2enq: PQ - QPT LB Trunc syncname|modeQT_OBJ#0Other
12cR1-12cR2enq: PQ - QPT Truncname|modeQT_OBJ#0Other
12cR2-12cR2enq: PQ - QPT XSTART Trunc syncname|modeQT_OBJ#0Other
12cR1-12cR2enq: PQ - QPT add dqptname|modeQT_OBJ#0Other
12cR1-12cR2enq: PQ - QPT add dqpt fgname|modeQT_OBJ#0Other
12cR1-12cR2enq: PQ - QPT add qptname|modeQT_OBJ#0Other
12cR1-12cR2enq: PQ - QPT add qpt fgname|modeQT_OBJ#0Other
12cR1-12cR2enq: PQ - QPT drop dqptname|modeQT_OBJ#0Other
12cR1-12cR2enq: PQ - QPT drop qptname|modeQT_OBJ#0Other
10gR1-11gR2enq: PR - contentionname|mode00Other
12cR1-12cR2enq: PR - contentionname|modetypedtpOther
10gR1-12cR2enq: PS - contentionname|modeinstanceslave IDOther
12cR2-12cR2enq: PT - ASM Storage May Splitname|modedisk group #typeOther
10gR1-12cR2enq: PT - contentionname|modedisk group #typeOther
10gR1-11gR2enq: PV - syncshutname|mode00Other
12cR1-12cR2enq: PV - syncshutname|modeclass id0Other
10gR1-11gR2enq: PV - syncstartname|mode00Other
12cR1-12cR2enq: PV - syncstartname|modeclass id0Other
10gR1-12cR2enq: PW - flush prewarm buffersname|mode00Application
10gR1-12cR2enq: PW - perwarm status in dbw0name|mode00Other
12cR2-12cR2enq: PX - PDB instance recoveryname|mode0 or thread#typeOther
12cR1-12cR1enq: PY - AVM RTA access databasename|modedbidinstanceOther
12cR1-12cR1enq: PY - AVM RTA access database 2name|modedbidinstanceOther
12cR1-12cR1enq: PY - AVM RTA access instancename|modedbidinstanceOther
12cR1-12cR2enq: QA - contentiontype|modeid1id2Other
12cR1-12cR2enq: QB - contentiontype|modeid1id2Other
12cR1-12cR2enq: QC - contentiontype|modeid1id2Other
12cR1-12cR2enq: QD - contentiontype|modeid1id2Other
12cR1-12cR2enq: QE - contentiontype|modeid1id2Other
12cR1-12cR2enq: QF - contentiontype|modeid1id2Other
12cR1-12cR2enq: QG - contentiontype|modeid1id2Other
12cR1-12cR2enq: QH - contentiontype|modeid1id2Other
12cR1-12cR2enq: QI - contentiontype|modeid1id2Other
12cR1-12cR2enq: QJ - contentiontype|modeid1id2Other
12cR1-12cR2enq: QK - contentiontype|modeid1id2Other
12cR1-12cR2enq: QL - contentiontype|modeid1id2Other
12cR1-12cR2enq: QM - contentiontype|modeid1id2Other
12cR1-12cR2enq: QN - contentiontype|modeid1id2Other
12cR1-12cR2enq: QO - contentiontype|modeid1id2Other
12cR1-12cR2enq: QP - contentiontype|modeid1id2Other
12cR1-12cR2enq: QQ - contentiontype|modeid1id2Other
12cR1-12cR2enq: QR - contentiontype|modeid1id2Other
12cR1-12cR2enq: QS - contentiontype|modeid1id2Other
12cR1-12cR2enq: QT - contentiontype|modeid1id2Other
12cR1-12cR2enq: QU - contentiontype|modeid1id2Other
12cR1-12cR2enq: QV - contentiontype|modeid1id2Other
12cR1-12cR2enq: QX - contentiontype|modeid1id2Other
12cR1-12cR2enq: QY - contentiontype|modeid1id2Other
12cR1-12cR2enq: QZ - contentiontype|modeid1id2Other
12cR1-12cR2enq: RA - RT ADDM flood controlname|mode00Other
10gR1-12cR2enq: RB - contentionname|modedisk group0Other
11gR1-12cR2enq: RC - Result Cache: Contentionname|modechunkNoblockNoApplication
11gR2-12cR2enq: RD - RAC loadname|modesqlidexecidOther
11gR1-12cR2enq: RE - block repair contentionname|modeFile Type or File numberblock numberOther
12cR2-12cR2enq: RF - Broker Chief Lockname|modelock operationlock valueOther
12cR2-12cR2enq: RF - Broker NSV Lockname|modelock operationlock valueOther
12cR1-12cR2enq: RF - Broker State Lockname|modelock operationlock valueOther
11gR1-12cR2enq: RF - DG Broker Current File IDname|modelock operationlock valueOther
11gR1-12cR2enq: RF - FSFO Observer Heartbeatname|modelock operationlock valueOther
12cR1-12cR2enq: RF - FSFO Primary Shutdown suspendedname|modelock operationlock valueOther
12cR1-12cR2enq: RF - FSFO string buffername|modelock operationlock valueOther
10gR2-12cR2enq: RF - RF - Database Automatic Disablename|modelock operationlock valueOther
10gR2-10gR2enq: RF - RF - FSFO Observedname|modelock operationlock valueOther
10gR2-10gR2enq: RF - RF - FSFO connectivityname|modelock operationlock valueOther
10gR2-10gR2enq: RF - RF - FSFO statename|modelock operationlock valueOther
10gR2-10gR2enq: RF - RF - FSFO synchronizationname|modelock operationlock valueOther
10gR2-10gR2enq: RF - RF - FSFO waitname|modelock operationlock valueOther
10gR1-12cR2enq: RF - atomicityname|modelock operationlock valueOther
10gR1-12cR2enq: RF - new AIname|modelock operationlock valueOther
10gR2-12cR2enq: RF - synch: DG Broker metadataname|modelock operationlock valueOther
10gR1-10gR1enq: RF - synch: per-SGA Broker metadataname|modelock operationlock valueOther
10gR1-10gR2enq: RF - synchronization: HC mastername|modelock operationlock valueOther
10gR1-12cR2enq: RF - synchronization: aifo mastername|modelock operationlock valueOther
10gR1-10gR2enq: RF - synchronization: chiefname|modelock operationlock valueOther
10gR1-12cR2enq: RF - synchronization: critical ainame|modelock operationlock valueOther
12cR2-12cR2enq: RG - Apply coord start/stopname|mode00Other
12cR2-12cR2enq: RK - queue wallet and TS keysname|mode00Other
11gR2-12cR2enq: RK - set keyname|mode00Other
11gR2-12cR2enq: RL - RAC wallet lockname|mode00Other
12cR1-12cR2enq: RM - contentiontype|modeid1id2Other
10gR1-12cR2enq: RN - contentionname|modethread numberlog numberOther
10gR1-10gR1enq: RO - contentionname|mode10Application
10gR2-12cR2enq: RO - contentionname|mode20Application
10gR1-10gR1enq: RO - fast object reusename|mode10Application
10gR2-12cR2enq: RO - fast object reusename|mode20Application
10gR1-12cR2enq: RP - contentionname|modefile #1 or blockOther
12cR2-12cR2enq: RQ - AQ Cross Shard mem freename|modeQ_OBJ#shard:modeOther
12cR2-12cR2enq: RQ - AQ Cross update scn for delayname|modeQ_OBJ#shard:modeOther
12cR2-12cR2enq: RQ - AQ Dq Ptn Mappingname|modeQ_OBJ#shard:modeOther
12cR2-12cR2enq: RQ - AQ Enq commit block truncatename|modeQ_OBJ#shard:modeOther
12cR2-12cR2enq: RQ - AQ Enq commit incarnation wrapname|modeQ_OBJ#shard:modeOther
12cR2-12cR2enq: RQ - AQ Eq Ptn Mappingname|modeQ_OBJ#shard:modeOther
12cR2-12cR2enq: RQ - AQ Evict: block truncatename|modeQ_OBJ#shard:modeOther
12cR2-12cR2enq: RQ - AQ Rule evaluation segment loadname|modeQ_OBJ#shard:modeOther
12cR2-12cR2enq: RQ - AQ Shid Genname|modeQ_OBJ#shard:modeOther
12cR2-12cR2enq: RQ - AQ Trnc mem freename|modeQ_OBJ#shard:modeOther
12cR2-12cR2enq: RQ - AQ Trnc mem free by CPname|modeQ_OBJ#shard:modeOther
12cR2-12cR2enq: RQ - AQ Trnc mem free by LBname|modeQ_OBJ#shard:modeOther
12cR2-12cR2enq: RQ - AQ Trnc mem free remotename|modeQ_OBJ#shard:modeOther
12cR2-12cR2enq: RQ - AQ Unevict PGA: Queue Viewname|modeQ_OBJ#shard:modeOther
12cR2-12cR2enq: RQ - AQ Unevict PGA: setup subscribername|modeQ_OBJ#shard:modeOther
12cR2-12cR2enq: RQ - AQ cached commit WM updatename|modeQ_OBJ#shard:modeOther
12cR2-12cR2enq: RQ - AQ cached dequeue by conditionname|modeQ_OBJ#shard:modeOther
12cR1-12cR2enq: RQ - AQ indexed cached commitname|modeQ_OBJ#shard:modeOther
12cR2-12cR2enq: RQ - AQ rollback retry count updatename|modeQ_OBJ#shard:modeOther
12cR1-12cR2enq: RQ - AQ uncached commit WM updatename|modeQ_OBJ#shard:modeOther
12cR1-12cR2enq: RQ - AQ uncached dequeuename|modeQ_OBJ#shard:modeOther
12cR1-12cR2enq: RQ - Cross export subshardname|modeQ_OBJ#shard:modeOther
12cR1-12cR2enq: RQ - Cross import subshardname|modeQ_OBJ#shard:modeOther
12cR1-12cR2enq: RQ - Cross update scnname|modeQ_OBJ#shard:modeOther
12cR1-12cR2enq: RQ - Dequeue update scnname|modeQ_OBJ#shard:modeOther
12cR1-12cR2enq: RQ - Enqueue commit cachedname|modeQ_OBJ#shard:modeOther
12cR1-12cR2enq: RQ - Enqueue commit uncachedname|modeQ_OBJ#shard:modeOther
12cR1-12cR2enq: RQ - Free shadow shardname|modeQ_OBJ#shard:modeOther
12cR1-12cR2enq: RQ - Parallel cross update scnname|modeQ_OBJ#shard:modeOther
12cR1-12cR2enq: RQ - Trucate subshardname|modeQ_OBJ#shard:modeOther
10gR2-12cR2enq: RR - contentionname|modelock#not usedOther
10gR1-12cR2enq: RS - file deletename|moderecord typerecord idOther
10gR1-12cR2enq: RS - persist alert levelname|moderecord typerecord idOther
10gR1-12cR2enq: RS - prevent aging list updatename|moderecord typerecord idOther
10gR1-12cR2enq: RS - prevent file deletename|moderecord typerecord idOther
10gR1-12cR2enq: RS - read alert levelname|moderecord typerecord idOther
10gR1-12cR2enq: RS - record reusename|moderecord typerecord idOther
10gR1-12cR2enq: RS - write alert levelname|moderecord typerecord idOther
10gR1-12cR2enq: RT - contentionname|moderedo threadtypeOther
11gR2-12cR2enq: RT - thread internal enable/disablename|moderedo threadtypeOther
10gR2-12cR2enq: RU - contentionname|mode00Other
10gR2-12cR2enq: RU - waitingname|mode00Other
10gR2-12cR2enq: RW - MV metadata contentionname|modetable obj#0Other
11gR1-12cR2enq: RX - relocate extentname|modedisk group #:file #virtual extent numberOther
12cR1-12cR2enq: RX - unlock extentname|modedisk group #:file #virtual extent numberOther
12cR1-12cR2enq: RZ - add elementname|mode00Other
12cR1-12cR2enq: RZ - remove elementname|mode00Other
12cR2-12cR2enq: SA - MRP SRL accessname|mode00Other
12cR2-12cR2enq: SA - standby redo logfilesname|mode00Other
10gR1-11gR2enq: SB - contentionname|mode00Other
12cR1-12cR2enq: SB - logical standby metadataname|mode00Other
12cR1-12cR2enq: SB - table instantiationname|mode00Other
12cR1-12cR2enq: SC - contentiontype|modeid1id2Other
10gR2-12cR2enq: SE - contentionname|modeSession-idSerial#Other
10gR1-12cR2enq: SF - contentionname|mode00Other
12cR1-12cR2enq: SG - OLS Add Groupname|modeobject #0Other
12cR1-12cR2enq: SG - OLS Alter Group Parentname|modeobject #0Other
12cR1-12cR2enq: SG - OLS Create Groupname|modeobject #0Other
12cR1-12cR2enq: SG - OLS Drop Groupname|modeobject #0Other
10gR1-12cR2enq: SH - contentionname|mode00Other
10gR1-12cR2enq: SI - contentionname|modeobject #0Other
11gR1-12cR2enq: SJ - Slave Task Cancelname|modeSlave process idtask idOther
10gR1-12cR2enq: SK - contentionname|modetablespace #dbaOther
11gR1-12cR2enq: SL - escalate lockname|modekdlw lobid first halfkdlw lobid sec halfOther
11gR1-12cR2enq: SL - get lockname|modekdlw lobid first halfkdlw lobid sec halfOther
11gR1-12cR2enq: SL - get lock for undoname|modekdlw lobid first halfkdlw lobid sec halfOther
12cR1-12cR2enq: SM - contentiontype|modeid1id2Other
12cR2-12cR2enq: SN - PDB SGA allocationname|mode00Other
12cR2-12cR2enq: SN - PDB SGA freename|mode00Other
12cR2-12cR2enq: SN - PDB SGA protectionname|mode00Other
11gR1-12cR2enq: SO - contentionname|modeobject #0Other
11gR2-11gR2enq: SP - contentionname|modeid1id2Other
12cR1-12cR2enq: SP - contention 1name|modeid1id2Other
11gR2-12cR2enq: SP - contention 2name|modeid1id2Other
11gR2-12cR2enq: SP - contention 3name|modeid1id2Other
11gR2-12cR2enq: SP - contention 4name|modeid1id2Other
10gR1-12cR2enq: SQ - contentionname|modeobject #0Configuration
10gR1-12cR2enq: SR - contentionname|modeoperationsequence # / apply #Other
10gR1-12cR2enq: SS - contentionname|modetablespace #dbaOther
10gR1-12cR2enq: ST - contentionname|mode00Configuration
10gR1-12cR2enq: SU - contentionname|modetable space #0Other
12cR1-12cR2enq: SV - contentiontype|modeid1id2Other
10gR1-12cR2enq: SW - contentionname|mode00Other
12cR2-12cR2enq: SX - contention 5name|modeid1id2Other
12cR2-12cR2enq: SX - contention 6name|modeid1id2Other
12cR2-12cR2enq: SY - IM populate by other sessionname|modetablespace # & objdrdbaOther
12cR2-12cR2enq: SZ - contentionname|modetablespace #rdbaOther
10gR1-12cR2enq: TA - contentionname|modeoperationundo segment # / otherOther
10gR1-12cR2enq: TB - SQL Tuning Base Cache Loadname|mode12Other
10gR1-12cR2enq: TB - SQL Tuning Base Cache Updatename|mode12Other
10gR1-12cR2enq: TC - contentionname|modecheckpoint ID0Other
10gR1-12cR2enq: TC - contention2name|modecheckpoint ID0Other
10gR1-12cR2enq: TD - KTF dump entriesname|mode00Other
10gR1-12cR2enq: TE - KTF broadcastname|mode00Other
10gR1-12cR2enq: TF - contentionname|modetablespace #relative file #Other
12cR2-12cR2enq: TG - IMCDT global resourcename|modecontainer id #0Concurrency
11gR1-12cR2enq: TH - metric threshold evaluationname|mode00Other
12cR2-12cR2enq: TI - IMCDT object HTname|modequery exec id #qc session id #Concurrency
11gR1-12cR2enq: TK - Auto Task Serializationname|mode0-MMON、 1-MMON Slave0Other
11gR1-12cR2enq: TK - Auto Task Slave Lockoutname|mode0-MMON、 1-MMON Slave0Other
10gR1-12cR2enq: TL - contentionname|mode00Other
10gR1-12cR2enq: TM - contentionname|modeobject #table/partitionApplication
10gR1-12cR2enq: TO - contentionname|modeobject #1Other
11gR2-12cR2enq: TP - contentionname|mode00Other
12cR1-12cR2enq: TQ - sq TM contentionname|modeQT_OBJ#0Other
10gR1-12cR2enq: TQ - DDL contentionname|modeQT_OBJ#0Other
11gR1-12cR2enq: TQ - DDL-INI contentionname|modeQT_OBJ#0Other
10gR1-12cR2enq: TQ - INI contentionname|modeQT_OBJ#0Other
12cR1-12cR2enq: TQ - INI sq contentionname|modeQT_OBJ#0Other
12cR2-12cR2enq: TQ - MC free sync at cross job endname|modeQT_OBJ#0Other
12cR2-12cR2enq: TQ - MC free sync at cross job startname|modeQT_OBJ#0Other
12cR2-12cR2enq: TQ - MC free sync at cross job stopname|modeQT_OBJ#0Other
12cR2-12cR2enq: TQ - MC free sync at export subshardname|modeQT_OBJ#0Other
10gR1-12cR2enq: TQ - TM contentionname|modeQT_OBJ#0Other
12cR2-12cR2enq: TQ - create eviction tablename|modeQT_OBJ#0Other
12cR2-12cR2enq: TR - database key open checkname|modepdbidts#Other
12cR2-12cR2enq: TR - serialize TS rekeysname|modepdbidts#Other
12cR2-12cR2enq: TR - serialize system rekeysname|modepdbidts#Other
10gR1-12cR2enq: TS - contentionname|modetablespace IDdbaOther
10gR1-12cR2enq: TT - contentionname|modetablespace IDoperationOther
12cR2-12cR2enq: TU - UMF topologyname|mode00Other
10gR1-12cR2enq: TW - contentionname|mode0operationAdministrative
10gR1-12cR2enq: TX - allocate ITL entryname|modeusn<<16 | slotsequenceConfiguration
10gR1-12cR2enq: TX - contentionname|modeusn<<16 | slotsequenceOther
10gR1-12cR2enq: TX - index contentionname|modeusn<<16 | slotsequenceConcurrency
10gR1-12cR2enq: TX - row lock contentionname|modeusn<<16 | slotsequenceApplication
12cR2-12cR2enq: TZ - contentionname|modetablespace #dbaOther
12cR2-12cR2enq: UF - undo stat flush per PDBname|mode00Other
10gR1-12cR2enq: UL - contentionname|modeid0Application
12cR2-12cR2enq: UM - UMF task poolname|mode00Other
10gR1-12cR2enq: US - contentionname|modeundo segment #0Other
12cR2-12cR2enq: UT - transfer audit recordsname|modeTRANSFER AUDIT RECORDS0Other
12cR1-12cR2enq: VA - contentiontype|modeid1id2Other
12cR1-12cR2enq: VB - contentiontype|modeid1id2Other
12cR1-12cR2enq: VC - contentiontype|modeid1id2Other
12cR1-12cR2enq: VD - contentiontype|modeid1id2Other
12cR1-12cR2enq: VE - contentiontype|modeid1id2Other
12cR1-12cR2enq: VF - contentiontype|modeid1id2Other
12cR1-12cR2enq: VG - contentiontype|modeid1id2Other
12cR1-12cR2enq: VH - contentiontype|modeid1id2Other
12cR1-12cR2enq: VI - contentiontype|modeid1id2Other
12cR1-12cR2enq: VJ - contentiontype|modeid1id2Other
12cR1-12cR2enq: VK - contentiontype|modeid1id2Other
12cR1-12cR2enq: VL - contentiontype|modeid1id2Other
12cR1-12cR2enq: VM - contentiontype|modeid1id2Other
12cR1-12cR2enq: VN - contentiontype|modeid1id2Other
12cR1-12cR2enq: VO - contentiontype|modeid1id2Other
12cR1-12cR2enq: VP - contentiontype|modeid1id2Other
12cR1-12cR2enq: VQ - contentiontype|modeid1id2Other
12cR1-12cR2enq: VR - contentiontype|modeid1id2Other
12cR1-12cR2enq: VS - contentiontype|modeid1id2Other
12cR1-12cR2enq: VT - contentiontype|modeid1id2Other
12cR1-12cR2enq: VU - contentiontype|modeid1id2Other
12cR1-12cR2enq: VV - contentiontype|modeid1id2Other
12cR1-12cR2enq: VX - contentiontype|modeid1id2Other
12cR1-12cR2enq: VY - contentiontype|modeid1id2Other
12cR1-12cR2enq: VZ - contentiontype|modeid1id2Other
10gR1-12cR2enq: WA - contentionname|mode00Other
10gR1-12cR2enq: WF - contentionname|mode00Other
11gR1-12cR2enq: WG - delete fsoname|modekdlw lobid first halfkdlw lobid sec halfOther
11gR1-12cR2enq: WG - lock fsoname|modekdlw lobid first halfkdlw lobid sec halfConcurrency
12cR1-12cR2enq: WL - Far Sync Fail Overname|modelog # / thread id #sequence #Other
12cR2-12cR2enq: WL - Network Throttlename|modelog # / thread id #sequence #Other
11gR2-12cR1enq: WL - RAC-wide SGA contentionname|modelog # / thread id #sequence #Other
12cR2-12cR2enq: WL - RAC-wide SGA dumpname|modelog # / thread id #sequence #Other
12cR2-12cR2enq: WL - RAC-wide SGA initializename|modelog # / thread id #sequence #Other
12cR2-12cR2enq: WL - RAC-wide SGA writename|modelog # / thread id #sequence #Other
11gR2-12cR2enq: WL - RFS global state contentionname|modelog # / thread id #sequence #Other
12cR2-12cR2enq: WL - SNA access/lockingname|modelog # / thread id #sequence #Other
12cR1-12cR2enq: WL - Switchover To Primaryname|modelog # / thread id #sequence #Other
11gR2-12cR2enq: WL - Test access/lockingname|modelog # / thread id #sequence #Other
10gR1-12cR2enq: WL - contentionname|modelog # / thread id #sequence #Other
12cR1-12cR1enq: WL - redo_db table queryname|modelog # / thread id #sequence #Other
12cR1-12cR2enq: WL - redo_db table updatename|modelog # / thread id #sequence #Other
12cR1-12cR1enq: WL - redo_log table queryname|modelog # / thread id #sequence #Other
12cR1-12cR2enq: WL - redo_log table updatename|modelog # / thread id #sequence #Other
12cR1-12cR1enq: WL - redo_rta table queryname|modelog # / thread id #sequence #Other
12cR1-12cR1enq: WL - redo_rta table updatename|modelog # / thread id #sequence #Other
11gR1-12cR2enq: WM - WLM Plan activationname|mode00Other
10gR1-12cR2enq: WP - contentionname|mode00Other
10gR2-12cR2enq: WR - contentionname|modethread id #sequence #Other
12cR1-12cR2enq: WS - contentiontype|modeid1id2Other
12cR2-12cR2enq: WT - contentionname|mode00Other
12cR1-12cR2enq: XB - contentiontype|modeid1id2Other
11gR1-12cR2enq: XC - XDB Configurationname|modeOther
12cR1-12cR2enq: XD - ASM disk OFFLINEname|modeopcodenotusedOther
12cR1-12cR2enq: XD - ASM disk ONLINEname|modeopcodenotusedOther
11gR2-12cR2enq: XD - ASM disk drop/addname|modeopcodenotusedOther
10gR1-12cR2enq: XH - contentionname|mode00Other
12cR1-12cR2enq: XK - contentiontype|modeid1id2Other
11gR1-12cR2enq: XL - fault extent mapname|modemap idnothingOther
12cR1-12cR2enq: XM - contentiontype|modeid1id2Other
11gR2-12cR2enq: XQ - purificationname|modedisk group #unusedOther
10gR2-12cR2enq: XQ - recoveryname|modedisk group #unusedOther
10gR2-12cR2enq: XQ - relocationname|modedisk group #unusedOther
10gR1-12cR2enq: XR - database force loggingname|modeoperation0Other
10gR1-12cR2enq: XR - quiesce databasename|modeoperation0Other
10gR1-12cR2enq: XY - contentionname|modeid1id2Other
12cR1-12cR2enq: YA - contentiontype|modeid1id2Other
12cR1-12cR2enq: YB - contentiontype|modeid1id2Other
12cR1-12cR2enq: YC - contentiontype|modeid1id2Other
12cR1-12cR2enq: YD - contentiontype|modeid1id2Other
12cR1-12cR2enq: YE - contentiontype|modeid1id2Other
12cR1-12cR2enq: YF - contentiontype|modeid1id2Other
12cR1-12cR2enq: YG - contentiontype|modeid1id2Other
12cR1-12cR2enq: YH - contentiontype|modeid1id2Other
12cR1-12cR2enq: YI - contentiontype|modeid1id2Other
12cR1-12cR2enq: YJ - contentiontype|modeid1id2Other
12cR1-12cR2enq: YK - contentiontype|modeid1id2Other
12cR1-12cR2enq: YL - contentiontype|modeid1id2Other
12cR1-12cR2enq: YM - contentiontype|modeid1id2Other
12cR1-12cR2enq: YN - contentiontype|modeid1id2Other
12cR1-12cR2enq: YO - contentiontype|modeid1id2Other
12cR1-12cR2enq: YP - contentiontype|modeid1id2Other
12cR1-12cR2enq: YQ - contentiontype|modeid1id2Other
12cR1-12cR2enq: YR - contentiontype|modeid1id2Other
12cR1-12cR2enq: YS - contentiontype|modeid1id2Other
12cR1-12cR2enq: YT - contentiontype|modeid1id2Other
12cR1-12cR2enq: YU - contentiontype|modeid1id2Other
12cR1-12cR2enq: YV - contentiontype|modeid1id2Other
12cR1-12cR2enq: YX - contentiontype|modeid1id2Other
12cR1-12cR2enq: YY - contentiontype|modeid1id2Other
12cR1-12cR2enq: YZ - contentiontype|modeid1id2Other
11gR1-12cR2enq: ZA - add std audit table partitionname|modeKZAM Aud Partition0Other
12cR2-12cR2enq: ZB - contentionname|modetablespace #dbaOther
12cR2-12cR2enq: ZC - FS Seg contentionname|modetsn#objd#Other
12cR2-12cR2enq: ZD - FS CU modname|modesegidstartdbaOther
11gR1-12cR2enq: ZF - add fga audit table partitionname|modeKZAM Fga Partition0Other
10gR2-12cR2enq: ZG - contentionname|modefile group idversion idAdministrative
11gR2-12cR2enq: ZH - compression analysisname|modeobj#ulevelOther
12cR2-12cR2enq: ZL - LogMiner foreign log metadataname|modesession ID0Other
12cR2-12cR2enq: ZQ - quiescename|modets#dbaOther
12cR2-12cR2enq: ZQ - registername|modets#dbaOther
12cR2-12cR2enq: ZR - ZDLRA check quiesce tasksname|modeoperationidOther
12cR2-12cR2enq: ZR - ZDLRA check servlet quiescencename|modeoperationidOther
12cR2-12cR2enq: ZR - ZDLRA invalidate plansname|modeoperationidOther
12cR2-12cR2enq: ZR - ZDLRA lock APIname|modeoperationidOther
12cR2-12cR2enq: ZR - ZDLRA lock dbname|modeoperationidOther
12cR2-12cR2enq: ZR - ZDLRA lock schedulername|modeoperationidOther
12cR2-12cR2enq: ZR - ZDLRA lock storage locname|modeoperationidOther
12cR2-12cR2enq: ZR - ZDLRA lock timer queuename|modeoperationidOther
12cR2-12cR2enq: ZR - ZDLRA protect plansname|modeoperationidOther
12cR2-12cR2enq: ZR - ZDLRA purge storage locname|modeoperationidOther
12cR2-12cR2enq: ZR - ZDLRA quiesce servletsname|modeoperationidOther
12cR2-12cR2enq: ZR - ZDLRA quiesce tasksname|modeoperationidOther
12cR2-12cR2enq: ZR - ZDLRA run schedulername|modeoperationidOther
12cR2-12cR2enq: ZR - ZDLRA serialize unregister dbname|modeoperationidOther
12cR2-12cR2enq: ZR - ZDLRA spare enq 10name|modeoperationidOther
12cR1-12cR2enq: ZS - excl access to spill audit filename|modeSpillover audit file0Other
12cR2-12cR2enq: ZX - repopulation file writename|modefilenameblock numberOther
11gR2-12cR2enq: ZZ - update hash tablesname|modeKSBXIC Action0Other
8i-9ienqueuename|modeid1id2
10gR2-12cR2events in waitclass OtherOther
10gR1-12cR2extent map load/unlockgroupfileextentOther
12cR2-12cR2extent map lockedmidOther
11gR1-12cR2external table misc IOfilectxiocodeP3User I/O
12cR1-12cR2external table openfilectxfile#User I/O
11gR1-12cR2external table readfilectxfile#sizeUser I/O
12cR1-12cR2external table seekfilectxfile#posUser I/O
11gR1-12cR2external table writefilectxfile#sizeUser I/O
11gR1-12cR2fbar timersleep timefailedIdle
9i-9ifib/fob latch
8i-9ifile identifyfibfile nameopcode
8i-9ifile openfibiov0
12cR1-12cR2first spare wait eventp1p2p3Other
10gR1-12cR2flashback buf free by RVWROther
10gR1-12cR2flashback free VI logOther
11gR2-12cR2flashback log file readlog#block#BytesSystem I/O
11gR2-12cR2flashback log file syncUser I/O
11gR2-12cR2flashback log file writelog#block#BytesSystem I/O
10gR1-12cR2flashback log switchOther
12cR2-12cR2force-cr-override flushfile#block#Other
10gR1-10gR1foreground creation: startOther
10gR1-10gR1foreground creation: waitOther
8i-12cR2free buffer waitsfile#block#set-id#Configuration
8i-12cR2free global transaction table entrytriesOther
8i-12cR2free process state objectOther
10gR1-12cR2gc assumeleCluster
10gR1-12cR2gc block recovery requestfile#block#class#Cluster
10gR1-10gR2gc buffer busyfile#block#id#Cluster
11gR1-12cR2gc buffer busy acquirefile#block#class#Cluster
11gR1-12cR2gc buffer busy releasefile#block#class#Cluster
11gR1-12cR2gc cancel retryCluster
10gR1-12cR1gc claimCluster
12cR2-12cR2gc claimfile#block#class#Cluster
10gR1-12cR2gc cr block 2-wayCluster
10gR1-12cR2gc cr block 3-wayCluster
10gR1-12cR2gc cr block busyCluster
10gR1-12cR2gc cr block congestedCluster
10gR2-12cR2gc cr block lostCluster
10gR1-12cR1gc cr block unknownCluster
10gR1-12cR2gc cr cancelleCluster
12cR2-12cR2gc cr cluster flash cache readCluster
10gR1-12cR2gc cr disk readCluster
10gR1-12cR2gc cr disk requestfile#block#class#Cluster
10gR1-12cR2gc cr failureCluster
12cR2-12cR2gc cr flash cache copyCluster
10gR1-12cR2gc cr grant 2-wayCluster
12cR2-12cR2gc cr grant 3-wayCluster
10gR1-12cR2gc cr grant busyCluster
12cR2-12cR2gc cr grant cluster flash cache readCluster
10gR1-12cR2gc cr grant congestedCluster
12cR1-12cR2gc cr grant kaCluster
10gR1-12cR1gc cr grant unknownCluster
12cR2-12cR2gc cr multi block grantCluster
12cR2-12cR2gc cr multi block mixedCluster
10gR1-12cR2gc cr multi block requestfile#block#class#Cluster
10gR1-12cR2gc cr requestfile#block#class#Cluster
10gR1-12cR2gc current block 2-wayCluster
10gR1-12cR2gc current block 3-wayCluster
10gR1-12cR2gc current block busyCluster
10gR1-12cR2gc current block congestedCluster
10gR2-12cR2gc current block lostCluster
10gR1-12cR1gc current block unknownCluster
10gR1-12cR2gc current cancelleCluster
10gR1-12cR2gc current grant 2-wayCluster
12cR2-12cR2gc current grant 3-wayCluster
10gR1-12cR2gc current grant busyCluster
12cR2-12cR2gc current grant cluster flash cache readCluster
10gR1-12cR2gc current grant congestedCluster
12cR1-12cR2gc current grant kaCluster
10gR1-12cR1gc current grant unknownCluster
12cR2-12cR2gc current index splitleCluster
10gR1-12cR2gc current multi block requestfile#block#id#Cluster
10gR1-12cR2gc current requestfile#block#id#Cluster
10gR1-12cR2gc current retryCluster
10gR1-12cR2gc current splitCluster
10gR1-10gR1gc domain validationCluster
10gR2-12cR2gc domain validationfile#block#class#Cluster
11gR2-12cR2gc flushed bufferCluster
10gR1-12cR2gc freelistCluster
12cR2-12cR2gc imc multi block quiescefile#block#Cluster
12cR2-12cR2gc imc multi block requestfile#block#Cluster
12cR2-12cR2gc index operationusn#slot#seq#Cluster
10gR2-12cR1gc object scanCluster
10gR1-10gR2gc prepareCluster
10gR2-12cR2gc quiesceCluster
10gR1-10gR1gc quiesce waitCluster
11gR1-12cR2gc recoveryCluster
10gR1-12cR2gc recovery freeCluster
10gR1-10gR2gc recovery quiesceCluster
11gR1-12cR2gc recovery quiescefile#block#class#Cluster
10gR1-10gR1gc remasterCluster
10gR2-12cR2gc remasterfile#block#class#Cluster
12cR2-12cR2gc send completeCluster
12cR2-12cR2gc transaction tablecountCluster
10gR1-12cR2gcs ddet enter server modeOther
9i-12cR2gcs domain validationcluincrcvincOther
10gR1-12cR2gcs drm freeze beginOther
10gR1-12cR2gcs drm freeze in enter server modeOther
10gR1-12cR2gcs enter server modeOther
9i-9igcs for action
11gR2-12cR2gcs lmon dirtydetach step completiondomain idlocationOther
10gR1-12cR2gcs log flush syncwaittimepolleventOther
10gR1-12cR2gcs remastering wait for read latchOther
10gR1-11gR1gcs remastering wait for write latchOther
9i-9igcs remote messagewaittimepollp3
10gR1-12cR2gcs remote messagewaittimepolleventIdle
10gR1-12cR2gcs resource directory to be unfrozenOther
11gR2-12cR2gcs retry nowait latch getlocationOther
9i-12cR2gcs to be enabledOther
11gR1-12cR2ges DFS hang analysis phase 2 acksOther
9i-12cR2ges LMD suspend for testing eventOther
9i-12cR2ges LMD to inherit communication channelsOther
9i-12cR1ges LMD to shutdownOther
9i-9iges LMON for send buffers to be empty
9i-12cR2ges LMON for send queuesOther
9i-12cR2ges LMON to get to FTDONEOther
9i-12cR2ges LMON to join CGS groupOther
9i-9iges LMS suspend for testing event
11gR1-12cR2ges RMS0 retry add redo logOther
9i-12cR2ges cached resource cleanupwaittimeOther
9i-12cR2ges cancelOther
9i-9iges cgs de-registration
9i-9iges cgs registration
10gR1-12cR2ges cgs registrationwhereOther
11gR2-12cR2ges client process to exitOther
9i-9iges drm deferred close
9i-9iges drm freeze begin
9i-12cR2ges enter server modeOther
9i-12cR2ges generic eventOther
9i-11gR1ges global resource directory to be frozenOther
11gR2-12cR2ges global resource directory to be frozenlocationOther
9i-9iges global resource directory to be unfrozen
9i-10gR1ges inquiry responsetype|modeid1id2Other
10gR2-12cR2ges inquiry responsetype|mode|whereid1id2Other
12cR2-12cR2ges instance reconfig name entry queryretryinstOther
9i-12cR2ges lmd and pmon to attachOther
11gR2-12cR2ges lmd sync during reconfiglocationOther
11gR2-12cR2ges lmd/lmses to freeze in rcfglmd/lms idOther
9i-11gR1ges lmd/lmses to freeze in rcfg - mrcvrOther
9i-9iges lmd/lmses to freeze in rcfg - srcvr
11gR2-12cR2ges lmd/lmses to unfreeze in rcfglmd/lms idOther
9i-11gR1ges lmd/lmses to unfreeze in rcfg - mrcvrOther
9i-9iges lmd/lmses to unfreeze in rcfg - srcvr
11gR2-12cR2ges lms sync during dynamic remastering and reconfiglocationlms idOther
9i-12cR2ges master to get established for SCN opOther
11gR2-12cR2ges message buffer allocationpoolrequestallocatedOther
9i-12cR2ges performance test completionOther
9i-12cR2ges pmon to exitOther
9i-9iges proc table latch - kjdrptref
9i-9iges process allocation
9i-12cR2ges process with outstanding i/opidOther
9i-11gR1ges reconfiguration to startOther
9i-12cR2ges remote messagewaittimeloopp3Idle
9i-12cR2ges resource cleanout during enqueue openOther
9i-12cR2ges resource cleanout during enqueue open-cvtOther
10gR1-12cR2ges resource directory to be unfrozenOther
12cR1-12cR2ges resource enqueue open retry sleepOther
10gR1-12cR1ges retry query nodeOther
9i-12cR2ges reusing os pidpidcountOther
12cR2-12cR2ges server process to shutdowntypeOther
9i-9iges server qs to be empty - kjbrrit
10gR1-12cR2ges user errorerrorOther
10gR1-12cR2ges wait for lmon to be readyOther
11gR2-12cR2ges yield cpu in reconfiglocationOther
11gR1-12cR2ges/gcs diag dumplocationOther
9i-9iges1 LMON to wake up LMD
9i-12cR2ges1 LMON to wake up LMD - mrcvrOther
9i-12cR2ges2 LMON to wake up LMD - mrcvrOther
9i-9iges2 LMON to wake up LMD - srcvr
9i-12cR2ges2 LMON to wake up lms - mrcvr 2Other
10gR1-12cR2ges2 LMON to wake up lms - mrcvr 3Other
9i-12cR2ges2 proc latch in rm latch get 1Other
9i-12cR2ges2 proc latch in rm latch get 2Other
12cR2-12cR2get branch/thread/sequence enqueueOther
9i-9iglobal cache assume waitle
8i-9iglobal cache bg ackscountloops
9i-9iglobal cache busyfile#block#id
10gR1-12cR2global cache busygroupfile#block#Other
9i-9iglobal cache cancel waitle
9i-9iglobal cache claim wait
9i-9iglobal cache cr cancel waitle
9i-9iglobal cache cr disk requestfile#block#le
8i-8iglobal cache cr requestfile#block#lenum
9i-9iglobal cache cr requestfile#block#le
9i-9iglobal cache domain validation
8i-9iglobal cache freelist wait
8i-8iglobal cache lock busyfile#block#lenum
8i-8iglobal cache lock cleanupfile#block#lenum
8i-8iglobal cache lock null to sfile#block#lenum
8i-8iglobal cache lock null to xfile#block#lenum
8i-8iglobal cache lock open sfile#block#lenum
8i-8iglobal cache lock open xfile#block#lenum
8i-8iglobal cache lock s to xfile#block#lenum
8i-8iglobal cache multiple locksfile#block#lenum
9i-9iglobal cache null to sfile#block#le
9i-9iglobal cache null to xfile#block#le
9i-9iglobal cache open sfile#block#le
9i-9iglobal cache open xfile#block#le
8i-8iglobal cache pending astlenum
9i-9iglobal cache pending astle
8i-8iglobal cache pending astscount
9i-9iglobal cache pred cancel waitle
9i-9iglobal cache quiesce waitle
9i-9iglobal cache recovery free wait
9i-9iglobal cache recovery quiesce waitle
9i-9iglobal cache remastering wait
8i-9iglobal cache retry preparefile#block#
8i-8iglobal cache retry requestfile#block#
9i-9iglobal cache s to xfile#block#le
10gR1-12cR2global enqueue expand waitOther
11gR2-12cR2global plug and play automatic resource creationwhereOther
12cR1-12cR2gopp msggopp idIdle
11gR2-12cR2heartbeat monitor sleepIdle
12cR1-12cR2heartbeat redo informerIdle
9i-12cR2i/o slave waitmsg ptrOther
12cR2-12cR2imco timersleep timefailedIdle
8i-12cR2imm opmsg ptrOther
8i-10gR2inactive sessionsession#waitedOther
11gR1-12cR1inactive sessionsession#waitedinstance|serialOther
12cR2-12cR2inactive sessionsession#serialinstanceOther
8i-12cR2inactive transaction branchbranch#waitedOther
9i-12cR2index (re)build online cleanupobjectmodewaitAdministrative
9i-12cR2index (re)build online mergeobjectmodewaitAdministrative
9i-12cR2index (re)build online startobjectmodewaitAdministrative
8i-12cR2index block splitrootdbalevelchilddbaOther
12cR2-12cR2influx scnfile#block#class#Other
8i-9iinstance recoveryundo segment#
8i-12cR2instance state changelayervaluewaitedOther
8i-12cR2io donemsg ptrSystem I/O
12cR1-12cR2ioctl to cell offload devicecellhash#Other
12cR1-12cR2iowp file idiowp idIdle
12cR1-12cR2iowp iocountintrtimeoutSystem I/O
12cR1-12cR2iowp msgiowp idIdle
10gR1-12cR2job scheduler coordinator slave waitOther
10gR2-12cR2jobq slave TJ process waitOther
10gR2-12cR2jobq slave shutdown waitOther
9i-12cR2jobq slave waitIdle
9i-12cR2kcbzpsOther
9i-11gR1kcrrrcpOther
10gR2-12cR2kdblil wait before retrying ORA-54Other
9i-12cR2kdic_do_mergeOther
10gR1-12cR2kfcl: instance recoverygroupobj#block#Other
10gR1-11gR2kfk: async disk IOcountintrtimeoutSystem I/O
12cR1-12cR2kfk: async disk IOcountwheretimeoutSystem I/O
9i-12cR2kgltwaitOther
12cR2-12cR2kill all read-only instances in clusterOther
10gR1-12cR2kjbdomalc allocate recovery domain - retryOther
10gR1-11gR1kjbdrmcvtq lmon drm quiesce: ping completionOther
11gR2-12cR2kjbdrmcvtq lmon drm quiesce: ping completionlocationlms idOther
10gR1-12cR2kjbopen wait for recovery domain attachOther
9i-12cR2kjctcisnd: Queue/Send client messageOther
9i-12cR2kjctssqmg: quick message send waitOther
10gR1-12cR2kjudomatt wait for recovery domain attachOther
10gR1-12cR2kjudomdet wait for recovery domain detachOther
9i-12cR2kjxgrtestOther
9i-12cR2kkdlgonOther
9i-12cR2kkdlhponOther
9i-12cR2kkdlsiponOther
9i-12cR2kksfbc child completionOther
9i-12cR2kksfbc researchOther
9i-12cR2kkshgnc reloopOther
9i-12cR2kksscl hash splitOther
9i-10gR1knlWaitForStartupOther
9i-10gR1knlqdeqOther
9i-12cR2knpc_acwm_AwaitChangedWaterMarkOther
9i-12cR2knpc_anq_AwaitNonemptyQueueOther
9i-12cR2knpsmaiOther
10gR2-12cR2kpodplck wait before retrying ORA-54Other
9i-12cR2ksbcicOther
9i-12cR2ksbsrvOther
9i-12cR2ksdxexeotherOther
9i-12cR2ksdxexeotherwaitOther
10gR1-11gR1ksfd: async disk IOcountintrtimeoutSystem I/O
10gR1-10gR1ksfd: fib/fob latchOther
10gR1-12cR2ksim generic wait eventwherewait_countOther
9i-9iksimret is busy in recoverywait_count
11gR1-12cR2kslwait unit test event 1p1p2p3Scheduler
11gR1-12cR2kslwait unit test event 2p1p2p3Other
11gR1-12cR2kslwait unit test event 3p1p2p3Other
9i-10gR2ksqdedOther
10gR2-10gR2kst: async disk IOcountintrtimeoutSystem I/O
9i-9iksu process alloc latch yield
10gR1-12cR2ksv slave avail waitOther
9i-12cR2ksxr poll remote instancesOther
10gR2-12cR2ksxr wait for mount sharedOther
10gR1-12cR2ktfbtgextsnOther
10gR1-12cR2ktm: instance recoveryundo segment#Other
9i-12cR2ktsamblOther
9i-12cR2kttm2dOther
10gR1-12cR2kupp process waitOther
9i-12cR2kxfxsekxfxse debug wait: stalling for slave 0Other
9i-12cR2kxfxspkxfxsp debug wait: stalling for slave 0Other
8i-12cR2latch activityaddressnumberprocess#Other
8i-12cR1latch freeaddressnumbertriesOther
12cR2-12cR2latch freeaddressnumberwhyOther
12cR2-12cR2latch: AQ OPT Background Master LatchaddressnumberwhyOther
12cR2-12cR2latch: AQ Sharded subscriber statistics latchaddressnumberwhyOther
10gR2-12cR1latch: Change Notification Hash table latchaddressnumbertriesOther
12cR2-12cR2latch: Change Notification Hash table latchaddressnumberwhyOther
12cR2-12cR2latch: Column stats entry latchaddressnumberwhyOther
12cR2-12cR2latch: GCS logfile blockaddressnumberwhyOther
12cR2-12cR2latch: GCS logfile write queueaddressnumberwhyOther
12cR1-12cR1latch: ILM access tracking extentaddressnumbertriesOther
12cR2-12cR2latch: ILM access tracking extentaddressnumberwhyOther
12cR1-12cR1latch: ILM activity tracking latchaddressnumbertriesOther
12cR2-12cR2latch: ILM activity tracking latchaddressnumberwhyOther
12cR2-12cR2latch: IM area sb latchaddressnumberwhyOther
12cR2-12cR2latch: IM area scb latchaddressnumberwhyOther
12cR2-12cR2latch: IM emb latchaddressnumberwhyOther
12cR2-12cR2latch: IM seg hdr latchaddressnumberwhyOther
12cR2-12cR2latch: IMFS defer write listaddressnumberwhyOther
10gR1-12cR1latch: In memory undo latchaddressnumbertriesConcurrency
12cR2-12cR2latch: In memory undo latchaddressnumberwhyConcurrency
10gR1-10gR2latch: KCL gc element parent latchaddressnumbertriesOther
10gR1-12cR1latch: MQL Tracking LatchaddressnumbertriesConcurrency
12cR2-12cR2latch: MQL Tracking LatchaddressnumberwhyConcurrency
11gR2-12cR1latch: PX hash array latchaddressnumbertriesOther
12cR2-12cR2latch: PX hash array latchaddressnumberwhyOther
12cR1-12cR1latch: SGA Logging Bkt LatchaddressnumbertriesOther
12cR2-12cR2latch: SGA Logging Bkt LatchaddressnumberwhyOther
12cR1-12cR1latch: SGA Logging Log LatchaddressnumbertriesOther
12cR2-12cR2latch: SGA Logging Log LatchaddressnumberwhyOther
10gR2-12cR1latch: Undo Hint LatchaddressnumbertriesConcurrency
12cR2-12cR2latch: Undo Hint LatchaddressnumberwhyConcurrency
11gR2-12cR1latch: WCR: processes HTaddressnumbertriesOther
12cR2-12cR2latch: WCR: processes HTaddressnumberwhyOther
11gR2-12cR1latch: WCR: syncaddressnumbertriesOther
12cR2-12cR2latch: WCR: syncaddressnumberwhyOther
12cR1-12cR1latch: active service listaddressnumbertriesOther
12cR2-12cR2latch: active service listaddressnumberwhyOther
10gR1-12cR1latch: cache buffer handlesaddressnumbertriesOther
12cR2-12cR2latch: cache buffer handlesaddressnumberwhyOther
10gR1-12cR1latch: cache buffers chainsaddressnumbertriesConcurrency
12cR2-12cR2latch: cache buffers chainsaddressnumberwhyConcurrency
10gR1-12cR1latch: cache buffers lru chainaddressnumbertriesOther
12cR2-12cR2latch: cache buffers lru chainaddressnumberwhyOther
11gR2-12cR1latch: call allocationaddressnumbertriesOther
12cR2-12cR2latch: call allocationaddressnumberwhyOther
11gR1-12cR1latch: change notification client cache latchaddressnumbertriesOther
12cR2-12cR2latch: change notification client cache latchaddressnumberwhyOther
10gR1-12cR1latch: checkpoint queue latchaddressnumbertriesOther
12cR2-12cR2latch: checkpoint queue latchaddressnumberwhyOther
10gR1-12cR1latch: enqueue hash chainsaddressnumbertriesOther
12cR2-12cR2latch: enqueue hash chainsaddressnumberwhyOther
11gR1-12cR1latch: gc elementaddressnumbertriesOther
12cR2-12cR2latch: gc elementaddressnumberwhyOther
10gR1-12cR1latch: gcs resource hashaddressnumbertriesOther
12cR2-12cR2latch: gcs resource hashaddressnumberwhyOther
10gR1-12cR1latch: ges resource hash listaddressnumbertriesOther
12cR2-12cR2latch: ges resource hash listaddressnumberwhyOther
12cR1-12cR1latch: kjci process context latchaddressnumbertriesOther
12cR2-12cR2latch: kjci process context latchaddressnumberwhyOther
12cR1-12cR1latch: kjci request sequence latchaddressnumbertriesOther
12cR2-12cR2latch: kjci request sequence latchaddressnumberwhyOther
12cR1-12cR1latch: kjoeq omni enqueue hash bucket latchaddressnumbertriesOther
12cR2-12cR2latch: kjoeq omni enqueue hash bucket latchaddressnumberwhyOther
12cR1-12cR1latch: kjoer owner hash bucketaddressnumbertriesOther
12cR2-12cR2latch: kjoer owner hash bucketaddressnumberwhyOther
12cR1-12cR1latch: ksm sga alloc latchaddressnumbertriesOther
12cR2-12cR2latch: ksm sga alloc latchaddressnumberwhyOther
12cR1-12cR1latch: ksolt allocaddressnumbertriesOther
12cR2-12cR2latch: ksolt lwth allocaddressnumberwhyOther
10gR1-10gR1latch: latch wait listaddressnumbertriesOther
10gR1-10gR2latch: library cacheaddressnumbertriesConcurrency
10gR1-10gR2latch: library cache lockaddressnumbertriesConcurrency
10gR1-10gR2latch: library cache pinaddressnumbertriesConcurrency
11gR1-12cR1latch: lob segment dispenser latchaddressnumbertriesOther
12cR2-12cR2latch: lob segment dispenser latchaddressnumberwhyOther
11gR1-12cR1latch: lob segment hash table latchaddressnumbertriesOther
12cR2-12cR2latch: lob segment hash table latchaddressnumberwhyOther
11gR1-12cR1latch: lob segment query latchaddressnumbertriesOther
12cR2-12cR2latch: lob segment query latchaddressnumberwhyOther
10gR1-12cR1latch: messagesaddressnumbertriesOther
12cR2-12cR2latch: messagesaddressnumberwhyOther
10gR1-10gR2latch: object queue header heapaddressnumbertriesOther
10gR1-12cR1latch: object queue header operationaddressnumbertriesOther
12cR2-12cR2latch: object queue header operationaddressnumberwhyOther
10gR1-12cR1latch: parallel query alloc bufferaddressnumbertriesOther
12cR2-12cR2latch: parallel query alloc bufferaddressnumberwhyOther
12cR2-12cR2latch: pdb enqueue hash chainsaddressnumberwhyOther
10gR1-12cR1latch: redo allocationaddressnumbertriesOther
12cR2-12cR2latch: redo allocationaddressnumberwhyOther
10gR1-12cR1latch: redo copyaddressnumbertriesConfiguration
12cR2-12cR2latch: redo copyaddressnumberwhyConfiguration
10gR1-12cR1latch: redo writingaddressnumbertriesConfiguration
12cR2-12cR2latch: redo writingaddressnumberwhyConfiguration
10gR1-12cR1latch: row cache objectsaddressnumbertriesOther
12cR2-12cR2latch: row cache objectsaddressnumberwhyConcurrency
12cR2-12cR2latch: service drain listaddressnumberwhyOther
10gR1-12cR1latch: session allocationaddressnumbertriesOther
12cR2-12cR2latch: session allocationaddressnumberwhyOther
10gR1-12cR1latch: shared pooladdressnumbertriesConfiguration
12cR2-12cR2latch: shared pooladdressnumberwhyConcurrency
10gR1-12cR1latch: undo global dataaddressnumbertriesOther
12cR2-12cR2latch: undo global dataaddressnumberwhyOther
10gR1-12cR1latch: virtual circuit queuesaddressnumbertriesOther
12cR2-12cR2latch: virtual circuit queuesaddressnumberwhyOther
12cR1-12cR2libcache interrupt action by LCKlocationConcurrency
8i-8ilibrary cache load lockobject addresslock address10*mask+namespace
9i-12cR2library cache load lockobject addresslock address100*mask+namespaceConcurrency
8i-8ilibrary cache lockhandle addresslock address10*mode+namespace
9i-12cR2library cache lockhandle addresslock address100*mode+namespaceConcurrency
8i-8ilibrary cache pinhandle addresspin address10*mode+namespace
9i-12cR2library cache pinhandle addresspin address100*mode+namespaceConcurrency
10gR1-12cR2library cache revalidationOther
10gR2-12cR2library cache shutdownOther
12cR2-12cR2library cache: bucket mutex XidnvaluewhereConcurrency
12cR2-12cR2library cache: dependency mutex XidnvaluewhereConcurrency
11gR1-12cR2library cache: mutex SidnvaluewhereConcurrency
11gR1-12cR2library cache: mutex XidnvaluewhereConcurrency
12cR1-12cR1lightweight thread operationPURPOSELTHREAD TYPEOther
12cR2-12cR2lightweight thread operationPURPOSEARG1ARG2Other
12cR2-12cR2lightweight thread task completionTasks lefttask_countARG3Other
8i-12cR2listen endpoint statusend-point#statusOther
11gR1-12cR2listener registration dumpdumpOther
10gR2-11gR1lms flush message acksloctriesOther
11gR2-12cR2lms flush message acksidOther
8i-12cR2local write waitfile#block#User I/O
10gR1-12cR2lock closegrouplms#Other
9i-12cR2lock deadlock retryOther
9i-12cR2lock escalate retryOther
8i-8ilock manager wait for dlmd to shutdown
8i-8ilock manager wait for remote messagewaittime
10gR1-12cR2lock release pendinggroupfile#block#Other
10gR1-12cR2lock remasteringCluster
8i-12cR2log buffer spaceConfiguration
8i-12cR2log file parallel writefilesblocksrequestsSystem I/O
8i-12cR2log file sequential readlog#block#blocksSystem I/O
8i-12cR2log file single writelog#block#blocksSystem I/O
8i-12cR2log file switch (archiving needed)Configuration
8i-12cR2log file switch (checkpoint incomplete)Configuration
8i-12cR2log file switch (clearing log file)Other
10gR2-12cR2log file switch (private strand flush incomplete)Configuration
8i-12cR2log file switch completionConfiguration
8i-11gR1log file syncbuffer#Commit
11gR2-12cR2log file syncbuffer#sync scnCommit
12cR2-12cR2log file sync: PDB shutdown abortsync scnOther
12cR1-12cR2log file sync: SCN orderingbuffer#sync scnConcurrency
8i-12cR2log switch/archivethread#Other
10gR1-12cR2log write(even)group#Other
10gR1-12cR2log write(odd)group#Other
9i-12cR2logout restrictorConcurrency
12cR1-12cR2lreg timersuccwaitfailIdle
12cR1-12cR2master diskmon readOther
11gR1-12cR2master diskmon startupOther
10gR1-12cR2master exitalive slavesOther
8i-12cR2multiple dbwriter suspend/resume for file offlineAdministrative
9i-9iname service busy
8i-12cR2name-service call waitwaittimeOther
12cR1-12cR2netp networknetp idIdle
10gR1-12cR2no free buffersgroup#obj#block#Other
10gR1-12cR2no free locksOther
12cR2-12cR2nologging fetch slave idleIdle
12cR1-12cR2nologging range consumption listConfiguration
12cR1-12cR2nologging standby txn commitCommit
9i-12cR2null eventOther
12cR1-12cR2opening cell offload devicecellhash#Other
9i-12cR2opishdOther
10gR2-12cR2optimizer stats update retryOther
12cR1-12cR2oracle thread bootstrappnameOther
12cR1-12cR2os thread creationpnameis_processOther
10gR2-11gR2os thread startupConcurrency
11gR1-12cR2parallel recovery change buffer freeOther
11gR1-12cR2parallel recovery control message replyOther
11gR1-12cR2parallel recovery coord send blockedOther
11gR1-12cR2parallel recovery coord wait for replyOther
12cR1-12cR2parallel recovery coord: all repliesOther
12cR1-12cR2parallel recovery coordinator idle waitIdle
9i-10gR2parallel recovery coordinator waits for cleanup of slavesIdle
11gR1-12cR2parallel recovery coordinator waits for slave cleanupIdle
11gR1-12cR2parallel recovery read buffer freeOther
12cR2-12cR2parallel recovery redo cache buffer freeOther
11gR1-12cR2parallel recovery slave idle waitIdle
11gR1-12cR2parallel recovery slave next changeIdle
11gR1-12cR2parallel recovery slave wait for changeOther
8i-12cR2pending global transaction(s)scansOther
9i-12cR2pi renounce write completefile#block#Cluster
8i-12cR2pipe gethandle addressbuffer lengthtimeoutIdle
8i-12cR2pipe puthandle addressrecord lengthtimeoutConcurrency
12cR2-12cR2pman timerIdle
12cR2-12cR2pmon cleanupopOther
12cR1-12cR1pmon cleanup on exitopOther
11gR2-12cR2pmon dblkr tst eventindexOther
8i-8ipmon rdomain attach
12cR2-12cR2pmon shutdowntypenumOther
8i-12cR2pmon timerdurationIdle
11gR1-12cR2pool server timersleep timeIdle
12cR1-12cR2prefetch warmup block being transferredfile#block#id#Other
10gR2-11gR2prewarm transfer retryOther
10gR2-12cR2prior spawner clean upprocess_pidprocess_snoOther
12cR2-12cR2process allocation slotOther
11gR1-12cR2process diagnostic dumpOther
12cR2-12cR2process in prespawned stateIdle
10gR1-11gR2process shutdowntypeprocess#waitedOther
12cR1-12cR2process shutdowntypeprocess#Other
8i-11gR2process startuptypeprocess#waitedOther
12cR1-12cR2process startuptypeprocess#Other
10gR2-12cR2process terminateOther
10gR1-12cR2qerex_gdmlOther
8i-10gR1queue messagesqueue idprocess#wait timeIdle
10gR1-11gR2queue slave messagesOther
9i-9iqxdid_gdml
8i-12cR2rdbms ipc messagetimeoutIdle
8i-12cR2rdbms ipc message blockOther
8i-11gR2rdbms ipc replyfrom_processtimeoutOther
12cR1-12cR2rdbms ipc replyfrom_processOther
10gR1-12cR2read by other sessionfile#block#class#User I/O
11gR1-12cR2readable standby redo apply remasteringOther
12cR1-12cR2reap block level offload operationsslowcellhash#Other
12cR2-12cR2recovery active instance mapping setupOther
12cR2-12cR2recovery apply pendingOther
10gR1-12cR2recovery area: computing applied logsOther
10gR1-12cR2recovery area: computing backed up filesOther
10gR1-12cR2recovery area: computing dropped filesOther
10gR1-10gR2recovery area: computing identical filesOther
10gR1-12cR2recovery area: computing obsolete filesOther
11gR1-12cR2recovery buffer pinnedfile#block#Other
12cR2-12cR2recovery cancelOther
12cR2-12cR2recovery checkpointOther
12cR2-12cR2recovery coordinator apply pendingOther
12cR2-12cR2recovery coordinator idleIdle
12cR2-12cR2recovery coordinator marker applyOther
12cR2-12cR2recovery coordinator messageOther
12cR2-12cR2recovery file header update for checkpointOther
12cR2-12cR2recovery file header update for fuzzinessOther
12cR2-12cR2recovery fuzzy updateOther
11gR2-12cR2recovery instance recovery completionOther
12cR2-12cR2recovery logmerger idleIdle
12cR2-12cR2recovery marker applyOther
12cR2-12cR2recovery merge pendingOther
12cR1-12cR1recovery merger idle waitIdle
12cR2-12cR2recovery messageOther
12cR2-12cR2recovery metadata latchOther
12cR2-12cR2recovery move influx buffersOther
12cR2-12cR2recovery new thread enableOther
9i-12cR2recovery readSystem I/O
12cR1-12cR2recovery receive buffer freeOther
12cR2-12cR2recovery receiver idleIdle
12cR1-12cR1recovery receiver idle waitIdle
12cR2-12cR2recovery remote file verificationOther
12cR1-12cR2recovery send buffer freeOther
12cR2-12cR2recovery sender idleIdle
12cR1-12cR1recovery sender idle waitIdle
12cR2-12cR2recovery shutdownOther
12cR2-12cR2recovery slaves to be informedOther
12cR2-12cR2recovery timestampOther
12cR2-12cR2redo log switch request completionOther
8i-10gR1refresh controlfile commandAdministrative
8i-12cR2reliable messagechannel contextchannel handlebroadcast messageOther
11gR1-12cR2remote db file readclientidcountintrNetwork
11gR1-12cR2remote db file writeclientidcountintrNetwork
11gR1-12cR2remote db operationclientidoperationtimeoutNetwork
12cR2-12cR2remote log force - SCN rangefile#block#class#Cluster
12cR1-12cR2remote log force - buffer readfile#block#class#Cluster
12cR1-12cR1remote log force - buffer sendfile#block#class#Cluster
12cR1-12cR2remote log force - buffer updatefile#block#class#Cluster
12cR1-12cR1remote log force - commitCommit
12cR2-12cR2remote log force - committhread#thread scnsession scnCommit
12cR1-12cR1remote log force - log switch/recoveryforce SCNCluster
12cR2-12cR2remote log force - log switch/recoverythread#thread SCNforce SCNCluster
12cR2-12cR2remote log force - session cleanoutthread#thread scnsession scnCluster
12cR2-12cR2resmgr: I/O rate limitlocationScheduler
12cR2-12cR2resmgr: redo throttleScheduler
11gR1-11gR1resmgr:I/O prioritizationlocationScheduler
10gR1-12cR2resmgr:become activelocationScheduler
10gR1-11gR2resmgr:cpu quantumlocationScheduler
12cR1-12cR2resmgr:cpu quantumlocationconsumer group idScheduler
10gR1-12cR2resmgr:internal state changelocationConcurrency
10gR1-12cR2resmgr:internal state cleanuplocationOther
11gR2-12cR2resmgr:large I/O queuedlocationScheduler
12cR2-12cR2resmgr:plan changecon_idOther
12cR1-12cR2resmgr:pq queuedlocationScheduler
10gR1-12cR2resmgr:sessions to exitlocationConcurrency
11gR2-12cR1resmgr:small I/O queuedlocationScheduler
8i-9iresmgr:wait in actses run
9i-9iresmgr:waiting for cschlat1
9i-9iresmgr:waiting for cschlat2
9i-9iresmgr:waiting for cschlat3
9i-9iresmgr:waiting for cschlat4
8i-9iresmgr:waiting in check
8i-9iresmgr:waiting in check2
8i-9iresmgr:waiting in end wait
8i-9iresmgr:waiting in end wait2
8i-9iresmgr:waiting in enter
8i-9iresmgr:waiting in enter2
8i-9iresmgr:waiting in run (queued)
8i-9iresmgr:waiting in shutdown
8i-9iresmgr:waiting in system stop
12cR2-12cR2result cache lock waitobject noConcurrency
12cR2-12cR2retry cftxn during closeOther
8i-12cR2retry contact SCN lock masterCluster
10gR1-10gR1rfc_open_retryDMON waiting to retry configuration file openOther
10gR1-10gR2rfi_drcx_site_delDRCX waiting for site to delete metadataOther
10gR1-10gR2rfi_insv_shutwait for INSV to shutdownOther
10gR1-10gR2rfi_insv_startwait for INSV to startOther
10gR1-10gR2rfi_nsv_deldefNSVx to defer delete response message post to DMONOther
10gR1-10gR2rfi_nsv_md_closeNSVx metadata file close waitOther
10gR1-10gR2rfi_nsv_md_writeNSVx metadata file write waitOther
10gR1-10gR2rfi_nsv_postdefNSVx to defer message post to DMONOther
10gR1-10gR2rfi_nsv_shutwait for NSVx to shutdownOther
10gR1-10gR2rfi_nsv_startwait for NSVx to startOther
10gR1-10gR2rfi_recon1letting site register with its local listener before connect retOther
10gR1-10gR2rfi_recon2retrying connection for sending to remote DRCXOther
10gR1-10gR2rfm_dmon_last_gaspDMON waiting on the last gasp eventOther
10gR1-10gR2rfm_dmon_pdeferDMON phase deferral waitOther
10gR1-10gR2rfm_dmon_shutwait for DMON to shutdownOther
10gR1-10gR2rfm_dmon_timeout_opDMON waiting to timeout an operationOther
10gR1-10gR2rfm_pmon_dso_stallPMON delete state object stallOther
10gR1-10gR2rfrdb_dbopwaiting for database to be openedOther
10gR1-10gR2rfrdb_recon1reconnecting back to new primary site during standby viability cOther
10gR1-10gR2rfrdb_recon2waiting for standby database to be mountedOther
10gR1-10gR2rfrdb_try235waiting for retrying the query to mask ORA-235 errorOther
10gR1-10gR2rfrla_lapp1waiting for logical apply engine to initializeOther
10gR1-10gR2rfrla_lapp2checking for logical apply engine run-down progressOther
10gR1-10gR2rfrla_lapp3waiting for new primary to initialize tablesOther
10gR1-10gR2rfrla_lapp4waiting for v$logstdby_stats view to be initializedOther
10gR1-10gR2rfrla_lapp5waiting to reconnect to primary that is in BUILD_UPOther
10gR2-10gR2rfrld_rhmrpwaitwaiting for MRP0 to stop while reinstating old primary to logicaOther
10gR1-10gR2rfrm_dbclRSM notifier: waiting for sql latch on db closeOther
10gR1-10gR2rfrm_dbopRSM notifier: waiting for sql latch on db openOther
10gR1-10gR2rfrm_nonzero_sub_countwait for subscriber count to become nonzeroOther
10gR1-10gR2rfrm_rsm_shutwait for RSMx processes to shutdownOther
10gR1-10gR2rfrm_rsm_so_attachwait for RSMx to attach to state objectOther
10gR1-10gR2rfrm_rsm_startwait for RSMx processes to startOther
10gR1-10gR2rfrm_stallRSM stall due to event RSM_STALLOther
10gR1-10gR2rfrm_zero_sub_countwait for subscriber count to become zeroOther
10gR1-10gR2rfrpa_mrpdnwaiting for MRP0 to stop while bringing physical apply engine ofOther
10gR1-10gR2rfrpa_mrpupwaiting for MRP0 to start while bringing physical apply engine oOther
10gR1-10gR2rfrxpt_pdlwaiting for retrying potential dataloss calculation before switcOther
9i-10gR2rfrxptarcurlogwaiting for logical apply engine to finish initializationOther
10gR1-12cR2rollback operations activeoperation countOther
10gR1-12cR2rollback operations block fullmax operationsOther
10gR2-12cR2rolling migration: cluster quiescelocationwaitsOther
12cR1-12cR2row cache cleanupOther
8i-12cR2row cache lockcache idmoderequestConcurrency
12cR2-12cR2row cache mutexcache idwhere requestedConcurrency
12cR1-12cR2row cache processlocationOther
9i-11gR2row cache readcache idaddresstimesConcurrency
12cR1-12cR2row cache readcache idConcurrency
9i-9isbtbackup
9i-9isbtclose
9i-9isbtclose2
9i-9isbtcommand
9i-9isbtend
9i-9isbterror
9i-9isbtinfo
9i-9isbtinfo2
9i-9isbtinit
9i-9isbtinit2
9i-9isbtopen
9i-9isbtpcbackup
9i-9isbtpccancel
9i-9isbtpccommit
9i-9isbtpcend
9i-9isbtpcquerybackup
9i-9isbtpcqueryrestore
9i-9isbtpcrestore
9i-9isbtpcstart
9i-9isbtpcstatus
9i-9isbtpcvalidate
9i-9isbtread
9i-9isbtread2
9i-9isbtremove
9i-9isbtremove2
9i-9isbtrestore
9i-9isbtwrite
9i-9isbtwrite2
12cR1-12cR2second spare wait eventp1p2p3Other
8i-12cR2secondary eventevent #wait timeOther
11gR1-12cR2securefile chain updateseghdrfsbConcurrency
11gR1-12cR2securefile direct-read completionUser I/O
11gR1-12cR2securefile direct-write completionUser I/O
9i-12cR2select waitOther
12cR2-12cR2service monitor: inst recovery completionCluster
10gR2-12cR1set director factor waitOther
11gR1-12cR2shared server idle waitIdle
12cR1-12cR2shutdown after switchover to standbyOther
10gR1-12cR2simulated log write delayOther
8i-12cR2single-task messageIdle
9i-10gR1slave TJ process waitOther
8i-12cR2slave exitnalivesleeptimeloopOther
9i-10gR1slave shutdown waitOther
8i-8islave waitmsg ptr
8i-12cR2smon timersleep timefailedIdle
8i-12cR2sort segment requestConfiguration
11gR1-12cR2standby query scn advanceOther
9i-12cR2statement suspendedwait error to be cleared
8i-12cR2switch logfile commandAdministrative
9i-12cR2switch undo - offlineAdministrative
12cR2-12cR2tablespace key changepdb#ts#file#Other
12cR1-12cR2target log write sizeOther
10gR1-12cR2test long opsOther
8i-10gR1trace continuedelay timeOther
8i-10gR1trace unfreezeOther
8i-10gR1trace writer I/OOther
8i-10gR1trace writer flushOther
8i-12cR2transactionundo seg#|slot#wrap#countOther
10gR2-12cR2tsm with timeoutOther
12cR2-12cR2txn cache read versionOther
9i-12cR2txn to completeOther
8i-12cR2unbound txOther
8i-12cR2undo segment extensionsegment#Configuration
8i-12cR2undo segment recoverysegment#tx flagsOther
8i-12cR2undo segment tx slotsegment#Configuration
10gR2-12cR2undo_retention publish retrywhereretry_countOther
8i-8iunread messagechannel contextchannel handle
8i-8iunread messagechannel contextchannel handle count
9i-9iunspecified event
10gR1-12cR2unspecified wait eventOther
11gR2-12cR2utl_file I/OUser I/O
12cR1-12cR2virtual circuit next requestcircuit#typeIdle
8i-10gR2virtual circuit statuscircuit#statusIdle
11gR1-12cR2virtual circuit waitcircuit#typeNetwork
10gR1-12cR2wait active processesOther
8i-8iwait for DLM latchlatchtypegetsimmediate
8i-8iwait for DLM process allocation
8i-8iwait for DLM reconfiguration to complete
10gR1-10gR2wait for EMON to dieOther
10gR1-12cR2wait for EMON to process ntfnsConfiguration
8i-12cR2wait for EMON to spawnOther
9i-12cR2wait for FMON to come upOther
11gR1-11gR1wait for IMR CSS join retryretry countOther
8i-8iwait for LMON to get to FTDONE
9i-10gR1wait for Logical Standby Apply shutdownOther
9i-12cR2wait for MTTR advisory state objectOther
10gR1-10gR1wait for SGA component shrinkcomponent idcurrent sizetarget sizeOther
9i-12cR2wait for a paralle reco to abortOther
9i-12cR2wait for a undo recordOther
9i-10gR1wait for activate messageIdle
9i-12cR2wait for another txn - rollback to savepointOther
9i-12cR2wait for another txn - txn abortOther
9i-12cR2wait for another txn - undo rcv abortOther
9i-12cR2wait for assert messages to be sentOther
8i-8iwait for cached resource cleanup by LMONwaittime
10gR1-12cR2wait for changeOther
8i-8iwait for checking DLM domain
8i-8iwait for gms de-registration
8i-8iwait for gms registration
8i-8iwait for influx DLM latchlatchtypelatchaddr
8i-8iwait for inquiry responsetype|modeid1id2
11gR1-12cR2wait for kkpo ref-partitioning *TEST EVENT*whereOther
8i-8iwait for lmd and pmon to attach DLM
8i-8iwait for lock db to become frozen
8i-8iwait for lock db to unfreeze
9i-9iwait for master scnwaittime
10gR1-12cR2wait for master scnwaittimestartscnackscnOther
8i-8iwait for master to get estableshed for SCN op
9i-9iwait for membership change
9i-11gR1wait for membership synchronizationOther
9i-11gR1wait for message ackOther
8i-8iwait for ownership of group-owned lock
8i-8iwait for pmon to exit
9i-12cR2wait for possible quiesce finishAdministrative
8i-8iwait for process with outstanding i/opid
8i-8iwait for reconfiguration to start
9i-11gR1wait for record updateOther
8i-8iwait for recovery domain attach
8i-8iwait for recovery domain latch in kjpr
8i-8iwait for recovery validate to complete
8i-8iwait for register recovery to complete
8i-8iwait for res latch in recovery
10gR1-10gR1wait for resize request completionOther
8i-8iwait for resource cleanout during lock open
8i-8iwait for resource cleanout during lock open-cvt
8i-8iwait for reusing os pidpidcount
9i-11gR1wait for rr lock releaseOther
10gR1-12cR1wait for scn ackpending_ndscnwrpscnbasOther
12cR2-12cR2wait for scn ackpending_ndscnOther
9i-9iwait for scn from all nodeswaittime
8i-8iwait for send buffers to send DLM message
10gR1-10gR1wait for sga_target resizeOther
9i-11gR1wait for split-brain resolutionOther
9i-12cR2wait for stopper event to be increasedOther
9i-12cR2wait for sync ackcluincpending_ndOther
8i-8iwait for tickets to send DLM message
9i-11gR1wait for tmc2 to completeOther
9i-10gR1wait for transactionIdle
9i-12cR2wait for unread message on broadcast channelchannel contextchannel handleIdle
9i-12cR2wait for unread message on multiple broadcast channelschannel contextchannel handle countIdle
9i-12cR2wait for verification ackcluincpending_instsOther
9i-11gR1wait for votesOther
8i-8iwait in DLM enter server mode
8i-8iwait in DLM lock cancel
9i-12cR2wait list latch activityaddressnumberprocess#Other
9i-12cR1wait list latch freeaddressnumbertriesOther
12cR2-12cR2wait list latch freeaddressnumberOther
10gR1-10gR1waiting for low memory condition to be resolvedIdle
10gR1-10gR1waiting for subscribers to catch upIdle
8i-12cR1waiting to get CAS latchOther
9i-12cR1waiting to get RM CAS latchOther
10gR1-10gR1wakeup blocked enqueuersOther
9i-10gR1wakeup event for builderIdle
9i-10gR1wakeup event for preparerIdle
9i-10gR1wakeup event for readerIdle
8i-10gR1wakeup time managerIdle
10gR2-12cR2watchdog main loopIdle
8i-12cR2write complete waitsfile#block#Configuration
11gR2-12cR2write complete waits: flash cachefile#block#Configuration
8i-12cR2writes stopped by instance recovery or database suspensionby thread#our thread#Other
10gR2-12cR2xdb schema cache initializationOther
カスタム検索

★ORACLE案件承ります
▼ORACLE掲示板