待機イベント一覧

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



 version:  class:
versionnamep1p2p3class
11gR2-12cR1ADR block file readOther
11gR2-12cR1ADR block file writeOther
11gR2-12cR1ADR file lockOther
12cR1-12cR1AQ Background Master: slave startOther
12cR1-12cR1AQ Cross Master idleIdle
10gR1-10gR1AQ Deallocate WaitConfiguration
10gR1-10gR1AQ Proxy Cleanup WaitIdle
12cR1-12cR1AQ master shutdownOther
12cR1-12cR1AQ master: time mgmt/task cleanupOther
11gR1-12cR1AQ propagation connectionOther
12cR1-12cR1AQ reload SO releaseOther
12cR1-12cR1AQ slave: time mgmt/task cleanupOther
11gR2-12cR1AQ spill debug idleOther
12cR1-12cR1AQ: 12c message cache init waitIdle
12cR1-12cR1AQ:non durable subscriber add or dropOther
12cR1-12cR1AQPC idleIdle
12cR1-12cR1AQPC: new masterOther
12cR1-12cR1ARCH Remote WriteOther
9i-11gR1ARCH random i/oSystem I/O
9i-11gR1ARCH sequential i/oSystem I/O
10gR1-12cR1ARCH wait for archivelog lockOther
10gR1-12cR1ARCH wait for flow-controlNetwork
10gR1-12cR1ARCH wait for net re-connectNetwork
10gR1-12cR1ARCH wait for netserver detachNetwork
10gR1-11gR1ARCH wait for netserver init 1Network
10gR1-12cR1ARCH wait for netserver init 2Network
10gR1-12cR1ARCH wait for netserver startNetwork
10gR1-10gR2ARCH wait for pending I/OsSystem I/O
10gR1-12cR1ARCH 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-12cR1ARCH wait for process start 1Other
10gR1-11gR1ARCH wait for process start 2Other
10gR1-12cR1ARCH 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-12cR1ARCH wait on c/f tx acquire 1Other
10gR1-11gR1ARCH wait on c/f tx acquire 2Other
10gR2-12cR1ASM COD rollback operation completiondismount forceAdministrative
11gR2-12cR1ASM DG UnblockOther
11gR2-12cR1ASM Fixed Package I/OblknobytesfiletypeUser I/O
11gR2-12cR1ASM Instance startupOther
12cR1-12cR1ASM PST operationopOther
10gR1-12cR1ASM PST query : wait for [PM][grp][0] grantCluster
12cR1-12cR1ASM Scrubbing I/OblknobytesfiletypeOther
11gR2-12cR1ASM Staleness File I/Oblkno#blksdisknoUser I/O
11gR1-12cR1ASM Volume BackgroundOther
12cR1-12cR1ASM Volume Resource ActionOther
12cR1-12cR1ASM async relocation I/OcountwherefileSystem I/O
10gR1-11gR1ASM background runningOther
10gR1-12cR1ASM background startingOther
10gR1-12cR1ASM background timerIdle
11gR2-12cR1ASM cluster file accesslockmodeOther
10gR1-12cR1ASM db client existsOther
11gR1-12cR1ASM file metadata operationmsgoplocnOther
10gR2-12cR1ASM internal hang testtest #Other
11gR1-12cR1ASM metadata cache frozengroup#Other
10gR1-12cR1ASM mount : wait for heartbeatAdministrative
11gR1-12cR1ASM network foreground exitsgroup#Other
12cR1-12cR1ASM remote SQLNetwork
12cR1-12cR1ASM sync cache disk readgroupobjblockUser I/O
12cR1-12cR1ASM sync relocation I/OcountwherefileSystem I/O
12cR1-12cR1ASM volume directive sendmsgopdgvolOther
11gR2-12cR1ASM: MARK subscribe to msg channelOther
11gR1-12cR1ASM: OFS Cluster membership updateOther
12cR1-12cR1ASM: Send msg to MARKgroup#dgincOther
12cR1-12cR1ASYNC Remote WriteOther
10gR2-12cR1AWR FlushOther
10gR2-12cR1AWR Metric CaptureOther
11gR2-12cR1Archive Manager file transfer I/OcountintrtimeoutUser I/O
11gR1-12cR1Archiver slave I/Owait countwait flagstimeoutSystem I/O
11gR2-12cR1Auto BMR RPC standby catchupwrapbaseOther
11gR2-12cR1Auto BMR completionfile#block#Other
12cR1-12cR1Availability Machine container I/OrequestsOther
12cR1-12cR1Availability Machine container synchronous readblock#blocksOther
12cR1-12cR1Availability Machine container synchronous writeblock#blocksOther
8i-12cR1BFILE check if existsOther
8i-12cR1BFILE check if openOther
8i-12cR1BFILE closureOther
8i-12cR1BFILE get lengthOther
8i-12cR1BFILE get name objectOther
8i-12cR1BFILE get path objectOther
8i-12cR1BFILE internal seekOther
8i-12cR1BFILE openOther
8i-12cR1BFILE readUser I/O
11gR2-12cR1Backup Restore Event 19778 sleepsession_idserialOther
11gR2-12cR1Backup Restore Switch Bitmap sleepsession_idserialOther
11gR2-12cR1Backup Restore Throttle sleepsession_idserialOther
11gR2-12cR1Backup: MML command to channelAdministrative
11gR2-12cR1Backup: MML commit backup pieceAdministrative
11gR2-12cR1Backup: MML create a backup pieceAdministrative
11gR2-12cR1Backup: MML data movement done?Administrative
11gR2-12cR1Backup: MML datafile proxy backup?Administrative
11gR2-12cR1Backup: MML datafile proxy restore?Administrative
11gR2-12cR1Backup: MML delete backup pieceAdministrative
11gR2-12cR1Backup: MML extended initializationAdministrative
11gR2-12cR1Backup: MML get base addressAdministrative
11gR2-12cR1Backup: MML initializationAdministrative
11gR2-12cR1Backup: MML obtain a direct bufferAdministrative
11gR2-12cR1Backup: MML obtain textual errorAdministrative
11gR2-12cR1Backup: MML proxy cancelAdministrative
11gR2-12cR1Backup: MML proxy commit backup pieceAdministrative
11gR2-12cR1Backup: MML proxy initialize backupAdministrative
11gR2-12cR1Backup: MML proxy initialize restoreAdministrative
11gR2-12cR1Backup: MML proxy prepare to startAdministrative
11gR2-12cR1Backup: MML proxy session endAdministrative
11gR2-12cR1Backup: MML proxy start data movementAdministrative
11gR2-12cR1Backup: MML query backup pieceAdministrative
11gR2-12cR1Backup: MML query for direct buffersAdministrative
11gR2-12cR1Backup: MML read backup pieceAdministrative
11gR2-12cR1Backup: MML release a direct bufferAdministrative
11gR2-12cR1Backup: MML restore backup pieceAdministrative
11gR2-12cR1Backup: MML shutdownAdministrative
11gR2-12cR1Backup: MML v1 close backup pieceAdministrative
11gR2-12cR1Backup: MML v1 delete backup pieceAdministrative
11gR2-12cR1Backup: MML v1 open backup pieceAdministrative
11gR2-12cR1Backup: MML v1 query backup pieceAdministrative
11gR2-12cR1Backup: MML v1 read backup pieceAdministrative
11gR2-12cR1Backup: MML v1 write backup pieceAdministrative
11gR2-12cR1Backup: 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-12cR1CDB: Per Instance Query for PDB InfoOther
9i-12cR1CGS skgxn join retryretry countOther
9i-12cR1CGS wait for IPC msgOther
11gR2-12cR1CRS call completionclsrrestypekjha_actionOther
11gR2-12cR1CSS Xgrp shared operationfunction_idOther
11gR2-12cR1CSS group membership querygroup_name1group_name2group_name3Other
11gR2-12cR1CSS group registrationgroup_name1group_name2mem_idOther
11gR2-12cR1CSS initializationOther
11gR2-12cR1CSS operation: actionfunction_idOther
11gR2-12cR1CSS operation: data queryfunction_idOther
11gR2-12cR1CSS operation: data updatefunction_idOther
11gR2-12cR1CSS operation: diagnosticfunction_idOther
11gR2-12cR1CSS operation: queryfunction_idOther
11gR2-12cR1CTWR media recovery checkpoint requestOther
8i-8iCache simulator heap
12cR1-12cR1Clonedb bitmap file writeblknosizeSystem I/O
10gR1-12cR1Cluster Suspension waitOther
11gR1-12cR1Cluster stabilization waitOther
10gR1-10gR2Cluster stablization waitOther
11gR2-12cR1Compression analysisOther
8i-8iContacting SCN server or SCN lock master
10gR1-11gR1DBFG waiting for replyOther
10gR1-12cR1DBMS_LDAP: LDAP operationOther
12cR1-12cR1DBMS_ROLLING instruction completionInstruction idOther
11gR1-12cR1DBWR range invalidation syncdbwr#Other
11gR1-12cR1DBWR slave I/Owait countwait flagstimeoutSystem I/O
8i-12cR1DFS db file lockfile#Other
8i-12cR1DFS lock handletype|modeid1id2Other
10gR2-12cR1DG Broker configuration file I/OcountintrtimeoutUser I/O
9i-9iDIAG dummy wait
10gR1-12cR1DIAG idle waitcomponentwherewait time(millisec)Idle
12cR1-12cR1DIAG lock acquisitionOther
12cR1-12cR1DLM Omni Enq Owner replicationOwner IDOther
12cR1-12cR1DLM cross inst call completioncaller instance numbercluster incarnation numberrequest identifierOther
12cR1-12cR1DLM 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-12cR1DLM: shared instance mode initOther
12cR1-12cR1DSKM to complete cell health checkOther
11gR1-12cR1Data 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
12cR1-12cR1Data Guard server operation completionOther
12cR1-12cR1Data Guard: RFS disk I/OOther
10gR2-12cR1Data Guard: process clean upOther
10gR2-12cR1Data Guard: process exitOther
11gR2-12cR1Data Pump slave initOther
11gR2-12cR1Data Pump slave startupOther
10gR2-12cR1Data file init writecountintrtimeoutUser I/O
10gR2-12cR1Datapump dump file I/OcountintrtimeoutUser I/O
11gR2-12cR1Disk file I/O CalibrationcountUser I/O
11gR2-12cR1Disk file Mirror ReadfilenoblknofiletypeUser I/O
11gR2-12cR1Disk file Mirror/Media Repair WritefilenoblknofiletypeUser I/O
11gR2-12cR1Disk file operations I/OFileOperationfilenofiletypeUser I/O
10gR2-10gR2EMON idle waitIdle
11gR1-12cR1EMON slave idle waitIdle
11gR1-11gR2EMON slave messagesOther
11gR1-12cR1EMON terminationOther
12cR1-12cR1Emon coordinator main loopIdle
12cR1-12cR1Emon coordinator startupOther
12cR1-12cR1Emon slave main loopIdle
11gR2-12cR1External Procedure callApplication
11gR2-12cR1External Procedure initial connectionApplication
10gR2-12cR1FAL archive wait 1 sec for REOPEN minimumOther
12cR1-12cR1File CopycountintrtimeoutUser I/O
10gR1-10gR1Flow Control EventOther
12cR1-12cR1GCR CSS join retryretry countOther
12cR1-12cR1GCR ctx lock acquisitionretry countOther
12cR1-12cR1GCR lock acquisitionOther
12cR1-12cR1GCR member Data from CSSretry countOther
12cR1-12cR1GCR sleeplock retry countIdle
10gR2-12cR1GCS lock cancelleOther
10gR2-12cR1GCS lock cvt Sgroupobj#block#Other
10gR2-12cR1GCS lock cvt Xgroupobj#block#Other
10gR2-12cR1GCS lock escgroupobj#block#Other
10gR2-12cR1GCS lock esc Xgroupobj#block#Other
10gR2-12cR1GCS lock opengroupobj#block#Other
10gR2-12cR1GCS lock open Sgroupobj#block#Other
10gR2-12cR1GCS lock open Xgroupobj#block#Other
10gR2-12cR1GCS recovery lock convertgroupobj#block#Other
10gR2-12cR1GCS recovery lock opengroupobj#block#Other
11gR2-12cR1GIPC operation: dumpfunction_idOther
11gR2-12cR1GPnP Get ErrorOther
11gR2-12cR1GPnP Get ItemOther
11gR2-12cR1GPnP InitializationOther
11gR2-12cR1GPnP Set ItemOther
11gR2-12cR1GPnP TerminationOther
10gR1-12cR1GV$: slave acquisition retry wait timeOther
11gR1-12cR1Global transaction acquire instance locksretriesConfiguration
9i-12cR1HS message to agentIdle
11gR2-12cR1IMR CSS join retryretry countOther
11gR2-12cR1IMR disk votesOther
11gR2-12cR1IMR membership resolutionOther
11gR2-12cR1IMR mount phase II completionOther
11gR2-12cR1IMR net-check message ackOther
11gR2-12cR1IMR rr lock releaseOther
11gR2-12cR1IMR rr updateOther
8i-8iIO clients wait for LMON to join GMS group
11gR1-12cR1IORM Scheduler Slave Idle WaitIdle
9i-12cR1IPC busy async requestOther
9i-12cR1IPC send completion syncsend countOther
9i-12cR1IPC wait for name service busyOther
9i-12cR1IPC waiting for OSD resourcesOther
12cR1-12cR1Image redo gen delayOther
11gR1-12cR1JOX Jit Process SleepIdle
10gR1-12cR1JS coord start waitOther
10gR1-12cR1JS external jobIdle
10gR1-12cR1JS kgl get object waitOther
10gR1-12cR1JS kill job waitOther
9i-9iKJC: Wait for msg sends to complete
10gR1-12cR1KJC: Wait for msg sends to completemsgdest|rcvrmtypeOther
8i-8iKSIM GDS request cancel
10gR1-11gR2KSV master waitIdle
12cR1-12cR1KSV master waitindicatorOther
10gR1-12cR1Kupp process shutdownnalivesleeptimeloopOther
9i-12cR1L1 validationseghdrl1bmbOther
11gR2-12cR1LGWR ORL/NoExp FAL archivalOther
12cR1-12cR1LGWR all worker groupsOther
12cR1-12cR1LGWR any worker groupOther
12cR1-12cR1LGWR intra group IO completionwheregroupidslaveidOther
12cR1-12cR1LGWR intra group syncwheregroupidslaveidOther
9i-11gR1LGWR random i/oSystem I/O
11gR2-12cR1LGWR real time apply syncIdle
9i-11gR1LGWR sequential i/oSystem I/O
9i-12cR1LGWR simulation latency waitOther
11gR1-12cR1LGWR slave I/Owait countwait flagstimeoutSystem I/O
8i-12cR1LGWR wait for redo copycopy latch #Other
9i-11gR2LGWR wait on ATTACHNetwork
9i-11gR2LGWR wait on DETACHNetwork
9i-12cR1LGWR wait on LNSNetwork
9i-11gR2LGWR wait on SENDREQNetwork
9i-11gR1LGWR wait on full LNS bufferOther
12cR1-12cR1LGWR worker group idlegroup_idslave_idIdle
12cR1-12cR1LGWR worker group orderinglwn_idphaseOther
9i-12cR1LGWR-LNS wait on channelOther
10gR2-12cR1LMON global data updateOther
8i-8iLMON wait for LMD to inherit communication channels
10gR2-12cR1LNS ASYNC archive logIdle
10gR2-11gR1LNS ASYNC control file txnSystem I/O
10gR2-12cR1LNS ASYNC dest activationIdle
10gR2-12cR1LNS ASYNC end of logIdle
9i-12cR1LNS simulation latency waitOther
9i-11gR1LNS wait for LGWR redoOther
9i-11gR2LNS wait on ATTACHNetwork
9i-11gR2LNS wait on DETACHNetwork
9i-12cR1LNS wait on LGWRNetwork
9i-11gR2LNS wait on SENDREQNetwork
10gR2-12cR1Log archive I/OcountintrtimeoutSystem I/O
10gR2-12cR1Log file init writecountintrtimeoutUser I/O
11gR2-12cR1LogMiner builder: DDLSession IDQueueing
11gR2-12cR1LogMiner builder: branchSession IDIdle
11gR2-12cR1LogMiner builder: idleSession IDIdle
11gR2-12cR1LogMiner builder: memorySession IDQueueing
11gR2-12cR1LogMiner client: transactionSession IDIdle
11gR2-12cR1LogMiner preparer: idleSession IDIdle
11gR2-12cR1LogMiner preparer: memorySession IDQueueing
11gR2-12cR1LogMiner reader: bufferSession IDQueueing
11gR2-12cR1LogMiner reader: log (idle)Session IDThreadSequenceIdle
11gR2-12cR1LogMiner reader: redo (idle)Session IDThreadSequenceIdle
11gR2-12cR1LogMiner: activateSession IDIdle
11gR1-11gR1LogMiner: builder idleSession IDIdle
10gR2-10gR2LogMiner: client waiting for transactionIdle
11gR1-11gR1LogMiner: client waiting for transactionSession IDIdle
11gR2-12cR1LogMiner: find sessionSession IDIdle
11gR1-11gR1LogMiner: generic process sleepCaller IDIdle
11gR2-12cR1LogMiner: internalCaller IDIdle
11gR2-12cR1LogMiner: otherSession IDIdle
11gR1-11gR1LogMiner: preparer idleSession IDIdle
11gR1-11gR1LogMiner: reader idleSession IDIdle
10gR2-11gR1LogMiner: reader waiting for more redoSession IDThreadSequenceIdle
11gR2-12cR1LogMiner: 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-12cR1Logical Standby Apply DelayIdle
10gR2-12cR1Logical Standby Apply shutdownOther
11gR1-12cR1Logical Standby DebugeventOther
10gR2-12cR1Logical Standby Terminal ApplystageOther
10gR2-12cR1Logical Standby dictionary buildOther
10gR2-12cR1Logical Standby pin transactionxidusnxidsltxidsqnOther
10gR1-12cR1MMON (Lite) shutdownprocess#waitedOther
10gR1-12cR1MMON slave messagesOther
12cR1-12cR1MRP inactivationOther
11gR1-12cR1MRP redo arrivalIdle
12cR1-12cR1MRP state inspectionOther
12cR1-12cR1MRP terminationOther
10gR1-12cR1MRP wait on archivelog archivalOther
10gR1-12cR1MRP wait on archivelog arrivalOther
10gR1-11gR2MRP wait on archivelog delayOther
10gR1-11gR2MRP wait on process deathOther
10gR1-12cR1MRP wait on process restartOther
10gR1-12cR1MRP wait on process startOther
10gR1-12cR1MRP wait on startup clearOther
10gR1-11gR2MRP wait on state changeOther
10gR1-11gR2MRP wait on state n_aOther
10gR1-11gR2MRP wait on state resetOther
11gR1-12cR1NFS read delegation outstandingdelegation countOther
11gR1-12cR1Network file transfercountintrtimeoutSystem I/O
8i-8iNull event
12cR1-12cR1OFS idleIdle
12cR1-12cR1OFS operation completionAdministrative
11gR2-12cR1OJVM: 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-12cR1OLAP 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-12cR1OSD IPC libraryrolling migOther
11gR1-12cR1PINGIdle
8i-12cR1PL/SQL lock timerdurationIdle
11gR1-12cR1PMON to cleanup detached branches at shutdownOther
10gR2-12cR1PMON to cleanup pseudo-branches at svc stop timeOther
11gR1-12cR1PX Deq Credit: Session Statssleeptime/senderidpassesOther
8i-12cR1PX Deq Credit: free buffersleeptime/senderidpassesqrefOther
8i-12cR1PX Deq Credit: need buffersleeptime/senderidpassesqrefIdle
8i-12cR1PX Deq Credit: send blkdsleeptime/senderidpassesqrefOther
8i-12cR1PX Deq: Execute Replysleeptime/senderidpassesIdle
8i-12cR1PX Deq: Execution Msgsleeptime/senderidpassesIdle
8i-12cR1PX Deq: Index Merge Closesleeptime/senderidpassesIdle
8i-12cR1PX Deq: Index Merge Executesleeptime/senderidpassesIdle
8i-12cR1PX Deq: Index Merge Replysleeptime/senderidpassesIdle
8i-12cR1PX Deq: Join ACKsleeptime/senderidpassesIdle
11gR2-12cR1PX Deq: Metadata Updatektelc_wait1sIdle
8i-12cR1PX Deq: Msg Fragmentsleeptime/senderidpassesIdle
9i-12cR1PX Deq: OLAP Update Closesleeptime/senderidpassesOther
9i-12cR1PX Deq: OLAP Update Executesleeptime/senderidpassesOther
9i-12cR1PX 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-12cR1PX Deq: Parse Replysleeptime/senderidpassesIdle
8i-10gR2PX Deq: Signal ACKsleeptime/senderidpassesOther
11gR1-12cR1PX Deq: Signal ACK EXTsleeptime/senderidpassesOther
11gR1-12cR1PX Deq: Signal ACK RSGsleeptime/senderidpassesOther
11gR1-12cR1PX Deq: Slave Join Fragsleeptime/senderidpassesOther
11gR1-12cR1PX Deq: Slave Session Statssleeptime/senderidpassesOther
8i-12cR1PX Deq: Table Q Closesleeptime/senderidpassesOther
8i-12cR1PX Deq: Table Q Get Keyssleeptime/senderidpassesOther
8i-12cR1PX Deq: Table Q Normalsleeptime/senderidpassesIdle
8i-12cR1PX Deq: Table Q Samplesleeptime/senderidpassesIdle
8i-12cR1PX Deq: Table Q qrefsleeptime/senderidpassesOther
11gR1-12cR1PX Deq: Test for creditsleeptime/senderidpassesOther
8i-12cR1PX Deq: Test for msgsleeptime/senderidpassesOther
8i-12cR1PX Deq: Txn Recovery Replysleeptime/senderidpassesIdle
8i-12cR1PX Deq: Txn Recovery Startsleeptime/senderidpassesIdle
10gR1-12cR1PX Deq: kdcph_maikdcph_maiIdle
10gR1-12cR1PX Deq: kdcphc_ackkdcphc_ackIdle
9i-12cR1PX Deq: reap creditOther
8i-12cR1PX Deque waitsleeptime/senderidpassesIdle
8i-12cR1PX Idle Waitsleeptime/senderidpassesIdle
9i-12cR1PX Nsq: PQ descriptor queryOther
9i-12cR1PX Nsq: PQ load info queryOther
11gR2-12cR1PX Queuing: statement queuesleeptimepassesScheduler
9i-12cR1PX Send WaitOther
8i-12cR1PX create servernserverssleeptimeenqueueOther
11gR2-12cR1PX hash elem being insertedhashidelementinsert/updateOther
8i-12cR1PX qref latchfunctionsleeptimeqrefOther
8i-12cR1PX server shutdownnalivesleeptimeloopOther
8i-12cR1PX signal serverserialerrornbusyOther
9i-12cR1PX slave connectionOther
9i-12cR1PX slave releaseOther
11gR2-12cR1Parameter File I/Oblkno#blksread/writeUser I/O
12cR1-12cR1Pluggable 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
12cR1-12cR1RAC referential constraint parent lockmaximum attemptsattempt countOther
12cR1-12cR1REPL Apply: apply DDL2=>GoldenGate 1=>XStream 0=>Streamssleep timeApplication
12cR1-12cR1REPL Apply: commit2=>GoldenGate 1=>XStream 0=>StreamsConfiguration
12cR1-12cR1REPL Apply: dependency2=>GoldenGate 1=>XStream 0=>StreamsConcurrency
12cR1-12cR1REPL Apply: txnsIdle
12cR1-12cR1REPL Capture/Apply: RAC AQ qmn coordinator1=>MASTER 2=>SLAVEIdle
12cR1-12cR1REPL Capture/Apply: RAC inter-instance ack2=>GoldenGate 1=>XStream 0=>StreamsOther
12cR1-12cR1REPL Capture/Apply: database startup2=>GoldenGate 1=>XStream 0=>StreamsOther
12cR1-12cR1REPL Capture/Apply: flow control2=>GoldenGate 1=>XStream 0=>StreamsQueueing
12cR1-12cR1REPL Capture/Apply: memory2=>GoldenGate 1=>XStream 0=>StreamsQueueing
12cR1-12cR1REPL Capture/Apply: messages2=>GoldenGate 1=>XStream 0=>StreamsIdle
12cR1-12cR1REPL Capture/Apply: miscellaneous2=>GoldenGate 1=>XStream 0=>StreamsTYPEOther
12cR1-12cR1REPL Capture: archive log2=>GoldenGate 1=>XStream 0=>StreamsTYPEIdle
12cR1-12cR1REPL Capture: filter callback ruleset2=>GoldenGate 1=>XStream 0=>StreamsApplication
12cR1-12cR1REPL Capture: subscribers to catch up2=>GoldenGate 1=>XStream 0=>StreamsTYPEQueueing
10gR2-10gR2RF - FSFO Wait for AckOther
10gR1-12cR1RFS announceOther
10gR1-12cR1RFS attachOther
10gR1-12cR1RFS closeOther
10gR1-12cR1RFS createOther
10gR1-12cR1RFS detachOther
10gR1-12cR1RFS dispatchOther
10gR1-12cR1RFS pingOther
9i-12cR1RFS random i/oSystem I/O
10gR1-12cR1RFS registerOther
9i-12cR1RFS sequential i/oSystem I/O
10gR1-12cR1RFS writeSystem I/O
11gR1-12cR1RMAN Disk slave I/Owait countwait flagstimeoutSystem I/O
11gR1-12cR1RMAN Tape slave I/Otape operationoperation flagstimeoutSystem I/O
10gR2-12cR1RMAN backup & recovery I/OcountintrtimeoutSystem I/O
11gR2-12cR1RSGA: RAC reconfigurationOther
10gR1-12cR1RVWR 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
12cR1-12cR1Redo Transport AttachOther
12cR1-12cR1Redo Transport CloseOther
12cR1-12cR1Redo Transport DetachOther
12cR1-12cR1Redo Transport MISCOther
12cR1-12cR1Redo Transport OpenOther
12cR1-12cR1Redo Transport PingOther
12cR1-12cR1Redo Transport Slave ShutdownOther
12cR1-12cR1Redo Transport Slave StartupOther
12cR1-12cR1Redo Writer Remote Sync CompleteOther
12cR1-12cR1Redo Writer Remote Sync NotifyOther
12cR1-12cR1Remote SYNC PingOther
8i-12cR1Replication Dequeuesleeptime/senderidpassesOther
12cR1-12cR1Resolution of in-doubt txnsSCNOther
12cR1-12cR1SGA Allocator terminationOther
10gR2-12cR1SGA: MMAN sleep for component shrinkcomponent idcurrent sizetarget sizeIdle
10gR2-12cR1SGA: allocation forcing component growthOther
10gR2-12cR1SGA: sga_target resizeOther
8i-12cR1SQL*Net break/reset to clientdriver idbreak?Application
8i-12cR1SQL*Net break/reset to dblinkdriver idbreak?Application
8i-12cR1SQL*Net message from clientdriver id#bytesIdle
8i-12cR1SQL*Net message from dblinkdriver id#bytesNetwork
8i-12cR1SQL*Net message to clientdriver id#bytesNetwork
8i-12cR1SQL*Net message to dblinkdriver id#bytesNetwork
8i-12cR1SQL*Net more data from clientdriver id#bytesNetwork
8i-12cR1SQL*Net more data from dblinkdriver id#bytesNetwork
8i-12cR1SQL*Net more data to clientdriver id#bytesNetwork
8i-12cR1SQL*Net more data to dblinkdriver id#bytesNetwork
11gR1-12cR1SQL*Net vector data from clientdriver id#bytesNetwork
11gR1-12cR1SQL*Net vector data from dblinkdriver id#bytesNetwork
11gR1-12cR1SQL*Net vector data to clientdriver id#bytesNetwork
11gR1-12cR1SQL*Net vector data to dblinkdriver id#bytesNetwork
11gR2-12cR1SQL*Net vector message from clientdriver id#bytesIdle
11gR2-12cR1SQL*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-12cR1SUPLOG PL wait for inflight pragma-d PL/SQLsession_numOther
10gR1-10gR1SWRF RWM Auto Capture EventOther
10gR1-10gR1SWRF Wait on FlushingOther
12cR1-12cR1SYNC Remote WriteOther
12cR1-12cR1SecureFile log bufferConfiguration
11gR2-12cR1SecureFile mutexConcurrency
12cR1-12cR1Sharded Queues : Part Maintenance idleIdle
11gR1-12cR1Shared IO Pool IO CompletionUser I/O
11gR1-12cR1Shared IO Pool MemoryConcurrency
11gR1-12cR1Space Manager: slave idle waitSlave IDIdle
11gR1-12cR1Space Manager: slave messagesOther
10gR2-12cR1Standby redo I/OcountintrtimeoutSystem I/O
10gR2-12cR1Streams AQ: QueueTable kgl locksOther
10gR2-11gR2Streams AQ: RAC qmn coordinator idle waitIdle
10gR2-12cR1Streams AQ: deallocate messages from Streams PoolIdle
10gR2-12cR1Streams AQ: delete acknowledged messagesIdle
11gR1-12cR1Streams AQ: emn coordinator idle waitIdle
11gR1-11gR2Streams AQ: emn coordinator waiting for slave to startOther
10gR2-12cR1Streams AQ: enqueue blocked due to flow controlQueueing
10gR2-12cR1Streams AQ: enqueue blocked on low memoryQueueing
12cR1-12cR1Streams AQ: load balancer idleIdle
10gR2-12cR1Streams AQ: qmn coordinator idle waitIdle
10gR2-11gR2Streams AQ: qmn coordinator waiting for slave to startOther
10gR2-11gR1Streams AQ: qmn slave idle waitIdle
11gR2-12cR1Streams AQ: qmn slave idle waitTypeIdle
10gR2-12cR1Streams AQ: waiting for busy instance for instance_namewherewait_countOther
10gR2-12cR1Streams AQ: waiting for messages in the queuequeue idprocess#wait timeIdle
10gR2-12cR1Streams 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
12cR1-12cR1Sync ASM discoveryOther
10gR1-12cR1Sync ASM rebalanceOther
10gR2-12cR1TCP Socket (KGAS)Network
11gR2-12cR1TEST: action hangOther
11gR2-12cR1TEST: action syncOther
12cR1-12cR1TEXT: File System I/OUser I/O
10gR2-12cR1TEXT: URL_DATASTORE network waitNetwork
12cR1-12cR1TPZ test processOther
11gR2-12cR1TSE SSO wallet reopenOther
11gR2-12cR1TSE master key rekeyts#Other
11gR2-12cR1VKRM IdleIdle
11gR1-12cR1VKTM Init Wait for GSGAIdle
11gR1-12cR1VKTM Logical Idle WaitIdle
10gR2-12cR1WCR: RAC message context busyOther
11gR1-12cR1WCR: Sync context busyOther
11gR2-12cR1WCR: capture file IO writeOther
11gR1-12cR1WCR: replay client notifywho am IIdle
11gR1-12cR1WCR: replay clockwait for scn's hi 4 byteswait for scn's lo 4 bytesIdle
11gR1-12cR1WCR: replay lock orderwait for scn's hi 4 byteswait for scn's lo 4 bytesApplication
11gR1-12cR1WCR: replay pausedIdle
9i-10gR1Wait for Dictionary Build to lock all tablesOther
10gR1-12cR1Wait for TT enqueuetsnOther
9i-12cR1Wait for Table LockApplication
8i-8iWait for a paralle reco to abort
8i-8iWait for a undo record
10gR1-12cR1Wait for shrink lockobject_idlock_modeOther
10gR1-12cR1Wait for shrink lock2object_idlock_modeOther
8i-8iWait for stopper event to be increased
10gR1-12cR1Wait on stby instance closeOther
11gR1-12cR1XDB SGA initializationOther
12cR1-12cR1ack for a broadcasted res from a remote instanceOther
12cR1-12cR1acknowledge over PGA limitlimitmargingrowthScheduler
10gR2-12cR1affinity expansion in replayOther
10gR1-12cR1alter rbs offlineAdministrative
9i-12cR1alter system set dispatcherwaitedAdministrative
8i-8ialter system set mts_dispatcherwaited
9i-9iasync disk IOcountintrtimeout
11gR2-12cR1asynch descriptor resizeoutstanding #aiocurrent aio limitnew aio limitOther
11gR1-12cR1auto-sqltune: wait graph updateIdle
9i-9ibackground parameter adjustmentparameter number
10gR1-12cR1block change tracking buffer spaceOther
11gR1-12cR1blocking txn id for DDLtablescnonly dmlOther
11gR1-12cR1broadcast mesg queue transitionchannel handlemessagelocationOther
11gR1-12cR1broadcast mesg recovery queue transitionchannel handlemessagelocationOther
10gR1-12cR1buffer 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-12cR1buffer busy waitsfile#block#class#Concurrency
8i-12cR1buffer deadlockdbaclass*10+modeflagOther
10gR1-12cR1buffer dirty disabledgroup#Other
9i-12cR1buffer exterminatefile#block#buf_ptrOther
10gR1-12cR1buffer freelistbusygroup#obj#block#Other
10gR1-12cR1buffer invalidation waitgroup#obj#block#Other
8i-12cR1buffer latchlatch addrchain#Other
9i-11gR1buffer pool resizebuffer pool idcurrent sizenew sizeAdministrative
8i-12cR1buffer read retryfile#block#User I/O
10gR1-12cR1buffer rememberlist busygroup#obj#block#Other
9i-12cR1buffer resizeOther
10gR1-12cR1buffer write waitgroup#obj#block#Other
10gR1-12cR1buffer writeList fullgroup#obj#block#Other
9i-9icache simulator heap
12cR1-12cR1callactionOther
11gR2-12cR1cell list of blocks physical readcellhash#diskhash#blocksUser I/O
11gR2-12cR1cell manager cancel work requestOther
11gR2-12cR1cell manager closing cellcellhash#System I/O
11gR2-12cR1cell manager discovering diskscellhash#System I/O
11gR2-12cR1cell manager opening cellcellhash#System I/O
11gR1-12cR1cell multiblock physical readcellhash#diskhash#bytesUser I/O
11gR1-12cR1cell single block physical readcellhash#diskhash#bytesUser I/O
11gR1-12cR1cell smart file creationcellhash#User I/O
11gR2-12cR1cell smart flash unkeepcellhash#Other
11gR1-12cR1cell smart incremental backupcellhash#System I/O
11gR1-12cR1cell smart index scancellhash#User I/O
11gR1-12cR1cell smart restore from backupcellhash#System I/O
11gR1-12cR1cell smart table scancellhash#User I/O
11gR1-12cR1cell statistics gathercellhash#User I/O
11gR2-12cR1cell worker idleIdle
11gR2-12cR1cell worker online completioncellhash#Other
11gR2-12cR1cell worker retrycellhash#Other
10gR1-12cR1change tracking file parallel writeblocksrequestsOther
10gR1-12cR1change tracking file synchronous readblock#blocksOther
10gR1-12cR1change tracking file synchronous writeblock#blocksOther
10gR1-12cR1check CPU wait timesOther
10gR1-12cR1checkpoint advancedgroup#Other
8i-12cR1checkpoint completedConfiguration
10gR1-12cR1class slave waitslave idIdle
10gR2-12cR1cleanup of aborted processlocationOther
11gR1-12cR1cmon timersleep timeIdle
11gR2-12cR1concurrent I/O completionAdministrative
12cR1-12cR1connection broker handoffconnection brokerconnectionopNetwork
11gR1-11gR2connection pool waitopnum serversAdministrative
12cR1-12cR1connection pool waitopnum procsAdministrative
9i-10gR1contacting SCN server or SCN lock masterCluster
12cR1-12cR1control file backup creationAdministrative
10gR2-12cR1control file diagnostic dumptypeparamOther
9i-12cR1control file heartbeatOther
8i-9icontrol file parallel writefilesblocksrequests
10gR1-12cR1control file parallel writefilesblock#requestsSystem I/O
8i-12cR1control file sequential readfile#block#blocksSystem I/O
8i-12cR1control file single writefile#block#blocksSystem I/O
8i-8iconversion file readfile#block#blocks
9i-9iconversion file readblock#blocks
9i-12cR1cr request retryfile#block#Other
10gR2-11gR1cursor: mutex Sidnvaluewhere|sleepsConcurrency
11gR2-12cR1cursor: mutex SidnvaluewhereConcurrency
10gR2-11gR1cursor: mutex Xidnvaluewhere|sleepsConcurrency
11gR2-12cR1cursor: mutex XidnvaluewhereConcurrency
10gR2-11gR1cursor: pin Sidnvaluewhere|sleepsOther
11gR2-12cR1cursor: pin SidnvaluewhereConcurrency
10gR2-11gR1cursor: pin S wait on Xidnvaluewhere|sleepsConcurrency
11gR2-12cR1cursor: pin S wait on XidnvaluewhereConcurrency
10gR2-11gR1cursor: pin Xidnvaluewhere|sleepsOther
11gR2-12cR1cursor: pin XidnvaluewhereConcurrency
11gR2-12cR1datafile copy range completionAdministrative
11gR2-12cR1datafile move cleanup during resizeOther
11gR2-12cR1db file async I/O submitrequestsinterrupttimeoutSystem I/O
8i-12cR1db file parallel readfilesblocksrequestsUser I/O
8i-8idb file parallel writefilesblocksrequests
9i-12cR1db file parallel writerequestsinterrupttimeoutSystem I/O
8i-12cR1db file scattered readfile#block#blocksUser I/O
8i-12cR1db file sequential readfile#block#blocksUser I/O
8i-12cR1db file single writefile#block#blocksUser I/O
11gR2-12cR1db flash cache dynamic disabling waitAdministrative
11gR2-12cR1db flash cache invalidate waitConcurrency
11gR2-12cR1db flash cache multiblock physical readUser I/O
11gR2-12cR1db flash cache single block physical readUser I/O
11gR2-12cR1db flash cache writeUser I/O
10gR2-12cR1dbms_file_transfer I/OcountintrtimeoutUser I/O
10gR2-12cR1dbverify readscountintrtimeoutUser I/O
8i-12cR1debugger commandOther
10gR1-12cR1dedicated server timerwait eventNetwork
12cR1-12cR1defer SGA allocation slavenum of defer segmentsOther
8i-12cR1direct path readfile numberfirst dbablock cntUser I/O
8i-9idirect path read (lob)file numberfirst dbablock cnt
10gR1-12cR1direct path read tempfile numberfirst dbablock cntUser I/O
11gR1-12cR1direct path syncFile numberFlagsUser I/O
8i-12cR1direct path writefile numberfirst dbablock cntUser I/O
8i-9idirect path write (lob)file numberfirst dbablock cnt
10gR1-12cR1direct path write tempfile numberfirst dbablock cntUser I/O
8i-12cR1dispatcher listen timersleep timeNetwork
8i-12cR1dispatcher shutdownwaitedOther
8i-12cR1dispatcher timersleep timeIdle
10gR1-12cR1dma prepare busygroupobj#block#Other
8i-12cR1dupl. cluster keydbaOther
11gR2-12cR1enq: AB - ABMR process initializedname|modeoperationoperation parmOther
11gR2-12cR1enq: AB - ABMR process start/stopname|modeoperationoperation parmOther
12cR1-12cR1enq: AC - acquiring partition idname|mode00Other
10gR1-12cR1enq: AD - allocate AUname|modegroup and disk numberAU numberOther
10gR1-12cR1enq: AD - deallocate AUname|modegroup and disk numberAU numberOther
11gR1-12cR1enq: AD - relocate AUname|modegroup and disk numberAU numberOther
11gR1-12cR1enq: AE - lockname|modeedition obj#0Other
10gR1-12cR1enq: AF - task serializationname|modetask id0Other
10gR1-12cR1enq: AG - contentionname|modeworkspace #generationOther
12cR1-12cR1enq: AK - contentiontype|modeid1id2Other
11gR1-12cR1enq: AM - ASM ACD Relocationname|modeid1id2Other
12cR1-12cR1enq: AM - ASM ATB COD creationname|modeid1id2Other
11gR2-12cR1enq: AM - ASM Amdu Dumpname|modeid1id2Other
12cR1-12cR1enq: AM - ASM Audit file Cleanupname|modeid1id2Other
12cR1-12cR1enq: AM - ASM Audit file Deletename|modeid1id2Other
12cR1-12cR1enq: AM - ASM DD update SrRlocname|modeid1id2Other
11gR1-12cR1enq: AM - ASM File Destroyname|modeid1id2Other
12cR1-12cR1enq: AM - ASM Grow ACDname|modeid1id2Other
11gR2-12cR1enq: AM - ASM Password File Updatename|modeid1id2Other
11gR2-12cR1enq: AM - ASM Username|modeid1id2Other
11gR1-12cR1enq: AM - ASM cache freezename|modeid1id2Other
12cR1-12cR1enq: AM - ASM client checkname|modeid1id2Other
12cR1-12cR1enq: AM - ASM client operationname|modeid1id2Other
12cR1-12cR1enq: AM - ASM disk based alloc/deallocname|modeid1id2Other
12cR1-12cR1enq: AM - ASM file access reqname|modeid1id2Other
12cR1-12cR1enq: AM - ASM file chownname|modeid1id2Other
12cR1-12cR1enq: AM - ASM file descriptorname|modeid1id2Other
12cR1-12cR1enq: AM - ASM file relocationname|modeid1id2Other
12cR1-12cR1enq: AM - ASM metadata replicationname|modeid1id2Other
12cR1-12cR1enq: AM - ASM reservedname|modeid1id2Other
12cR1-12cR1enq: AM - Create default DG key in OCRname|modeid1id2Other
12cR1-12cR1enq: AM - Credential creationname|modeid1id2Other
12cR1-12cR1enq: AM - Credential deletionname|modeid1id2Other
12cR1-12cR1enq: AM - Disable Remote ASMname|modeid1id2Other
12cR1-12cR1enq: AM - Enable Remote ASMname|modeid1id2Other
11gR2-11gR2enq: AM - PST split checkname|modeid1id2Other
12cR1-12cR1enq: AM - Register with IOServername|modeid1id2Other
12cR1-12cR1enq: AM - SR slice Clear/Markname|modeid1id2Other
11gR1-12cR1enq: AM - background COD reservationname|modeid1id2Other
12cR1-12cR1enq: AM - block repairname|modeid1id2Other
10gR2-12cR1enq: AM - client registrationname|modeid1id2Other
11gR2-12cR1enq: AM - disk offlinename|modeid1id2Other
11gR2-12cR1enq: AM - group blockname|modeid1id2Other
11gR2-12cR1enq: AM - group usename|modeid1id2Other
10gR2-12cR1enq: AM - rollback COD reservationname|modeid1id2Other
10gR2-12cR1enq: AM - shutdownname|modeid1id2Other
10gR1-12cR1enq: AO - contentionname|modeworkspace #object #Other
12cR1-12cR1enq: AP - contentionname|mode00Other
12cR1-12cR1enq: AQ - QPT fg map dqptname|modeQT_OBJ#0Other
12cR1-12cR1enq: AQ - QPT fg map qptname|modeQT_OBJ#0Other
12cR1-12cR1enq: AR - contentiontype|modeid1id2Other
10gR1-10gR1enq: AS - contentionname|mode00Other
10gR2-10gR2enq: AS - modify servicename|mode00Other
10gR2-12cR1enq: AS - service activationname|mode00Other
10gR1-12cR1enq: AT - contentionname|mode00Other
10gR2-11gR2enq: AU - audit index filename|modeXML audit index file0Other
11gR2-12cR1enq: AV - AVD client registrationname|modepersistent DG numbernon-DG number enqsOther
11gR2-12cR1enq: AV - add/enable first volume in DGname|modepersistent DG numbernon-DG number enqsOther
11gR1-11gR1enq: AV - persistent DG numbername|modeunusedpersistent DG numberOther
11gR2-12cR1enq: AV - persistent DG numbername|modepersistent DG numbernon-DG number enqsOther
11gR2-12cR1enq: AV - volume relocatename|modepersistent DG numbernon-DG number enqsOther
10gR1-12cR1enq: AW - AW generation lockname|modeoperationworkspace #Other
10gR1-12cR1enq: AW - AW state lockname|modeoperationworkspace #Other
10gR1-12cR1enq: AW - AW$ table lockname|modeoperationworkspace #Other
10gR1-12cR1enq: AW - user access for AWname|modeoperationworkspace #Other
11gR1-12cR1enq: AY - contentionname|modeOp1Op2Other
12cR1-12cR1enq: BA - SUBBMAP contentionname|mode00Other
11gR1-12cR1enq: BB - 2PC across RAC instancesname|modegtrid hash valuebqual hash valueCommit
12cR1-12cR1enq: BC - create containername|modecontainer groupcontainer idOther
12cR1-12cR1enq: BC - drop containername|modecontainer groupcontainer idOther
12cR1-12cR1enq: BC - drop container groupname|modecontainer groupcontainer idOther
12cR1-12cR1enq: BC - group - create containername|modecontainer groupcontainer idOther
12cR1-12cR1enq: BC - group - create filename|modecontainer groupcontainer idOther
10gR2-12cR1enq: BF - PMON Join Filter cleanupname|modenode#/parallelizer#bloom#Other
10gR2-12cR1enq: BF - allocation contentionname|modenode#/parallelizer#bloom#Other
12cR1-12cR1enq: BI - create filename|modegroup ID / file IDfile IDOther
12cR1-12cR1enq: BI - delete filename|modegroup ID / file IDfile IDOther
12cR1-12cR1enq: BI - identify filename|modegroup ID / file IDfile IDOther
12cR1-12cR1enq: BM - clonedb bitmap file writename|modeblock numbernumber of blocksOther
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-12cR1enq: BR - file shrinkname|modeoperationfile #Other
11gR1-12cR1enq: BR - multi-section restore headername|modeoperationfile #Other
11gR1-12cR1enq: BR - multi-section restore sectionname|modeoperationfile #Other
11gR2-12cR1enq: BR - perform autobackupname|modeoperationfile #Other
10gR1-12cR1enq: BR - proxy-copyname|modeoperationfile #Other
11gR2-12cR1enq: BR - request autobackupname|modeoperationfile #Other
11gR1-12cR1enq: BR - space info datafile hdr updatename|modeoperationfile #Other
12cR1-12cR1enq: BV - rebuild/validate groupname|modeamrv$ keyOther
12cR1-12cR1enq: BZ - resize filename|modegroup ID / file IDfile IDOther
11gR1-12cR1enq: CA - contentionname|mode00Other
12cR1-12cR1enq: CB - role operationname|mode00Concurrency
12cR1-12cR1enq: CC - decryptionname|mode00Other
10gR1-12cR1enq: CF - contentionname|mode0operationOther
10gR1-12cR1enq: CI - contentionname|modeopcodetypeOther
10gR1-12cR1enq: CL - compare labelsname|modeobject #0Other
10gR1-12cR1enq: CL - drop labelname|modeobject #0Other
12cR1-12cR1enq: CM - diskgroup dismountname|modedisk group #typeOther
10gR1-12cR1enq: CM - gatename|modedisk group #typeOther
10gR1-12cR1enq: CM - instancename|modedisk group #typeOther
10gR2-12cR1enq: CN - race with initname|modereg id0Other
10gR2-12cR1enq: CN - race with regname|modereg id0Other
10gR2-12cR1enq: CN - race with txnname|modereg id0Other
11gR1-12cR1enq: CO - master slave detname|modeinst id0Other
12cR1-12cR1enq: CP - Pluggable database resetlogsname|modeInternalInternalOther
11gR1-12cR1enq: CQ - contentionname|mode00Other
11gR2-12cR1enq: CR - block range reuse ckptname|mode20Other
10gR1-12cR1enq: CT - CTWR process start/stopname|modeoperationoperation parmOther
10gR1-12cR1enq: CT - change stream ownershipname|modeoperationoperation parmOther
10gR1-12cR1enq: CT - global space managementname|modeoperationoperation parmOther
10gR1-12cR1enq: CT - local space managementname|modeoperationoperation parmOther
10gR1-12cR1enq: CT - readingname|modeoperationoperation parmOther
10gR1-12cR1enq: CT - statename|modeoperationoperation parmOther
10gR1-12cR1enq: CT - state change gate 1name|modeoperationoperation parmOther
10gR1-12cR1enq: CT - state change gate 2name|modeoperationoperation parmOther
10gR1-12cR1enq: CU - contentionname|modehandlehandleOther
12cR1-12cR1enq: CX - TEXT: Index Specific Lockname|modeIndex IdPartition IdOther
10gR1-12cR1enq: DB - contentionname|modeEnqMode0Administrative
10gR1-12cR1enq: DD - contentionname|modedisk grouptypeOther
10gR1-12cR1enq: DF - contentionname|mode0file #Other
10gR1-12cR1enq: DG - contentionname|modedisk grouptypeOther
12cR1-12cR1enq: DI - contentiontype|modeid1id2Other
10gR1-12cR1enq: DL - contentionname|modeobject #0Other
10gR1-12cR1enq: DM - contentionname|modetypetypeOther
10gR1-12cR1enq: DN - contentionname|mode00Other
11gR1-12cR1enq: DO - Staleness Registry createname|modedisk group #disk #Other
11gR1-12cR1enq: DO - disk onlinename|modedisk group #disk #Other
11gR1-11gR2enq: DO - disk online operationname|modedisk group #disk #Other
11gR1-12cR1enq: DO - disk online recoveryname|modedisk group #disk #Other
11gR1-12cR1enq: DO - startup of MARK processname|modedisk group #disk #Other
10gR1-12cR1enq: DP - contentionname|mode00Other
12cR1-12cR1enq: DQ - contentiontype|modeid1id2Other
10gR1-12cR1enq: DR - contentionname|mode00Other
10gR1-12cR1enq: DS - contentionname|mode00Other
10gR1-12cR1enq: DT - contentionname|mode00Other
10gR1-12cR1enq: DV - contentionname|modeobject #0Other
11gR1-12cR1enq: DW - contentionname|modetablespace #dbaOther
10gR1-12cR1enq: DX - contentionname|modetransaction entry #0Other
12cR1-12cR1enq: EA - contentiontype|modeid1id2Other
12cR1-12cR1enq: EB - contentiontype|modeid1id2Other
12cR1-12cR1enq: EC - contentiontype|modeid1id2Other
12cR1-12cR1enq: ED - contentiontype|modeid1id2Other
12cR1-12cR1enq: EE - contentiontype|modeid1id2Other
12cR1-12cR1enq: EF - contentiontype|modeid1id2Other
12cR1-12cR1enq: EG - contentiontype|modeid1id2Other
12cR1-12cR1enq: EH - contentiontype|modeid1id2Other
12cR1-12cR1enq: EI - contentiontype|modeid1id2Other
12cR1-12cR1enq: EJ - contentiontype|modeid1id2Other
12cR1-12cR1enq: EK - contentiontype|modeid1id2Other
12cR1-12cR1enq: EL - contentiontype|modeid1id2Other
12cR1-12cR1enq: EM - contentiontype|modeid1id2Other
12cR1-12cR1enq: EN - contentiontype|modeid1id2Other
12cR1-12cR1enq: EO - contentiontype|modeid1id2Other
12cR1-12cR1enq: EP - contentiontype|modeid1id2Other
12cR1-12cR1enq: EQ - contentiontype|modeid1id2Other
12cR1-12cR1enq: ER - contentiontype|modeid1id2Other
12cR1-12cR1enq: ES - contentiontype|modeid1id2Other
12cR1-12cR1enq: ET - contentiontype|modeid1id2Other
12cR1-12cR1enq: EU - contentiontype|modeid1id2Other
12cR1-12cR1enq: EV - contentiontype|modeid1id2Other
12cR1-12cR1enq: EX - contentiontype|modeid1id2Other
12cR1-12cR1enq: EY - contentiontype|modeid1id2Other
12cR1-12cR1enq: EZ - contentiontype|modeid1id2Other
10gR1-12cR1enq: FA - access filename|modedisk group numberfile numberOther
10gR1-12cR1enq: FB - contentionname|modetablespace #dbaOther
10gR1-12cR1enq: FC - open an ACD threadname|modedisk groupthreadOther
10gR1-12cR1enq: FC - recover an ACD threadname|modedisk groupthreadOther
10gR1-12cR1enq: FD - Flashback coordinatorname|modeInternalInternalOther
11gR2-12cR1enq: FD - Flashback logical operationsname|modeInternalInternalOther
10gR1-12cR1enq: FD - Flashback on/offname|modeInternalInternalOther
10gR1-12cR1enq: FD - Marker generationname|modeInternalInternalOther
10gR2-12cR1enq: FD - Restore point create/dropname|modeInternalInternalOther
10gR1-12cR1enq: FD - Tablespace flashback on/offname|modeInternalInternalOther
11gR1-12cR1enq: FE - contentionname|mode00Other
10gR1-12cR1enq: FG - FG redo generation enq racename|modedisk grouptypeOther
10gR1-12cR1enq: FG - LGWR redo generation enq racename|modedisk grouptypeOther
10gR1-12cR1enq: FG - serialize ACD relocatename|modedisk grouptypeOther
12cR1-12cR1enq: FH - contentionname|modeInstance IDOther
10gR1-12cR1enq: FL - Flashback database logname|modeLog #zeroOther
10gR1-12cR1enq: FL - Flashback db commandname|modeLog #zeroOther
10gR1-12cR1enq: FM - contentionname|mode00Other
12cR1-12cR1enq: FO - file system operation contentionname|mode00Other
10gR2-12cR1enq: FP - global fob contentionname|modelow file obj addhigh file obj addOther
10gR1-11gR1enq: FR - contentionname|modedisk groupunusedOther
11gR2-12cR1enq: FR - contentionname|modedisk groupthreadOther
11gR2-12cR1enq: FR - recover the threadname|modedisk groupthreadOther
11gR2-12cR1enq: FR - use the threadname|modedisk groupthreadOther
10gR1-12cR1enq: FS - contentionname|mode0typeOther
12cR1-12cR1enq: FS - online log operationname|mode0typeOther
10gR1-12cR1enq: FT - allow LGWR writesname|modedisk groupthreadOther
10gR1-12cR1enq: FT - disable LGWR writesname|modedisk groupthreadOther
10gR1-12cR1enq: FU - contentionname|mode00Other
12cR1-12cR1enq: FW - contentiontype|modeid1id2Other
11gR1-12cR1enq: FX - issue ACD Xtnt Relocation CICname|modedisk groupunusedOther
12cR1-12cR1enq: FZ - contentiontype|modeid1id2Other
12cR1-12cR1enq: GA - contentiontype|modeid1id2Other
12cR1-12cR1enq: GB - contentiontype|modeid1id2Other
12cR1-12cR1enq: GC - contentiontype|modeid1id2Other
12cR1-12cR1enq: GD - contentiontype|modeid1id2Other
12cR1-12cR1enq: GE - contentiontype|modeid1id2Other
12cR1-12cR1enq: GF - contentiontype|modeid1id2Other
12cR1-12cR1enq: GG - contentiontype|modeid1id2Other
12cR1-12cR1enq: GH - contentiontype|modeid1id2Other
12cR1-12cR1enq: GI - contentiontype|modeid1id2Other
12cR1-12cR1enq: GJ - contentiontype|modeid1id2Other
12cR1-12cR1enq: GK - contentiontype|modeid1id2Other
12cR1-12cR1enq: GL - contentiontype|modeid1id2Other
12cR1-12cR1enq: GM - contentiontype|modeid1id2Other
12cR1-12cR1enq: GN - contentiontype|modeid1id2Other
12cR1-12cR1enq: GO - contentiontype|modeid1id2Other
12cR1-12cR1enq: GP - contentiontype|modeid1id2Other
12cR1-12cR1enq: GQ - contentiontype|modeid1id2Other
12cR1-12cR1enq: GR - contentiontype|modeid1id2Other
12cR1-12cR1enq: GS - contentiontype|modeid1id2Other
12cR1-12cR1enq: GT - contentiontype|modeid1id2Other
12cR1-12cR1enq: GU - contentiontype|modeid1id2Other
12cR1-12cR1enq: GV - contentiontype|modeid1id2Other
12cR1-12cR1enq: GX - contentiontype|modeid1id2Other
12cR1-12cR1enq: GY - contentiontype|modeid1id2Other
12cR1-12cR1enq: GZ - contentiontype|modeid1id2Other
10gR1-12cR1enq: HD - contentionname|modedisk group0Other
12cR1-12cR1enq: HM - contentiontype|modeid1id2Other
10gR1-12cR1enq: HP - contentionname|modetablespace #dbaOther
10gR1-12cR1enq: HQ - contentionname|modeobject #hash valueOther
10gR1-12cR1enq: HV - contentionname|modeobject #0Other
10gR1-12cR1enq: HW - contentionname|modetable space #blockConfiguration
10gR1-12cR1enq: IA - contentionname|mode00Other
12cR1-12cR1enq: IC - IOServer clientIDname|modeclient idnoneOther
10gR1-12cR1enq: ID - contentionname|mode00Other
12cR1-12cR1enq: IF - file closename|modeclient id/group numFile numberOther
12cR1-12cR1enq: IF - file openname|modeclient id/group numFile numberOther
10gR1-12cR1enq: IL - contentionname|modeobject #0Other
10gR1-12cR1enq: IM - contention for blrname|modepool #0Other
12cR1-12cR1enq: IP - open/close PDBname|mode0typeOther
12cR1-12cR1enq: IR - arbitrate instance recoveryname|mode00/1Other
10gR1-12cR1enq: IR - contentionname|mode00/1Other
10gR1-12cR1enq: IR - contention2name|mode00/1Other
12cR1-12cR1enq: IR - global serializationname|mode00/1Other
12cR1-12cR1enq: IR - local serializationname|mode00/1Other
10gR1-12cR1enq: IS - contentionname|mode0typeOther
10gR1-12cR1enq: IT - contentionname|modeobject #0Other
12cR1-12cR1enq: IV - contentiontype|modeid1id2Other
12cR1-12cR1enq: IZ - contentiontype|modeid1id2Other
10gR1-12cR1enq: JD - contentionname|mode00Other
10gR1-12cR1enq: JI - contentionname|modeview object #0Other
10gR1-12cR1enq: JQ - contentionname|mode00Other
11gR1-12cR1enq: 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-12cR1enq: 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-12cR1enq: JS - job recov lockname|modeservice IDqueue typeOther
10gR1-12cR1enq: 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-12cR1enq: JS - wdw opname|modeservice IDqueue typeOther
11gR2-12cR1enq: JX - SQL statement queuename|modesqlidexecidScheduler
11gR2-12cR1enq: JX - cleanup of queuename|modesqlidexecidScheduler
11gR2-12cR1enq: KD - determine DBRM mastername|mode00Other
12cR1-12cR1enq: KE - contentiontype|modeid1id2Other
12cR1-12cR1enq: KI - contentionname|modeclient opcode0Other
10gR1-10gR2enq: KK - contextname|mode0redo threadOther
12cR1-12cR1enq: KL - contentiontype|modeid1id2Other
10gR1-12cR1enq: KM - contentionname|modetypetypeOther
10gR2-12cR1enq: KO - fast object checkpointname|mode20Application
10gR1-12cR1enq: KP - contentionname|mode00Other
11gR1-12cR1enq: KQ - access ASM attributename|modegroupentryOther
10gR1-12cR1enq: KT - contentionname|modeplan #0Other
12cR1-12cR1enq: KZ - contentiontype|modeid1id2Other
12cR1-12cR1enq: LA - contentiontype|modeid1id2Other
12cR1-12cR1enq: LB - contentiontype|modeid1id2Other
12cR1-12cR1enq: LC - contentiontype|modeid1id2Other
12cR1-12cR1enq: LD - contentiontype|modeid1id2Other
12cR1-12cR1enq: LE - contentiontype|modeid1id2Other
12cR1-12cR1enq: LF - contentiontype|modeid1id2Other
12cR1-12cR1enq: LG - contentiontype|modeid1id2Other
12cR1-12cR1enq: LH - contentiontype|modeid1id2Other
12cR1-12cR1enq: LI - contentiontype|modeid1id2Other
12cR1-12cR1enq: LJ - contentiontype|modeid1id2Other
12cR1-12cR1enq: LK - contentiontype|modeid1id2Other
12cR1-12cR1enq: LL - contentiontype|modeid1id2Other
12cR1-12cR1enq: LM - contentiontype|modeid1id2Other
12cR1-12cR1enq: LN - contentiontype|modeid1id2Other
12cR1-12cR1enq: LO - contentiontype|modeid1id2Other
12cR1-12cR1enq: LP - contentiontype|modeid1id2Other
12cR1-12cR1enq: LQ - contentiontype|modeid1id2Other
12cR1-12cR1enq: LR - contentiontype|modeid1id2Other
12cR1-12cR1enq: LS - contentiontype|modeid1id2Other
12cR1-12cR1enq: LT - contentiontype|modeid1id2Other
12cR1-12cR1enq: LU - contentiontype|modeid1id2Other
12cR1-12cR1enq: LV - contentiontype|modeid1id2Other
12cR1-12cR1enq: LX - contentiontype|modeid1id2Other
12cR1-12cR1enq: LY - contentiontype|modeid1id2Other
12cR1-12cR1enq: LZ - contentiontype|modeid1id2Other
12cR1-12cR1enq: MC - Securefile logname|mode0hash(logname)Other
10gR1-12cR1enq: MD - contentionname|modemaster object #0Other
12cR1-12cR1enq: MF - creating swap in instancename|modelogidbktId<<16|instidOther
12cR1-12cR1enq: MF - flush bkgnd periodicname|modelogidbktId<<16|instidOther
12cR1-12cR1enq: MF - flush clientname|modelogidbktId<<16|instidOther
12cR1-12cR1enq: MF - flush destroyname|modelogidbktId<<16|instidOther
12cR1-12cR1enq: MF - flush prior errorname|modelogidbktId<<16|instidOther
12cR1-12cR1enq: MF - flush spacename|modelogidbktId<<16|instidOther
10gR1-12cR1enq: MH - contentionname|mode00Other
10gR2-12cR1enq: MK - contentionname|mode00Other
10gR1-12cR1enq: ML - contentionname|mode00Other
10gR1-12cR1enq: MN - contentionname|modesession ID0Other
10gR2-12cR1enq: MO - contentionname|mode00Other
12cR1-12cR1enq: MR - PDB openname|mode0 or file #typeOther
12cR1-12cR1enq: MR - adg instance recoveryname|mode0 or file #typeOther
12cR1-12cR1enq: MR - any role transitionname|mode0 or file #typeOther
10gR1-12cR1enq: MR - contentionname|mode0 or file #typeOther
12cR1-12cR1enq: MR - datafile onlinename|mode0 or file #typeOther
12cR1-12cR1enq: MR - multi instance redo applyname|mode0 or file #typeOther
11gR2-12cR1enq: MR - standby role transitionname|mode0 or file #typeOther
10gR1-12cR1enq: MS - contentionname|modemaster object #0Other
11gR2-12cR1enq: MV - datafile movename|modetypefile #Administrative
10gR1-12cR1enq: MW - contentionname|modeSchedule Id0Other
11gR1-12cR1enq: MX - sync storage server infoname|modenodeidinstanceidOther
12cR1-12cR1enq: NA - contentiontype|modeid1id2Other
12cR1-12cR1enq: NB - contentiontype|modeid1id2Other
12cR1-12cR1enq: NC - contentiontype|modeid1id2Other
12cR1-12cR1enq: ND - contentiontype|modeid1id2Other
12cR1-12cR1enq: NE - contentiontype|modeid1id2Other
12cR1-12cR1enq: NF - contentiontype|modeid1id2Other
12cR1-12cR1enq: NG - contentiontype|modeid1id2Other
12cR1-12cR1enq: NH - contentiontype|modeid1id2Other
12cR1-12cR1enq: NI - contentiontype|modeid1id2Other
12cR1-12cR1enq: NJ - contentiontype|modeid1id2Other
12cR1-12cR1enq: NK - contentiontype|modeid1id2Other
12cR1-12cR1enq: NL - contentiontype|modeid1id2Other
12cR1-12cR1enq: NM - contentiontype|modeid1id2Other
12cR1-12cR1enq: NN - contentiontype|modeid1id2Other
12cR1-12cR1enq: NO - contentiontype|modeid1id2Other
12cR1-12cR1enq: NP - contentiontype|modeid1id2Other
12cR1-12cR1enq: NQ - contentiontype|modeid1id2Other
12cR1-12cR1enq: NR - contentiontype|modeid1id2Other
12cR1-12cR1enq: NS - contentiontype|modeid1id2Other
12cR1-12cR1enq: NT - contentiontype|modeid1id2Other
12cR1-12cR1enq: NU - contentiontype|modeid1id2Other
12cR1-12cR1enq: NV - contentiontype|modeid1id2Other
12cR1-12cR1enq: NX - contentiontype|modeid1id2Other
12cR1-12cR1enq: NY - contentiontype|modeid1id2Other
12cR1-12cR1enq: NZ - contentiontype|modeid1id2Other
10gR1-12cR1enq: OC - contentionname|mode12Other
11gR1-12cR1enq: OD - Serializing DDLsname|modeobject #0Other
10gR1-12cR1enq: OL - contentionname|modehash value0Other
12cR1-12cR1enq: OP - OLS Cleanup unused profilesname|modeobject #0Other
12cR1-12cR1enq: OP - OLS Store user entriesname|modeobject #0Other
10gR1-12cR1enq: OQ - xsoq*histrecbname|moderesource id0Other
10gR1-12cR1enq: OQ - xsoqhiAllocname|moderesource id0Other
10gR1-12cR1enq: OQ - xsoqhiClosename|moderesource id0Other
10gR1-12cR1enq: OQ - xsoqhiFlushname|moderesource id0Other
10gR1-12cR1enq: OQ - xsoqhistrecbname|moderesource id0Other
12cR1-12cR1enq: OT - TEXT: Generic Lockname|mode00Other
10gR2-12cR1enq: OW - initializationname|mode00Other
10gR2-12cR1enq: OW - terminationname|mode00Other
12cR1-12cR1enq: PA - modify a privilege capturename|mode00Other
12cR1-12cR1enq: PA - read a privilege capturename|mode00Other
12cR1-12cR1enq: PB - PDB Lockname|mode0typeOther
10gR1-12cR1enq: PD - contentionname|modeproperty namekey hashOther
10gR1-12cR1enq: PE - contentionname|modeparno0Other
10gR1-12cR1enq: PF - contentionname|mode00Other
10gR1-12cR1enq: PG - contentionname|mode00Other
10gR1-12cR1enq: PH - contentionname|mode00Other
10gR1-12cR1enq: PI - contentionname|modeoperationserial #Other
10gR1-12cR1enq: PL - contentionname|mode00Other
12cR1-12cR1enq: PM - contentiontype|modeid1id2Other
12cR1-12cR1enq: PP - contentiontype|modeid1id2Other
12cR1-12cR1enq: PQ - QPT LB Trunc syncname|modeQT_OBJ#0Other
12cR1-12cR1enq: PQ - QPT Truncname|modeQT_OBJ#0Other
12cR1-12cR1enq: PQ - QPT add dqptname|modeQT_OBJ#0Other
12cR1-12cR1enq: PQ - QPT add dqpt fgname|modeQT_OBJ#0Other
12cR1-12cR1enq: PQ - QPT add qptname|modeQT_OBJ#0Other
12cR1-12cR1enq: PQ - QPT add qpt fgname|modeQT_OBJ#0Other
12cR1-12cR1enq: PQ - QPT drop dqptname|modeQT_OBJ#0Other
12cR1-12cR1enq: PQ - QPT drop qptname|modeQT_OBJ#0Other
10gR1-11gR2enq: PR - contentionname|mode00Other
12cR1-12cR1enq: PR - contentionname|modetypedtpOther
10gR1-12cR1enq: PS - contentionname|modeinstanceslave IDOther
10gR1-12cR1enq: PT - contentionname|modedisk group #typeOther
10gR1-11gR2enq: PV - syncshutname|mode00Other
12cR1-12cR1enq: PV - syncshutname|modeclass id0Other
10gR1-11gR2enq: PV - syncstartname|mode00Other
12cR1-12cR1enq: PV - syncstartname|modeclass id0Other
10gR1-12cR1enq: PW - flush prewarm buffersname|mode00Application
10gR1-12cR1enq: PW - perwarm status in dbw0name|mode00Other
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-12cR1enq: QA - contentiontype|modeid1id2Other
12cR1-12cR1enq: QB - contentiontype|modeid1id2Other
12cR1-12cR1enq: QC - contentiontype|modeid1id2Other
12cR1-12cR1enq: QD - contentiontype|modeid1id2Other
12cR1-12cR1enq: QE - contentiontype|modeid1id2Other
12cR1-12cR1enq: QF - contentiontype|modeid1id2Other
12cR1-12cR1enq: QG - contentiontype|modeid1id2Other
12cR1-12cR1enq: QH - contentiontype|modeid1id2Other
12cR1-12cR1enq: QI - contentiontype|modeid1id2Other
12cR1-12cR1enq: QJ - contentiontype|modeid1id2Other
12cR1-12cR1enq: QK - contentiontype|modeid1id2Other
12cR1-12cR1enq: QL - contentiontype|modeid1id2Other
12cR1-12cR1enq: QM - contentiontype|modeid1id2Other
12cR1-12cR1enq: QN - contentiontype|modeid1id2Other
12cR1-12cR1enq: QO - contentiontype|modeid1id2Other
12cR1-12cR1enq: QP - contentiontype|modeid1id2Other
12cR1-12cR1enq: QQ - contentiontype|modeid1id2Other
12cR1-12cR1enq: QR - contentiontype|modeid1id2Other
12cR1-12cR1enq: QS - contentiontype|modeid1id2Other
12cR1-12cR1enq: QT - contentiontype|modeid1id2Other
12cR1-12cR1enq: QU - contentiontype|modeid1id2Other
12cR1-12cR1enq: QV - contentiontype|modeid1id2Other
12cR1-12cR1enq: QX - contentiontype|modeid1id2Other
12cR1-12cR1enq: QY - contentiontype|modeid1id2Other
12cR1-12cR1enq: QZ - contentiontype|modeid1id2Other
12cR1-12cR1enq: RA - RT ADDM flood controlname|mode00Other
10gR1-12cR1enq: RB - contentionname|modedisk group0Other
11gR1-12cR1enq: RC - Result Cache: Contentionname|modechunkNoblockNoApplication
11gR2-12cR1enq: RD - RAC loadname|modesqlidexecidOther
11gR1-12cR1enq: RE - block repair contentionname|modeFile Type or File numberblock numberOther
12cR1-12cR1enq: RF - Broker State Lockname|modelock operationlock valueOther
11gR1-12cR1enq: RF - DG Broker Current File IDname|modelock operationlock valueOther
11gR1-12cR1enq: RF - FSFO Observer Heartbeatname|modelock operationlock valueOther
12cR1-12cR1enq: RF - FSFO Primary Shutdown suspendedname|modelock operationlock valueOther
12cR1-12cR1enq: RF - FSFO string buffername|modelock operationlock valueOther
10gR2-12cR1enq: 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-12cR1enq: RF - atomicityname|modelock operationlock valueOther
10gR1-12cR1enq: RF - new AIname|modelock operationlock valueOther
10gR2-12cR1enq: 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-12cR1enq: RF - synchronization: aifo mastername|modelock operationlock valueOther
10gR1-10gR2enq: RF - synchronization: chiefname|modelock operationlock valueOther
10gR1-12cR1enq: RF - synchronization: critical ainame|modelock operationlock valueOther
11gR2-12cR1enq: RK - set keyname|mode00Other
11gR2-12cR1enq: RL - RAC wallet lockname|mode00Other
12cR1-12cR1enq: RM - contentiontype|modeid1id2Other
10gR1-12cR1enq: RN - contentionname|modethread numberlog numberOther
10gR1-10gR1enq: RO - contentionname|mode10Application
10gR2-12cR1enq: RO - contentionname|mode20Application
10gR1-10gR1enq: RO - fast object reusename|mode10Application
10gR2-12cR1enq: RO - fast object reusename|mode20Application
10gR1-12cR1enq: RP - contentionname|modefile #1 or blockOther
12cR1-12cR1enq: RQ - AQ indexed cached commitname|modeQ_OBJ#shard:modeOther
12cR1-12cR1enq: RQ - AQ uncached commit WM updatename|modeQ_OBJ#shard:modeOther
12cR1-12cR1enq: RQ - AQ uncached dequeuename|modeQ_OBJ#shard:modeOther
12cR1-12cR1enq: RQ - Cross export subshardname|modeQ_OBJ#shard:modeOther
12cR1-12cR1enq: RQ - Cross import subshardname|modeQ_OBJ#shard:modeOther
12cR1-12cR1enq: RQ - Cross update scnname|modeQ_OBJ#shard:modeOther
12cR1-12cR1enq: RQ - Dequeue update scnname|modeQ_OBJ#shard:modeOther
12cR1-12cR1enq: RQ - Enqueue commit cachedname|modeQ_OBJ#shard:modeOther
12cR1-12cR1enq: RQ - Enqueue commit uncachedname|modeQ_OBJ#shard:modeOther
12cR1-12cR1enq: RQ - Free shadow shardname|modeQ_OBJ#shard:modeOther
12cR1-12cR1enq: RQ - Parallel cross update scnname|modeQ_OBJ#shard:modeOther
12cR1-12cR1enq: RQ - Trucate subshardname|modeQ_OBJ#shard:modeOther
10gR2-12cR1enq: RR - contentionname|modelock#not usedOther
10gR1-12cR1enq: RS - file deletename|moderecord typerecord idOther
10gR1-12cR1enq: RS - persist alert levelname|moderecord typerecord idOther
10gR1-12cR1enq: RS - prevent aging list updatename|moderecord typerecord idOther
10gR1-12cR1enq: RS - prevent file deletename|moderecord typerecord idOther
10gR1-12cR1enq: RS - read alert levelname|moderecord typerecord idOther
10gR1-12cR1enq: RS - record reusename|moderecord typerecord idOther
10gR1-12cR1enq: RS - write alert levelname|moderecord typerecord idOther
10gR1-12cR1enq: RT - contentionname|moderedo threadtypeOther
11gR2-12cR1enq: RT - thread internal enable/disablename|moderedo threadtypeOther
10gR2-12cR1enq: RU - contentionname|mode00Other
10gR2-12cR1enq: RU - waitingname|mode00Other
10gR2-12cR1enq: RW - MV metadata contentionname|modetable obj#0Other
11gR1-12cR1enq: RX - relocate extentname|modedisk group #:file #virtual extent numberOther
12cR1-12cR1enq: RX - unlock extentname|modedisk group #:file #virtual extent numberOther
12cR1-12cR1enq: RZ - add elementname|mode00Other
12cR1-12cR1enq: RZ - remove elementname|mode00Other
10gR1-11gR2enq: SB - contentionname|mode00Other
12cR1-12cR1enq: SB - logical standby metadataname|mode00Other
12cR1-12cR1enq: SB - table instantiationname|mode00Other
12cR1-12cR1enq: SC - contentiontype|modeid1id2Other
10gR2-12cR1enq: SE - contentionname|modeSession-idSerial#Other
10gR1-12cR1enq: SF - contentionname|mode00Other
12cR1-12cR1enq: SG - OLS Add Groupname|modeobject #0Other
12cR1-12cR1enq: SG - OLS Alter Group Parentname|modeobject #0Other
12cR1-12cR1enq: SG - OLS Create Groupname|modeobject #0Other
12cR1-12cR1enq: SG - OLS Drop Groupname|modeobject #0Other
10gR1-12cR1enq: SH - contentionname|mode00Other
10gR1-12cR1enq: SI - contentionname|modeobject #0Other
11gR1-12cR1enq: SJ - Slave Task Cancelname|modeSlave process idtask idOther
10gR1-12cR1enq: SK - contentionname|modetablespace #dbaOther
11gR1-12cR1enq: SL - escalate lockname|modekdlw lobid first halfkdlw lobid sec halfOther
11gR1-12cR1enq: SL - get lockname|modekdlw lobid first halfkdlw lobid sec halfOther
11gR1-12cR1enq: SL - get lock for undoname|modekdlw lobid first halfkdlw lobid sec halfOther
12cR1-12cR1enq: SM - contentiontype|modeid1id2Other
11gR1-12cR1enq: SO - contentionname|modeobject #0Other
11gR2-11gR2enq: SP - contentionname|modeid1id2Other
12cR1-12cR1enq: SP - contention 1name|modeid1id2Other
11gR2-12cR1enq: SP - contention 2name|modeid1id2Other
11gR2-12cR1enq: SP - contention 3name|modeid1id2Other
11gR2-12cR1enq: SP - contention 4name|modeid1id2Other
10gR1-12cR1enq: SQ - contentionname|modeobject #0Configuration
10gR1-12cR1enq: SR - contentionname|modeoperationsequence # / apply #Other
10gR1-12cR1enq: SS - contentionname|modetablespace #dbaOther
10gR1-12cR1enq: ST - contentionname|mode00Configuration
10gR1-12cR1enq: SU - contentionname|modetable space #0Other
12cR1-12cR1enq: SV - contentiontype|modeid1id2Other
10gR1-12cR1enq: SW - contentionname|mode00Other
10gR1-12cR1enq: TA - contentionname|modeoperationundo segment # / otherOther
10gR1-12cR1enq: TB - SQL Tuning Base Cache Loadname|mode12Other
10gR1-12cR1enq: TB - SQL Tuning Base Cache Updatename|mode12Other
10gR1-12cR1enq: TC - contentionname|modecheckpoint ID0Other
10gR1-12cR1enq: TC - contention2name|modecheckpoint ID0Other
10gR1-12cR1enq: TD - KTF dump entriesname|mode00Other
10gR1-12cR1enq: TE - KTF broadcastname|mode00Other
10gR1-12cR1enq: TF - contentionname|modetablespace #relative file #Other
11gR1-12cR1enq: TH - metric threshold evaluationname|mode00Other
11gR1-12cR1enq: TK - Auto Task Serializationname|mode0-MMON、 1-MMON Slave0Other
11gR1-12cR1enq: TK - Auto Task Slave Lockoutname|mode0-MMON、 1-MMON Slave0Other
10gR1-12cR1enq: TL - contentionname|mode00Other
10gR1-12cR1enq: TM - contentionname|modeobject #table/partitionApplication
10gR1-12cR1enq: TO - contentionname|modeobject #1Other
11gR2-12cR1enq: TP - contentionname|mode00Other
12cR1-12cR1enq: TQ - sq TM contentionname|modeQT_OBJ#0Other
10gR1-12cR1enq: TQ - DDL contentionname|modeQT_OBJ#0Other
11gR1-12cR1enq: TQ - DDL-INI contentionname|modeQT_OBJ#0Other
10gR1-12cR1enq: TQ - INI contentionname|modeQT_OBJ#0Other
12cR1-12cR1enq: TQ - INI sq contentionname|modeQT_OBJ#0Other
10gR1-12cR1enq: TQ - TM contentionname|modeQT_OBJ#0Other
10gR1-12cR1enq: TS - contentionname|modetablespace IDdbaOther
10gR1-12cR1enq: TT - contentionname|modetablespace IDoperationOther
10gR1-12cR1enq: TW - contentionname|mode0operationAdministrative
10gR1-12cR1enq: TX - allocate ITL entryname|modeusn<<16 | slotsequenceConfiguration
10gR1-12cR1enq: TX - contentionname|modeusn<<16 | slotsequenceOther
10gR1-12cR1enq: TX - index contentionname|modeusn<<16 | slotsequenceConcurrency
10gR1-12cR1enq: TX - row lock contentionname|modeusn<<16 | slotsequenceApplication
10gR1-12cR1enq: UL - contentionname|modeid0Application
10gR1-12cR1enq: US - contentionname|modeundo segment #0Other
12cR1-12cR1enq: VA - contentiontype|modeid1id2Other
12cR1-12cR1enq: VB - contentiontype|modeid1id2Other
12cR1-12cR1enq: VC - contentiontype|modeid1id2Other
12cR1-12cR1enq: VD - contentiontype|modeid1id2Other
12cR1-12cR1enq: VE - contentiontype|modeid1id2Other
12cR1-12cR1enq: VF - contentiontype|modeid1id2Other
12cR1-12cR1enq: VG - contentiontype|modeid1id2Other
12cR1-12cR1enq: VH - contentiontype|modeid1id2Other
12cR1-12cR1enq: VI - contentiontype|modeid1id2Other
12cR1-12cR1enq: VJ - contentiontype|modeid1id2Other
12cR1-12cR1enq: VK - contentiontype|modeid1id2Other
12cR1-12cR1enq: VL - contentiontype|modeid1id2Other
12cR1-12cR1enq: VM - contentiontype|modeid1id2Other
12cR1-12cR1enq: VN - contentiontype|modeid1id2Other
12cR1-12cR1enq: VO - contentiontype|modeid1id2Other
12cR1-12cR1enq: VP - contentiontype|modeid1id2Other
12cR1-12cR1enq: VQ - contentiontype|modeid1id2Other
12cR1-12cR1enq: VR - contentiontype|modeid1id2Other
12cR1-12cR1enq: VS - contentiontype|modeid1id2Other
12cR1-12cR1enq: VT - contentiontype|modeid1id2Other
12cR1-12cR1enq: VU - contentiontype|modeid1id2Other
12cR1-12cR1enq: VV - contentiontype|modeid1id2Other
12cR1-12cR1enq: VX - contentiontype|modeid1id2Other
12cR1-12cR1enq: VY - contentiontype|modeid1id2Other
12cR1-12cR1enq: VZ - contentiontype|modeid1id2Other
10gR1-12cR1enq: WA - contentionname|mode00Other
10gR1-12cR1enq: WF - contentionname|mode00Other
11gR1-12cR1enq: WG - delete fsoname|modekdlw lobid first halfkdlw lobid sec halfOther
11gR1-12cR1enq: WG - lock fsoname|modekdlw lobid first halfkdlw lobid sec halfConcurrency
12cR1-12cR1enq: WL - Far Sync Fail Overname|modelog # / thread id #sequence #Other
11gR2-12cR1enq: WL - RAC-wide SGA contentionname|modelog # / thread id #sequence #Other
11gR2-12cR1enq: WL - RFS global state contentionname|modelog # / thread id #sequence #Other
12cR1-12cR1enq: WL - Switchover To Primaryname|modelog # / thread id #sequence #Other
11gR2-12cR1enq: WL - Test access/lockingname|modelog # / thread id #sequence #Other
10gR1-12cR1enq: WL - contentionname|modelog # / thread id #sequence #Other
12cR1-12cR1enq: WL - redo_db table queryname|modelog # / thread id #sequence #Other
12cR1-12cR1enq: WL - redo_db table updatename|modelog # / thread id #sequence #Other
12cR1-12cR1enq: WL - redo_log table queryname|modelog # / thread id #sequence #Other
12cR1-12cR1enq: 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-12cR1enq: WM - WLM Plan activationname|mode00Other
10gR1-12cR1enq: WP - contentionname|mode00Other
10gR2-12cR1enq: WR - contentionname|modethread id #sequence #Other
12cR1-12cR1enq: WS - contentiontype|modeid1id2Other
12cR1-12cR1enq: XB - contentiontype|modeid1id2Other
11gR1-12cR1enq: XC - XDB Configurationname|modeOther
12cR1-12cR1enq: XD - ASM disk OFFLINEname|modeopcodenotusedOther
12cR1-12cR1enq: XD - ASM disk ONLINEname|modeopcodenotusedOther
11gR2-12cR1enq: XD - ASM disk drop/addname|modeopcodenotusedOther
10gR1-12cR1enq: XH - contentionname|mode00Other
12cR1-12cR1enq: XK - contentiontype|modeid1id2Other
11gR1-12cR1enq: XL - fault extent mapname|modemap idnothingOther
12cR1-12cR1enq: XM - contentiontype|modeid1id2Other
11gR2-12cR1enq: XQ - purificationname|modedisk group #unusedOther
10gR2-12cR1enq: XQ - recoveryname|modedisk group #unusedOther
10gR2-12cR1enq: XQ - relocationname|modedisk group #unusedOther
10gR1-12cR1enq: XR - database force loggingname|modeoperation0Other
10gR1-12cR1enq: XR - quiesce databasename|modeoperation0Other
10gR1-12cR1enq: XY - contentionname|modeid1id2Other
12cR1-12cR1enq: YA - contentiontype|modeid1id2Other
12cR1-12cR1enq: YB - contentiontype|modeid1id2Other
12cR1-12cR1enq: YC - contentiontype|modeid1id2Other
12cR1-12cR1enq: YD - contentiontype|modeid1id2Other
12cR1-12cR1enq: YE - contentiontype|modeid1id2Other
12cR1-12cR1enq: YF - contentiontype|modeid1id2Other
12cR1-12cR1enq: YG - contentiontype|modeid1id2Other
12cR1-12cR1enq: YH - contentiontype|modeid1id2Other
12cR1-12cR1enq: YI - contentiontype|modeid1id2Other
12cR1-12cR1enq: YJ - contentiontype|modeid1id2Other
12cR1-12cR1enq: YK - contentiontype|modeid1id2Other
12cR1-12cR1enq: YL - contentiontype|modeid1id2Other
12cR1-12cR1enq: YM - contentiontype|modeid1id2Other
12cR1-12cR1enq: YN - contentiontype|modeid1id2Other
12cR1-12cR1enq: YO - contentiontype|modeid1id2Other
12cR1-12cR1enq: YP - contentiontype|modeid1id2Other
12cR1-12cR1enq: YQ - contentiontype|modeid1id2Other
12cR1-12cR1enq: YR - contentiontype|modeid1id2Other
12cR1-12cR1enq: YS - contentiontype|modeid1id2Other
12cR1-12cR1enq: YT - contentiontype|modeid1id2Other
12cR1-12cR1enq: YU - contentiontype|modeid1id2Other
12cR1-12cR1enq: YV - contentiontype|modeid1id2Other
12cR1-12cR1enq: YX - contentiontype|modeid1id2Other
12cR1-12cR1enq: YY - contentiontype|modeid1id2Other
12cR1-12cR1enq: YZ - contentiontype|modeid1id2Other
11gR1-12cR1enq: ZA - add std audit table partitionname|modeKZAM Aud Partition0Other
11gR1-12cR1enq: ZF - add fga audit table partitionname|modeKZAM Fga Partition0Other
10gR2-12cR1enq: ZG - contentionname|modefile group idversion idAdministrative
11gR2-12cR1enq: ZH - compression analysisname|modeobj#ulevelOther
12cR1-12cR1enq: ZS - excl access to spill audit filename|modeSpillover audit file0Other
11gR2-12cR1enq: ZZ - update hash tablesname|modeKSBXIC Action0Other
8i-9ienqueuename|modeid1id2
10gR2-12cR1events in waitclass OtherOther
10gR1-12cR1extent map load/unlockgroupfileextentOther
11gR1-12cR1external table misc IOfilectxiocodeP3User I/O
12cR1-12cR1external table openfilectxfile#User I/O
11gR1-12cR1external table readfilectxfile#sizeUser I/O
12cR1-12cR1external table seekfilectxfile#posUser I/O
11gR1-12cR1external table writefilectxfile#sizeUser I/O
11gR1-12cR1fbar timersleep timefailedIdle
9i-9ifib/fob latch
8i-9ifile identifyfibfile nameopcode
8i-9ifile openfibiov0
12cR1-12cR1first spare wait eventp1p2p3Other
10gR1-12cR1flashback buf free by RVWROther
10gR1-12cR1flashback free VI logOther
11gR2-12cR1flashback log file readlog#block#BytesSystem I/O
11gR2-12cR1flashback log file syncUser I/O
11gR2-12cR1flashback log file writelog#block#BytesSystem I/O
10gR1-12cR1flashback log switchOther
10gR1-10gR1foreground creation: startOther
10gR1-10gR1foreground creation: waitOther
8i-12cR1free buffer waitsfile#block#set-id#Configuration
8i-12cR1free global transaction table entrytriesOther
8i-12cR1free process state objectOther
10gR1-12cR1gc assumeleCluster
10gR1-12cR1gc block recovery requestfile#block#class#Cluster
10gR1-10gR2gc buffer busyfile#block#id#Cluster
11gR1-12cR1gc buffer busy acquirefile#block#class#Cluster
11gR1-12cR1gc buffer busy releasefile#block#class#Cluster
11gR1-12cR1gc cancel retryCluster
10gR1-12cR1gc claimCluster
10gR1-12cR1gc cr block 2-wayCluster
10gR1-12cR1gc cr block 3-wayCluster
10gR1-12cR1gc cr block busyCluster
10gR1-12cR1gc cr block congestedCluster
10gR2-12cR1gc cr block lostCluster
10gR1-12cR1gc cr block unknownCluster
10gR1-12cR1gc cr cancelleCluster
10gR1-12cR1gc cr disk readCluster
10gR1-12cR1gc cr disk requestfile#block#class#Cluster
10gR1-12cR1gc cr failureCluster
10gR1-12cR1gc cr grant 2-wayCluster
10gR1-12cR1gc cr grant busyCluster
10gR1-12cR1gc cr grant congestedCluster
12cR1-12cR1gc cr grant kaCluster
10gR1-12cR1gc cr grant unknownCluster
10gR1-12cR1gc cr multi block requestfile#block#class#Cluster
10gR1-12cR1gc cr requestfile#block#class#Cluster
10gR1-12cR1gc current block 2-wayCluster
10gR1-12cR1gc current block 3-wayCluster
10gR1-12cR1gc current block busyCluster
10gR1-12cR1gc current block congestedCluster
10gR2-12cR1gc current block lostCluster
10gR1-12cR1gc current block unknownCluster
10gR1-12cR1gc current cancelleCluster
10gR1-12cR1gc current grant 2-wayCluster
10gR1-12cR1gc current grant busyCluster
10gR1-12cR1gc current grant congestedCluster
12cR1-12cR1gc current grant kaCluster
10gR1-12cR1gc current grant unknownCluster
10gR1-12cR1gc current multi block requestfile#block#id#Cluster
10gR1-12cR1gc current requestfile#block#id#Cluster
10gR1-12cR1gc current retryCluster
10gR1-12cR1gc current splitCluster
10gR1-10gR1gc domain validationCluster
10gR2-12cR1gc domain validationfile#block#class#Cluster
11gR2-12cR1gc flushed bufferCluster
10gR1-12cR1gc freelistCluster
10gR2-12cR1gc object scanCluster
10gR1-10gR2gc prepareCluster
10gR2-12cR1gc quiesceCluster
10gR1-10gR1gc quiesce waitCluster
11gR1-12cR1gc recoveryCluster
10gR1-12cR1gc recovery freeCluster
10gR1-10gR2gc recovery quiesceCluster
11gR1-12cR1gc recovery quiescefile#block#class#Cluster
10gR1-10gR1gc remasterCluster
10gR2-12cR1gc remasterfile#block#class#Cluster
10gR1-12cR1gcs ddet enter server modeOther
9i-12cR1gcs domain validationcluincrcvincOther
10gR1-12cR1gcs drm freeze beginOther
10gR1-12cR1gcs drm freeze in enter server modeOther
10gR1-12cR1gcs enter server modeOther
9i-9igcs for action
11gR2-12cR1gcs lmon dirtydetach step completiondomain idlocationOther
10gR1-12cR1gcs log flush syncwaittimepolleventOther
10gR1-12cR1gcs remastering wait for read latchOther
10gR1-11gR1gcs remastering wait for write latchOther
9i-9igcs remote messagewaittimepollp3
10gR1-12cR1gcs remote messagewaittimepolleventIdle
10gR1-12cR1gcs resource directory to be unfrozenOther
11gR2-12cR1gcs retry nowait latch getlocationOther
9i-12cR1gcs to be enabledOther
11gR1-12cR1ges DFS hang analysis phase 2 acksOther
9i-12cR1ges LMD suspend for testing eventOther
9i-12cR1ges LMD to inherit communication channelsOther
9i-12cR1ges LMD to shutdownOther
9i-9iges LMON for send buffers to be empty
9i-12cR1ges LMON for send queuesOther
9i-12cR1ges LMON to get to FTDONEOther
9i-12cR1ges LMON to join CGS groupOther
9i-9iges LMS suspend for testing event
11gR1-12cR1ges RMS0 retry add redo logOther
9i-12cR1ges cached resource cleanupwaittimeOther
9i-12cR1ges cancelOther
9i-9iges cgs de-registration
9i-9iges cgs registration
10gR1-12cR1ges cgs registrationwhereOther
11gR2-12cR1ges client process to exitOther
9i-9iges drm deferred close
9i-9iges drm freeze begin
9i-12cR1ges enter server modeOther
9i-12cR1ges generic eventOther
9i-11gR1ges global resource directory to be frozenOther
11gR2-12cR1ges global resource directory to be frozenlocationOther
9i-9iges global resource directory to be unfrozen
9i-10gR1ges inquiry responsetype|modeid1id2Other
10gR2-12cR1ges inquiry responsetype|mode|whereid1id2Other
9i-12cR1ges lmd and pmon to attachOther
11gR2-12cR1ges lmd sync during reconfiglocationOther
11gR2-12cR1ges 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-12cR1ges 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-12cR1ges lms sync during dynamic remastering and reconfiglocationlms idOther
9i-12cR1ges master to get established for SCN opOther
11gR2-12cR1ges message buffer allocationpoolrequestallocatedOther
9i-12cR1ges performance test completionOther
9i-12cR1ges pmon to exitOther
9i-9iges proc table latch - kjdrptref
9i-9iges process allocation
9i-12cR1ges process with outstanding i/opidOther
9i-11gR1ges reconfiguration to startOther
9i-12cR1ges remote messagewaittimeloopp3Idle
9i-12cR1ges resource cleanout during enqueue openOther
9i-12cR1ges resource cleanout during enqueue open-cvtOther
10gR1-12cR1ges resource directory to be unfrozenOther
12cR1-12cR1ges resource enqueue open retry sleepOther
10gR1-12cR1ges retry query nodeOther
9i-12cR1ges reusing os pidpidcountOther
9i-9iges server qs to be empty - kjbrrit
10gR1-12cR1ges user errorerrorOther
10gR1-12cR1ges wait for lmon to be readyOther
11gR2-12cR1ges yield cpu in reconfiglocationOther
11gR1-12cR1ges/gcs diag dumplocationOther
9i-9iges1 LMON to wake up LMD
9i-12cR1ges1 LMON to wake up LMD - mrcvrOther
9i-12cR1ges2 LMON to wake up LMD - mrcvrOther
9i-9iges2 LMON to wake up LMD - srcvr
9i-12cR1ges2 LMON to wake up lms - mrcvr 2Other
10gR1-12cR1ges2 LMON to wake up lms - mrcvr 3Other
9i-12cR1ges2 proc latch in rm latch get 1Other
9i-12cR1ges2 proc latch in rm latch get 2Other
9i-9iglobal cache assume waitle
8i-9iglobal cache bg ackscountloops
9i-9iglobal cache busyfile#block#id
10gR1-12cR1global 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-12cR1global enqueue expand waitOther
11gR2-12cR1global plug and play automatic resource creationwhereOther
12cR1-12cR1gopp msggopp idIdle
11gR2-12cR1heartbeat monitor sleepIdle
12cR1-12cR1heartbeat redo informerIdle
9i-12cR1i/o slave waitmsg ptrOther
8i-12cR1imm opmsg ptrOther
8i-10gR2inactive sessionsession#waitedOther
11gR1-12cR1inactive sessionsession#waitedinstance|serialOther
8i-12cR1inactive transaction branchbranch#waitedOther
9i-12cR1index (re)build online cleanupobjectmodewaitAdministrative
9i-12cR1index (re)build online mergeobjectmodewaitAdministrative
9i-12cR1index (re)build online startobjectmodewaitAdministrative
8i-12cR1index block splitrootdbalevelchilddbaOther
8i-9iinstance recoveryundo segment#
8i-12cR1instance state changelayervaluewaitedOther
8i-12cR1io donemsg ptrSystem I/O
12cR1-12cR1ioctl to cell offload devicecellhash#Other
12cR1-12cR1iowp file idiowp idIdle
12cR1-12cR1iowp iocountintrtimeoutSystem I/O
12cR1-12cR1iowp msgiowp idIdle
10gR1-12cR1job scheduler coordinator slave waitOther
10gR2-12cR1jobq slave TJ process waitOther
10gR2-12cR1jobq slave shutdown waitOther
9i-12cR1jobq slave waitIdle
9i-12cR1kcbzpsOther
9i-11gR1kcrrrcpOther
10gR2-12cR1kdblil wait before retrying ORA-54Other
9i-12cR1kdic_do_mergeOther
10gR1-12cR1kfcl: instance recoverygroupobj#block#Other
10gR1-11gR2kfk: async disk IOcountintrtimeoutSystem I/O
12cR1-12cR1kfk: async disk IOcountwheretimeoutSystem I/O
9i-12cR1kgltwaitOther
10gR1-12cR1kjbdomalc allocate recovery domain - retryOther
10gR1-11gR1kjbdrmcvtq lmon drm quiesce: ping completionOther
11gR2-12cR1kjbdrmcvtq lmon drm quiesce: ping completionlocationlms idOther
10gR1-12cR1kjbopen wait for recovery domain attachOther
9i-12cR1kjctcisnd: Queue/Send client messageOther
9i-12cR1kjctssqmg: quick message send waitOther
10gR1-12cR1kjudomatt wait for recovery domain attachOther
10gR1-12cR1kjudomdet wait for recovery domain detachOther
9i-12cR1kjxgrtestOther
9i-12cR1kkdlgonOther
9i-12cR1kkdlhponOther
9i-12cR1kkdlsiponOther
9i-12cR1kksfbc child completionOther
9i-12cR1kksfbc researchOther
9i-12cR1kkshgnc reloopOther
9i-12cR1kksscl hash splitOther
9i-10gR1knlWaitForStartupOther
9i-10gR1knlqdeqOther
9i-12cR1knpc_acwm_AwaitChangedWaterMarkOther
9i-12cR1knpc_anq_AwaitNonemptyQueueOther
9i-12cR1knpsmaiOther
10gR2-12cR1kpodplck wait before retrying ORA-54Other
9i-12cR1ksbcicOther
9i-12cR1ksbsrvOther
9i-12cR1ksdxexeotherOther
9i-12cR1ksdxexeotherwaitOther
10gR1-11gR1ksfd: async disk IOcountintrtimeoutSystem I/O
10gR1-10gR1ksfd: fib/fob latchOther
10gR1-12cR1ksim generic wait eventwherewait_countOther
9i-9iksimret is busy in recoverywait_count
11gR1-12cR1kslwait unit test event 1p1p2p3Scheduler
11gR1-12cR1kslwait unit test event 2p1p2p3Other
11gR1-12cR1kslwait unit test event 3p1p2p3Other
9i-10gR2ksqdedOther
10gR2-10gR2kst: async disk IOcountintrtimeoutSystem I/O
9i-9iksu process alloc latch yield
10gR1-12cR1ksv slave avail waitOther
9i-12cR1ksxr poll remote instancesOther
10gR2-12cR1ksxr wait for mount sharedOther
10gR1-12cR1ktfbtgextsnOther
10gR1-12cR1ktm: instance recoveryundo segment#Other
9i-12cR1ktsamblOther
9i-12cR1kttm2dOther
10gR1-12cR1kupp process waitOther
9i-12cR1kxfxsekxfxse debug wait: stalling for slave 0Other
9i-12cR1kxfxspkxfxsp debug wait: stalling for slave 0Other
8i-12cR1latch activityaddressnumberprocess#Other
8i-12cR1latch freeaddressnumbertriesOther
10gR2-12cR1latch: Change Notification Hash table latchaddressnumbertriesOther
12cR1-12cR1latch: ILM access tracking extentaddressnumbertriesOther
12cR1-12cR1latch: ILM activity tracking latchaddressnumbertriesOther
10gR1-12cR1latch: In memory undo latchaddressnumbertriesConcurrency
10gR1-10gR2latch: KCL gc element parent latchaddressnumbertriesOther
10gR1-12cR1latch: MQL Tracking LatchaddressnumbertriesConcurrency
11gR2-12cR1latch: PX hash array latchaddressnumbertriesOther
12cR1-12cR1latch: SGA Logging Bkt LatchaddressnumbertriesOther
12cR1-12cR1latch: SGA Logging Log LatchaddressnumbertriesOther
10gR2-12cR1latch: Undo Hint LatchaddressnumbertriesConcurrency
11gR2-12cR1latch: WCR: processes HTaddressnumbertriesOther
11gR2-12cR1latch: WCR: syncaddressnumbertriesOther
12cR1-12cR1latch: active service listaddressnumbertriesOther
10gR1-12cR1latch: cache buffer handlesaddressnumbertriesOther
10gR1-12cR1latch: cache buffers chainsaddressnumbertriesConcurrency
10gR1-12cR1latch: cache buffers lru chainaddressnumbertriesOther
11gR2-12cR1latch: call allocationaddressnumbertriesOther
11gR1-12cR1latch: change notification client cache latchaddressnumbertriesOther
10gR1-12cR1latch: checkpoint queue latchaddressnumbertriesOther
10gR1-12cR1latch: enqueue hash chainsaddressnumbertriesOther
11gR1-12cR1latch: gc elementaddressnumbertriesOther
10gR1-12cR1latch: gcs resource hashaddressnumbertriesOther
10gR1-12cR1latch: ges resource hash listaddressnumbertriesOther
12cR1-12cR1latch: kjci process context latchaddressnumbertriesOther
12cR1-12cR1latch: kjci request sequence latchaddressnumbertriesOther
12cR1-12cR1latch: kjoeq omni enqueue hash bucket latchaddressnumbertriesOther
12cR1-12cR1latch: kjoer owner hash bucketaddressnumbertriesOther
12cR1-12cR1latch: ksm sga alloc latchaddressnumbertriesOther
12cR1-12cR1latch: ksolt allocaddressnumbertriesOther
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
11gR1-12cR1latch: lob segment hash table latchaddressnumbertriesOther
11gR1-12cR1latch: lob segment query latchaddressnumbertriesOther
10gR1-12cR1latch: messagesaddressnumbertriesOther
10gR1-10gR2latch: object queue header heapaddressnumbertriesOther
10gR1-12cR1latch: object queue header operationaddressnumbertriesOther
10gR1-12cR1latch: parallel query alloc bufferaddressnumbertriesOther
10gR1-12cR1latch: redo allocationaddressnumbertriesOther
10gR1-12cR1latch: redo copyaddressnumbertriesConfiguration
10gR1-12cR1latch: redo writingaddressnumbertriesConfiguration
10gR1-12cR1latch: row cache objectsaddressnumbertriesOther
10gR1-12cR1latch: session allocationaddressnumbertriesOther
10gR1-12cR1latch: shared pooladdressnumbertriesConfiguration
10gR1-12cR1latch: undo global dataaddressnumbertriesOther
10gR1-12cR1latch: virtual circuit queuesaddressnumbertriesOther
12cR1-12cR1libcache interrupt action by LCKlocationConcurrency
8i-8ilibrary cache load lockobject addresslock address10*mask+namespace
9i-12cR1library cache load lockobject addresslock address100*mask+namespaceConcurrency
8i-8ilibrary cache lockhandle addresslock address10*mode+namespace
9i-12cR1library cache lockhandle addresslock address100*mode+namespaceConcurrency
8i-8ilibrary cache pinhandle addresspin address10*mode+namespace
9i-12cR1library cache pinhandle addresspin address100*mode+namespaceConcurrency
10gR1-12cR1library cache revalidationOther
10gR2-12cR1library cache shutdownOther
11gR1-12cR1library cache: mutex SidnvaluewhereConcurrency
11gR1-12cR1library cache: mutex XidnvaluewhereConcurrency
12cR1-12cR1lightweight thread operationPURPOSELTHREAD TYPEOther
8i-12cR1listen endpoint statusend-point#statusOther
11gR1-12cR1listener registration dumpdumpOther
10gR2-11gR1lms flush message acksloctriesOther
11gR2-12cR1lms flush message acksidOther
8i-12cR1local write waitfile#block#User I/O
10gR1-12cR1lock closegrouplms#Other
9i-12cR1lock deadlock retryOther
9i-12cR1lock escalate retryOther
8i-8ilock manager wait for dlmd to shutdown
8i-8ilock manager wait for remote messagewaittime
10gR1-12cR1lock release pendinggroupfile#block#Other
10gR1-12cR1lock remasteringCluster
8i-12cR1log buffer spaceConfiguration
8i-12cR1log file parallel writefilesblocksrequestsSystem I/O
8i-12cR1log file sequential readlog#block#blocksSystem I/O
8i-12cR1log file single writelog#block#blocksSystem I/O
8i-12cR1log file switch (archiving needed)Configuration
8i-12cR1log file switch (checkpoint incomplete)Configuration
8i-12cR1log file switch (clearing log file)Other
10gR2-12cR1log file switch (private strand flush incomplete)Configuration
8i-12cR1log file switch completionConfiguration
8i-11gR1log file syncbuffer#Commit
11gR2-12cR1log file syncbuffer#sync scnCommit
12cR1-12cR1log file sync: SCN orderingbuffer#sync scnConcurrency
8i-12cR1log switch/archivethread#Other
10gR1-12cR1log write(even)group#Other
10gR1-12cR1log write(odd)group#Other
9i-12cR1logout restrictorConcurrency
12cR1-12cR1lreg timersuccwaitfailIdle
12cR1-12cR1master diskmon readOther
11gR1-12cR1master diskmon startupOther
10gR1-12cR1master exitalive slavesOther
8i-12cR1multiple dbwriter suspend/resume for file offlineAdministrative
9i-9iname service busy
8i-12cR1name-service call waitwaittimeOther
12cR1-12cR1netp networknetp idIdle
10gR1-12cR1no free buffersgroup#obj#block#Other
10gR1-12cR1no free locksOther
12cR1-12cR1nologging range consumption listConfiguration
12cR1-12cR1nologging standby txn commitCommit
9i-12cR1null eventOther
12cR1-12cR1opening cell offload devicecellhash#Other
9i-12cR1opishdOther
10gR2-12cR1optimizer stats update retryOther
12cR1-12cR1oracle thread bootstrappnameOther
12cR1-12cR1os thread creationpnameis_processOther
10gR2-11gR2os thread startupConcurrency
11gR1-12cR1parallel recovery change buffer freeOther
11gR1-12cR1parallel recovery control message replyOther
11gR1-12cR1parallel recovery coord send blockedOther
11gR1-12cR1parallel recovery coord wait for replyOther
12cR1-12cR1parallel recovery coord: all repliesOther
12cR1-12cR1parallel recovery coordinator idle waitIdle
9i-10gR2parallel recovery coordinator waits for cleanup of slavesIdle
11gR1-12cR1parallel recovery coordinator waits for slave cleanupIdle
11gR1-12cR1parallel recovery read buffer freeOther
11gR1-12cR1parallel recovery slave idle waitIdle
11gR1-12cR1parallel recovery slave next changeIdle
11gR1-12cR1parallel recovery slave wait for changeOther
8i-12cR1pending global transaction(s)scansOther
9i-12cR1pi renounce write completefile#block#Cluster
8i-12cR1pipe gethandle addressbuffer lengthtimeoutIdle
8i-12cR1pipe puthandle addressrecord lengthtimeoutConcurrency
12cR1-12cR1pmon cleanup on exitopOther
11gR2-12cR1pmon dblkr tst eventindexOther
8i-8ipmon rdomain attach
8i-12cR1pmon timerdurationIdle
11gR1-12cR1pool server timersleep timeIdle
12cR1-12cR1prefetch warmup block being transferredfile#block#id#Other
10gR2-11gR2prewarm transfer retryOther
10gR2-12cR1prior spawner clean upprocess_pidprocess_snoOther
11gR1-12cR1process diagnostic dumpOther
10gR1-11gR2process shutdowntypeprocess#waitedOther
12cR1-12cR1process shutdowntypeprocess#Other
8i-11gR2process startuptypeprocess#waitedOther
12cR1-12cR1process startuptypeprocess#Other
10gR2-12cR1process terminateOther
10gR1-12cR1qerex_gdmlOther
8i-10gR1queue messagesqueue idprocess#wait timeIdle
10gR1-11gR2queue slave messagesOther
9i-9iqxdid_gdml
8i-12cR1rdbms ipc messagetimeoutIdle
8i-12cR1rdbms ipc message blockOther
8i-11gR2rdbms ipc replyfrom_processtimeoutOther
12cR1-12cR1rdbms ipc replyfrom_processOther
10gR1-12cR1read by other sessionfile#block#class#User I/O
11gR1-12cR1readable standby redo apply remasteringOther
12cR1-12cR1reap block level offload operationsslowcellhash#Other
10gR1-12cR1recovery area: computing applied logsOther
10gR1-12cR1recovery area: computing backed up filesOther
10gR1-12cR1recovery area: computing dropped filesOther
10gR1-10gR2recovery area: computing identical filesOther
10gR1-12cR1recovery area: computing obsolete filesOther
11gR1-12cR1recovery buffer pinnedfile#block#Other
11gR2-12cR1recovery instance recovery completionOther
12cR1-12cR1recovery merger idle waitIdle
9i-12cR1recovery readSystem I/O
12cR1-12cR1recovery receive buffer freeOther
12cR1-12cR1recovery receiver idle waitIdle
12cR1-12cR1recovery send buffer freeOther
12cR1-12cR1recovery sender idle waitIdle
8i-10gR1refresh controlfile commandAdministrative
8i-12cR1reliable messagechannel contextchannel handlebroadcast messageOther
11gR1-12cR1remote db file readclientidcountintrNetwork
11gR1-12cR1remote db file writeclientidcountintrNetwork
11gR1-12cR1remote db operationclientidoperationtimeoutNetwork
12cR1-12cR1remote log force - buffer readfile#block#class#Cluster
12cR1-12cR1remote log force - buffer sendfile#block#class#Cluster
12cR1-12cR1remote log force - buffer updatefile#block#class#Cluster
12cR1-12cR1remote log force - commitCommit
12cR1-12cR1remote log force - log switch/recoveryforce SCNCluster
11gR1-11gR1resmgr:I/O prioritizationlocationScheduler
10gR1-12cR1resmgr:become activelocationScheduler
10gR1-11gR2resmgr:cpu quantumlocationScheduler
12cR1-12cR1resmgr:cpu quantumlocationconsumer group idScheduler
10gR1-12cR1resmgr:internal state changelocationConcurrency
10gR1-12cR1resmgr:internal state cleanuplocationOther
11gR2-12cR1resmgr:large I/O queuedlocationScheduler
12cR1-12cR1resmgr:pq queuedlocationScheduler
10gR1-12cR1resmgr: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
8i-12cR1retry 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-12cR1rollback operations activeoperation countOther
10gR1-12cR1rollback operations block fullmax operationsOther
10gR2-12cR1rolling migration: cluster quiescelocationwaitsOther
12cR1-12cR1row cache cleanupOther
8i-12cR1row cache lockcache idmoderequestConcurrency
12cR1-12cR1row cache processlocationOther
9i-11gR2row cache readcache idaddresstimesConcurrency
12cR1-12cR1row 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-12cR1second spare wait eventp1p2p3Other
8i-12cR1secondary eventevent #wait timeOther
11gR1-12cR1securefile chain updateseghdrfsbConcurrency
11gR1-12cR1securefile direct-read completionUser I/O
11gR1-12cR1securefile direct-write completionUser I/O
9i-12cR1select waitOther
10gR2-12cR1set director factor waitOther
11gR1-12cR1shared server idle waitIdle
12cR1-12cR1shutdown after switchover to standbyOther
10gR1-12cR1simulated log write delayOther
8i-12cR1single-task messageIdle
9i-10gR1slave TJ process waitOther
8i-12cR1slave exitnalivesleeptimeloopOther
9i-10gR1slave shutdown waitOther
8i-8islave waitmsg ptr
8i-12cR1smon timersleep timefailedIdle
8i-12cR1sort segment requestConfiguration
11gR1-12cR1standby query scn advanceOther
9i-12cR1statement suspendedwait error to be cleared
8i-12cR1switch logfile commandAdministrative
9i-12cR1switch undo - offlineAdministrative
12cR1-12cR1target log write sizeOther
10gR1-12cR1test long opsOther
8i-10gR1trace continuedelay timeOther
8i-10gR1trace unfreezeOther
8i-10gR1trace writer I/OOther
8i-10gR1trace writer flushOther
8i-12cR1transactionundo seg#|slot#wrap#countOther
10gR2-12cR1tsm with timeoutOther
9i-12cR1txn to completeOther
8i-12cR1unbound txOther
8i-12cR1undo segment extensionsegment#Configuration
8i-12cR1undo segment recoverysegment#tx flagsOther
8i-12cR1undo segment tx slotsegment#Configuration
10gR2-12cR1undo_retention publish retrywhereretry_countOther
8i-8iunread messagechannel contextchannel handle count
8i-8iunread messagechannel contextchannel handle
9i-9iunspecified event
10gR1-12cR1unspecified wait eventOther
11gR2-12cR1utl_file I/OUser I/O
12cR1-12cR1virtual circuit next requestcircuit#typeIdle
8i-10gR2virtual circuit statuscircuit#statusIdle
11gR1-12cR1virtual circuit waitcircuit#typeNetwork
10gR1-12cR1wait 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-12cR1wait for EMON to process ntfnsConfiguration
8i-12cR1wait for EMON to spawnOther
9i-12cR1wait 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-12cR1wait for MTTR advisory state objectOther
10gR1-10gR1wait for SGA component shrinkcomponent idcurrent sizetarget sizeOther
9i-12cR1wait for a paralle reco to abortOther
9i-12cR1wait for a undo recordOther
9i-10gR1wait for activate messageIdle
9i-12cR1wait for another txn - rollback to savepointOther
9i-12cR1wait for another txn - txn abortOther
9i-12cR1wait for another txn - undo rcv abortOther
9i-12cR1wait for assert messages to be sentOther
8i-8iwait for cached resource cleanup by LMONwaittime
10gR1-12cR1wait 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-12cR1wait 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-12cR1wait 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-12cR1wait 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
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-12cR1wait for stopper event to be increasedOther
9i-12cR1wait for sync ackcluincpending_ndOther
8i-8iwait for tickets to send DLM message
9i-11gR1wait for tmc2 to completeOther
9i-10gR1wait for transactionIdle
9i-12cR1wait for unread message on broadcast channelchannel contextchannel handleIdle
9i-12cR1wait for unread message on multiple broadcast channelschannel contextchannel handle countIdle
9i-12cR1wait for verification ackcluincpending_instsOther
9i-11gR1wait for votesOther
8i-8iwait in DLM enter server mode
8i-8iwait in DLM lock cancel
9i-12cR1wait list latch activityaddressnumberprocess#Other
9i-12cR1wait list latch freeaddressnumbertriesOther
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-12cR1watchdog main loopIdle
8i-12cR1write complete waitsfile#block#Configuration
11gR2-12cR1write complete waits: flash cachefile#block#Configuration
8i-12cR1writes stopped by instance recovery or database suspensionby thread#our thread#Other
10gR2-12cR1xdb schema cache initializationOther
カスタム検索

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