{"id":337,"date":"2012-07-30T05:38:05","date_gmt":"2012-07-30T05:38:05","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=337"},"modified":"2013-10-23T22:59:09","modified_gmt":"2013-10-23T22:59:09","slug":"oracle-10g-enqueue-waits","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=337","title":{"rendered":"Oracle 10g enqueue waits"},"content":{"rendered":"\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Enqueue Type<\/th>\nDescription<\/th>\n<\/tr>\n
enq: AD \u2013 allocate AU<\/td>\nSynchronizes accesses to a specific OSM (Oracle Software Manager) disk AU<\/td>\n<\/tr>\n
enq: AD \u2013 deallocate AU<\/td>\nSynchronizes accesses to a specific OSM disk AU<\/td>\n<\/tr>\n
enq: AF \u2013 task serialization<\/td>\nSerializes access to an advisor task<\/td>\n<\/tr>\n
enq: AG \u2013 contention<\/td>\nSynchronizes generation use of a particular workspace<\/td>\n<\/tr>\n
enq: AO \u2013 contention<\/td>\nSynchronizes access to objects and scalar variables<\/td>\n<\/tr>\n
enq: AS \u2013 contention<\/td>\nSynchronizes new service activation<\/td>\n<\/tr>\n
enq: AT \u2013 contention<\/td>\nSerializes alter tablespace operations<\/td>\n<\/tr>\n
enq: AW \u2013 AW$ table lock<\/td>\nAllows global access synchronization to the AW$ table (analytical workplace tables used in OLAP option)<\/td>\n<\/tr>\n
enq: AW \u2013 AW generation lock<\/td>\nGives in-use generation state for a particular workspace<\/td>\n<\/tr>\n
enq: AW \u2013 user access for AW<\/td>\nSynchronizes user accesses to a particular workspace<\/td>\n<\/tr>\n
enq: AW \u2013 AW state lock<\/td>\nRow lock synchronization for the AW$ table<\/td>\n<\/tr>\n
enq: BR \u2013 file shrink<\/td>\nLock held to prevent file from decreasing in physical size during RMAN backup<\/td>\n<\/tr>\n
enq: BR \u2013 proxy-copy<\/td>\nLock held to allow cleanup from backup mode during an RMAN proxy-copy backup<\/td>\n<\/tr>\n
enq: CF \u2013 contention<\/td>\nSynchronizes accesses to the controlfile<\/td>\n<\/tr>\n
enq: CI \u2013 contention<\/td>\nCoordinates cross-instance function invocations<\/td>\n<\/tr>\n
enq: CL \u2013 drop label<\/td>\nSynchronizes accesses to label cache when dropping a label<\/td>\n<\/tr>\n
enq: CL \u2013 compare labels<\/td>\nSynchronizes accesses to label cache for label comparison<\/td>\n<\/tr>\n
enq: CM \u2013 gate<\/td>\nSerializes access to instance enqueue<\/td>\n<\/tr>\n
enq: CM \u2013 instance<\/td>\nIndicates OSM disk group is mounted<\/td>\n<\/tr>\n
enq: CT \u2013 global space management<\/td>\nLock held during change tracking space management operations that affect the entire change tracking file<\/td>\n<\/tr>\n
enq: CT \u2013 state<\/td>\nLock held while enabling or disabling change tracking to ensure that it is enabled or disabled by only one user at a time<\/td>\n<\/tr>\n
enq: CT \u2013 state change gate 2<\/td>\nLock held while enabling or disabling change tracking in RAC<\/td>\n<\/tr>\n
enq: CT \u2013 reading<\/td>\nLock held to ensure that change tracking data remains in existence until a reader is done with it<\/td>\n<\/tr>\n
enq: CT \u2013 CTWR process start\/stop<\/td>\nLock held to ensure that only one CTWR (Change Tracking Writer, which tracks block changes and is initiated by the alter database enable block change tracking command) process is started in a single instance<\/td>\n<\/tr>\n
enq: CT \u2013 state change gate 1<\/td>\nLock held while enabling or disabling change tracking in RAC<\/td>\n<\/tr>\n
enq: CT \u2013 change stream ownership<\/td>\nLock held by one instance while change tracking is enabled to guarantee access to thread-specific resources<\/td>\n<\/tr>\n
enq: CT \u2013 local space management<\/td>\nLock held during change tracking space management operations that affect just the data for one thread<\/td>\n<\/tr>\n
enq: CU \u2013 contention<\/td>\nRecovers cursors in case of death while compiling<\/td>\n<\/tr>\n
enq: DB \u2013 contention<\/td>\nSynchronizes modification of database wide supplemental logging attributes<\/td>\n<\/tr>\n
enq: DD \u2013 contention<\/td>\nSynchronizes local accesses to ASM (Automatic Storage Management) disk groups<\/td>\n<\/tr>\n
enq: DF \u2013 contention<\/td>\nEnqueue held by foreground or DBWR when a datafile is brought online in RAC<\/td>\n<\/tr>\n
enq: DG \u2013 contention<\/td>\nSynchronizes accesses to ASM disk groups<\/td>\n<\/tr>\n
enq: DL \u2013 contention<\/td>\nLock to prevent index DDL during direct load<\/td>\n<\/tr>\n
enq: DM \u2013 contention<\/td>\nEnqueue held by foreground or DBWR to synchronize database mount\/open with other operations<\/td>\n<\/tr>\n
enq: DN \u2013 contention<\/td>\nSerializes group number generations<\/td>\n<\/tr>\n
enq: DP \u2013 contention<\/td>\nSynchronizes access to LDAP parameters<\/td>\n<\/tr>\n
enq: DR \u2013 contention<\/td>\nSerializes the active distributed recovery operation<\/td>\n<\/tr>\n
enq: DS \u2013 contention<\/td>\nPrevents a database suspend during LMON reconfiguration<\/td>\n<\/tr>\n
enq: DT \u2013 contention<\/td>\nSerializes changing the default temporary table space and user creation<\/td>\n<\/tr>\n
enq: DV \u2013 contention<\/td>\nSynchronizes access to lower-version Diana (PL\/SQL intermediate representation)<\/td>\n<\/tr>\n
enq: DX \u2013 contention<\/td>\nSerializes tightly coupled distributed transaction branches<\/td>\n<\/tr>\n
enq: FA \u2013 access file<\/td>\nSynchronizes accesses to open ASM files<\/td>\n<\/tr>\n
enq: FB \u2013 contention<\/td>\nEnsures that only one process can format data blocks in auto segment space managed tablespaces<\/td>\n<\/tr>\n
enq: FC \u2013 open an ACD thread<\/td>\nLGWR opens an ACD thread<\/td>\n<\/tr>\n
enq: FC \u2013 recover an ACD thread<\/td>\nSMON recovers an ACD thread<\/td>\n<\/tr>\n
enq: FD \u2013 Marker generation<\/td>\nSynchronization<\/td>\n<\/tr>\n
enq: FD \u2013 Flashback coordinator<\/td>\nSynchronization<\/td>\n<\/tr>\n
enq: FD \u2013 Tablespace flashback on\/off<\/td>\nSynchronization<\/td>\n<\/tr>\n
enq: FD \u2013 Flashback on\/off<\/td>\nSynchronization<\/td>\n<\/tr>\n
enq: FG \u2013 serialize ACD relocate<\/td>\nOnly 1 process in the cluster may do ACD relocation in a disk group<\/td>\n<\/tr>\n
enq: FG \u2013 LGWR redo generation enq race<\/td>\nResolves race condition to acquire Disk Group Redo Generation Enqueue<\/td>\n<\/tr>\n
enq: FG \u2013 FG redo generation enq race<\/td>\nResolves race condition to acquire Disk Group Redo Generation Enqueue<\/td>\n<\/tr>\n
enq: FL \u2013 Flashback database log<\/td>\nSynchronizes access to Flashback database log<\/td>\n<\/tr>\n
enq: FL \u2013 Flashback db command<\/td>\nSynchronizes Flashback Database and deletion of flashback logs<\/td>\n<\/tr>\n
enq: FM \u2013 contention<\/td>\nSynchronizes access to global file mapping state<\/td>\n<\/tr>\n
enq: FR \u2013 contention<\/td>\nBegins recovery of disk group<\/td>\n<\/tr>\n
enq: FS \u2013 contention<\/td>\nSynchronizes recovery and file operations or synchronizes dictionary check<\/td>\n<\/tr>\n
enq: FT \u2013 allow LGWR writes<\/td>\nAllows LGWR to generate redo in this thread<\/td>\n<\/tr>\n
enq: FT \u2013 disable LGWR writes<\/td>\nPrevents LGWR from generating redo in this thread<\/td>\n<\/tr>\n
enq: FU \u2013 contention<\/td>\nSerializes the capture of the DB feature, usage, and high watermark statistics<\/td>\n<\/tr>\n
enq: HD \u2013 contention<\/td>\nSerializes accesses to ASM SGA data structures<\/td>\n<\/tr>\n
enq: HP \u2013 contention<\/td>\nSynchronizes accesses to queue pages<\/td>\n<\/tr>\n
enq: HQ \u2013 contention<\/td>\nSynchronizes the creation of new queue IDs<\/td>\n<\/tr>\n
enq: HV \u2013 contention<\/td>\nLock used to broker the high watermark during parallel inserts<\/td>\n<\/tr>\n
enq: HW \u2013 contention<\/td>\nLock used to broker the high watermark during parallel inserts<\/td>\n<\/tr>\n
enq: IA \u2013 contention<\/td>\nInformation not available<\/td>\n<\/tr>\n
enq: ID \u2013 contention<\/td>\nLock held to prevent other processes from performing controlfile transaction while NID is running<\/td>\n<\/tr>\n
enq: IL \u2013 contention<\/td>\nSynchronizes accesses to internal label data structures<\/td>\n<\/tr>\n
enq: IM \u2013 contention for blr<\/td>\nSerializes block recovery for IMU txn<\/td>\n<\/tr>\n
enq: IR \u2013 contention<\/td>\nSynchronizes instance recovery<\/td>\n<\/tr>\n
enq: IR \u2013 contention2<\/td>\nSynchronizes parallel instance recovery and shutdown immediate<\/td>\n<\/tr>\n
enq: IS \u2013 contention<\/td>\nSynchronizes instance state changes<\/td>\n<\/tr>\n
enq: IT \u2013 contention<\/td>\nSynchronizes accesses to a temp object\u2019s metadata<\/td>\n<\/tr>\n
enq: JD \u2013 contention<\/td>\nSynchronizes dates between job queue coordinator and slave processes<\/td>\n<\/tr>\n
enq: JI \u2013 contention<\/td>\nLock held during materialized view operations (such as refresh, alter) to prevent concurrent operations on the same materialized view<\/td>\n<\/tr>\n
enq: JQ \u2013 contention<\/td>\nLock to prevent multiple instances from running a single job<\/td>\n<\/tr>\n
enq: JS \u2013 contention<\/td>\nSynchronizes accesses to the job cache<\/td>\n<\/tr>\n
enq: JS \u2013 coord post lock<\/td>\nLock for coordinator posting<\/td>\n<\/tr>\n
enq: JS \u2013 global wdw lock<\/td>\nLock acquired when doing wdw ddl<\/td>\n<\/tr>\n
enq: JS \u2013 job chain evaluate lock<\/td>\nLock when job chain evaluated for steps to create<\/td>\n<\/tr>\n
enq: JS \u2013 q mem clnup lck<\/td>\nLock obtained when cleaning up q memory<\/td>\n<\/tr>\n
enq: JS \u2013 slave enq get lock2<\/td>\nGets run info locks before slv objget<\/td>\n<\/tr>\n
enq: JS \u2013 slave enq get lock1<\/td>\nSlave locks exec pre to sess strt<\/td>\n<\/tr>\n
enq: JS \u2013 running job cnt lock3<\/td>\nLock to set running job count epost<\/td>\n<\/tr>\n
enq: JS \u2013 running job cnt lock2<\/td>\nLock to set running job count epre<\/td>\n<\/tr>\n
enq: JS \u2013 running job cnt lock<\/td>\nLock to get running job count<\/td>\n<\/tr>\n
enq: JS \u2013 coord rcv lock<\/td>\nLock when coord receives msg<\/td>\n<\/tr>\n
enq: JS \u2013 queue lock<\/td>\nLock on internal scheduler queue<\/td>\n<\/tr>\n
enq: JS \u2013 job run lock \u2013 synchronize<\/td>\nLock to prevent job from running elsewhere<\/td>\n<\/tr>\n
enq: JS \u2013 job recov lock<\/td>\nLock to recover jobs running on crashed RAC inst<\/td>\n<\/tr>\n
enq: KK \u2013 context<\/td>\nLock held by open redo thread, used by other instances to force a log switch<\/td>\n<\/tr>\n
enq: KM \u2013 contention<\/td>\nSynchronizes various Resource Manager operations<\/td>\n<\/tr>\n
enq: KP \u2013 contention<\/td>\nSynchronizes kupp process startup<\/td>\n<\/tr>\n
enq: KT \u2013 contention<\/td>\nSynchronizes accesses to the current Resource Manager plan<\/td>\n<\/tr>\n
enq: MD \u2013 contention<\/td>\nLock held during materialized view log DDL statements<\/td>\n<\/tr>\n
enq: MH \u2013 contention<\/td>\nLock used for recovery when setting Mail Host for AQ e-mail notifications<\/td>\n<\/tr>\n
enq: ML \u2013 contention<\/td>\nLock used for recovery when setting Mail Port for AQ e-mail notifications<\/td>\n<\/tr>\n
enq: MN \u2013 contention<\/td>\nSynchronizes updates to the LogMiner dictionary and prevents multiple instances from preparing the same LogMiner session<\/td>\n<\/tr>\n
enq: MR \u2013 contention<\/td>\nLock used to coordinate media recovery with other uses of datafiles<\/td>\n<\/tr>\n
enq: MS \u2013 contention<\/td>\nLock held during materialized view refresh to set up MV log<\/td>\n<\/tr>\n
enq: MW \u2013 contention<\/td>\nSerializes the calibration of the manageability schedules with the Maintenance Window<\/td>\n<\/tr>\n
enq: OC \u2013 contention<\/td>\nSynchronizes write accesses to the outline cache<\/td>\n<\/tr>\n
enq: OL \u2013 contention<\/td>\nSynchronizes accesses to a particular outline name<\/td>\n<\/tr>\n
enq: OQ \u2013 xsoqhiAlloc<\/td>\nSynchronizes access to olapi history allocation<\/td>\n<\/tr>\n
enq: OQ \u2013 xsoqhiClose<\/td>\nSynchronizes access to olapi history closing<\/td>\n<\/tr>\n
enq: OQ \u2013 xsoqhistrecb<\/td>\nSynchronizes access to olapi history globals<\/td>\n<\/tr>\n
enq: OQ \u2013 xsoqhiFlush<\/td>\nSynchronizes access to olapi history flushing<\/td>\n<\/tr>\n
enq: OQ \u2013 xsoq*histrecb<\/td>\nSynchronizes access to olapi history parameter CB<\/td>\n<\/tr>\n
enq: PD \u2013 contention<\/td>\nPrevents others from updating the same property<\/td>\n<\/tr>\n
enq: PE \u2013 contention<\/td>\nSynchronizes system parameter updates<\/td>\n<\/tr>\n
enq: PF \u2013 contention<\/td>\nSynchronizes accesses to the password file<\/td>\n<\/tr>\n
enq: PG \u2013 contention<\/td>\nSynchronizes global system parameter updates<\/td>\n<\/tr>\n
enq: PH \u2013 contention<\/td>\nLock used for recovery when setting proxy for AQ HTTP notifications<\/td>\n<\/tr>\n
enq: PI \u2013 contention<\/td>\nCommunicates remote Parallel Execution Server Process creation status<\/td>\n<\/tr>\n
enq: PL \u2013 contention<\/td>\nCoordinates plug-in operation of transportable tablespaces<\/td>\n<\/tr>\n
enq: PR \u2013 contention<\/td>\nSynchronizes process startup<\/td>\n<\/tr>\n
enq: PS \u2013 contention<\/td>\nParallel Execution Server Process reservation and synchronization<\/td>\n<\/tr>\n
enq: PT \u2013 contention<\/td>\nSynchronizes access to ASM PST metadata<\/td>\n<\/tr>\n
enq: PV \u2013 syncstart<\/td>\nSynchronizes slave start_shutdown<\/td>\n<\/tr>\n
enq: PV \u2013 syncshut<\/td>\nSynchronizes instance shutdown_slvstart<\/td>\n<\/tr>\n
enq: PW \u2013 prewarm status in dbw0<\/td>\nDBWR0 holds this enqueue indicating pre-warmed buffers present in cache<\/td>\n<\/tr>\n
enq: PW \u2013 flush prewarm buffers<\/td>\nDirect Load needs to flush prewarmed buffers if DBWR0 holds this enqueue<\/td>\n<\/tr>\n
enq: RB \u2013 contention<\/td>\nSerializes OSM rollback recovery operations<\/td>\n<\/tr>\n
enq: RF \u2013 synch: per-SGA Broker metadata<\/td>\nEnsures r\/w atomicity of DG configuration metadata per unique SGA<\/td>\n<\/tr>\n
enq: RF \u2013 synchronization: critical ai<\/td>\nSynchronizes critical apply instance among primary instances<\/td>\n<\/tr>\n
enq: RF \u2013 new AI<\/td>\nSynchronizes selection of the new apply instance<\/td>\n<\/tr>\n
enq: RF \u2013 synchronization: chief<\/td>\nAnoints 1 instance\u2019s DMON (Data Guard Broker Monitor) as chief to other instance\u2019s DMONs<\/td>\n<\/tr>\n
enq: RF \u2013 synchronization: HC master<\/td>\nAnoints 1 instance\u2019s DMON as health check master<\/td>\n<\/tr>\n
enq: RF \u2013 synchronization: aifo master<\/td>\nSynchronizes critical apply instance failure detection and failover operation<\/td>\n<\/tr>\n
enq: RF \u2013 atomicity<\/td>\nEnsures atomicity of log transport setup<\/td>\n<\/tr>\n
enq: RN \u2013 contention<\/td>\nCoordinates nab computations of online logs during recovery<\/td>\n<\/tr>\n
enq: RO \u2013 contention<\/td>\nCoordinates flushing of multiple objects<\/td>\n<\/tr>\n
enq: RO \u2013 fast object reuse<\/td>\nCoordinates fast object reuse<\/td>\n<\/tr>\n
enq: RP \u2013 contention<\/td>\nEnqueue held when resilvering is needed or when data block is repaired from mirror<\/td>\n<\/tr>\n
enq: RS \u2013 file delete<\/td>\nLock held to prevent file from accessing during space reclamation<\/td>\n<\/tr>\n
enq: RS \u2013 persist alert level<\/td>\nLock held to make alert level persistent<\/td>\n<\/tr>\n
enq: RS \u2013 write alert level<\/td>\nLock held to write alert level<\/td>\n<\/tr>\n
enq: RS \u2013 read alert level<\/td>\nLock held to read alert level<\/td>\n<\/tr>\n
enq: RS \u2013 prevent aging list update<\/td>\nLock held to prevent aging list update<\/td>\n<\/tr>\n
enq: RS \u2013 record reuse<\/td>\nLock held to prevent file from accessing while reusing circular record<\/td>\n<\/tr>\n
enq: RS \u2013 prevent file delete<\/td>\nLock held to prevent deleting file to reclaim space<\/td>\n<\/tr>\n
enq: RT \u2013 contention<\/td>\nThread locks held by LGWR, DBW0, and RVWR (Recovery Writer, used in Flashback Database operations) to indicate mounted or open status<\/td>\n<\/tr>\n
enq: SB \u2013 contention<\/td>\nSynchronizes logical standby metadata operations<\/td>\n<\/tr>\n
enq: SF \u2013 contention<\/td>\nLock held for recovery when setting sender for AQ e-mail notifications<\/td>\n<\/tr>\n
enq: SH \u2013 contention<\/td>\nEnqueue always acquired in no-wait mode \u2013 should seldom see this contention<\/td>\n<\/tr>\n
enq: SI \u2013 contention<\/td>\nPrevents multiple streams table instantiations<\/td>\n<\/tr>\n
enq: SK \u2013 contention<\/td>\nSerialize shrink of a segment<\/td>\n<\/tr>\n
enq: SQ \u2013 contention<\/td>\nLock to ensure that only one process can replenish the sequence cache<\/td>\n<\/tr>\n
enq: SR \u2013 contention<\/td>\nCoordinates replication \/ streams operations<\/td>\n<\/tr>\n
enq: SS \u2013 contention<\/td>\nEnsures that sort segments created during parallel DML operations aren\u2019t prematurely cleaned up<\/td>\n<\/tr>\n
enq: ST \u2013 contention<\/td>\nSynchronizes space management activities in dictionary-managed tablespaces<\/td>\n<\/tr>\n
enq: SU \u2013 contention<\/td>\nSerializes access to SaveUndo Segment<\/td>\n<\/tr>\n
enq: SW \u2013 contention<\/td>\nCoordinates the \u2018alter system suspend\u2019 operation<\/td>\n<\/tr>\n
enq: TA \u2013 contention<\/td>\nSerializes operations on undo segments and undo tablespaces<\/td>\n<\/tr>\n
enq: TB \u2013 SQL Tuning Base Cache Update<\/td>\nSynchronizes writes to the SQL Tuning Base Existence Cache<\/td>\n<\/tr>\n
enq: TB \u2013 SQL Tuning Base Cache Load<\/td>\nSynchronizes writes to the SQL Tuning Base Existence Cache<\/td>\n<\/tr>\n
enq: TC \u2013 contention<\/td>\nLock held to guarantee uniqueness of a tablespace checkpoint<\/td>\n<\/tr>\n
enq: TC \u2013 contention2<\/td>\nLock during setup of a unique tablespace checkpoint in null mode<\/td>\n<\/tr>\n
enq: TD \u2013 KTF dump entries<\/td>\nKTF dumping time\/scn mappings in SMON_SCN_TIME table<\/td>\n<\/tr>\n
enq: TE \u2013 KTF broadcast<\/td>\nKTF broadcasting<\/td>\n<\/tr>\n
enq: TF \u2013 contention<\/td>\nSerializes dropping of a temporary file<\/td>\n<\/tr>\n
enq: TL \u2013 contention<\/td>\nSerializes threshold log table read and update<\/td>\n<\/tr>\n
enq: TM \u2013 contention<\/td>\nSynchronizes accesses to an object<\/td>\n<\/tr>\n
enq: TO \u2013 contention<\/td>\nSynchronizes DDL and DML operations on a temp object<\/td>\n<\/tr>\n
enq: TQ \u2013 TM contention<\/td>\nTM access to the queue table<\/td>\n<\/tr>\n
enq: TQ \u2013 DDL contention<\/td>\nDDL access to the queue table<\/td>\n<\/tr>\n
enq: TQ \u2013 INI contention<\/td>\nTM access to the queue table<\/td>\n<\/tr>\n
enq: TS \u2013 contention<\/td>\nSerializes accesses to temp segments<\/td>\n<\/tr>\n
enq: TT \u2013 contention<\/td>\nSerializes DDL operations on tablespaces<\/td>\n<\/tr>\n
enq: TW \u2013 contention<\/td>\nLock held by one instance to wait for transactions on all instances to finish<\/td>\n<\/tr>\n
enq: TX \u2013 contention<\/td>\nLock held by a transaction to allow other transactions to wait for it<\/td>\n<\/tr>\n
enq: TX \u2013 row lock contention<\/td>\nLock held on a particular row by a transaction to prevent other transactions from modifying it<\/td>\n<\/tr>\n
enq: TX \u2013 allocate ITL entry<\/td>\nAllocating an ITL entry in order to begin a transaction<\/td>\n<\/tr>\n
enq: TX \u2013 index contention<\/td>\nLock held on an index during a split to prevent other operations on it<\/td>\n<\/tr>\n
enq: UL \u2013 contention<\/td>\nLock held used by user applications<\/td>\n<\/tr>\n
enq: US \u2013 contention<\/td>\nLock held to perform DDL on the undo segment<\/td>\n<\/tr>\n
enq: WA \u2013 contention<\/td>\nLock used for recovery when setting watermark for memory usage in AQ notifications<\/td>\n<\/tr>\n
enq: WF \u2013 contention<\/td>\nEnqueue used to serialize the flushing of snapshots<\/td>\n<\/tr>\n
enq: WL \u2013 contention<\/td>\nCoordinates access to redo log files and archive logs<\/td>\n<\/tr>\n
enq: WP \u2013 contention<\/td>\nEnqueue to handle concurrency between purging and baselines<\/td>\n<\/tr>\n
enq: XH \u2013 contention<\/td>\nLock used for recovery when setting No Proxy Domains for AQ HTTP notifications<\/td>\n<\/tr>\n
enq: XR \u2013 quiesce database<\/td>\nLock held during database quiesce<\/td>\n<\/tr>\n
enq: XR \u2013 database force logging<\/td>\nLock held during database force logging mode<\/td>\n<\/tr>\n
enq: XY \u2013 contention<\/td>\nLock used by Oracle Corporation for internal testing<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Events parameters<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
NAME<\/td>\nPARAMETER1<\/td>\nPARAMETER2<\/td>\nPARAMETER3<\/td>\n<\/tr>\n
enq: AD \u2013 allocate AU<\/td>\nname|mode<\/td>\ngroup and disk number<\/td>\nAU number<\/td>\n<\/tr>\n
enq: AD \u2013 deallocate AU<\/td>\nname|mode<\/td>\ngroup and disk number<\/td>\nAU number<\/td>\n<\/tr>\n
enq: AF \u2013 task serialization<\/td>\nname|mode<\/td>\ntask id<\/td>\n0<\/td>\n<\/tr>\n
enq: AG \u2013 contention<\/td>\nname|mode<\/td>\nworkspace #<\/td>\ngeneration<\/td>\n<\/tr>\n
enq: AM \u2013 client registration<\/td>\nname|mode<\/td>\nid1<\/td>\nid2<\/td>\n<\/tr>\n
enq: AM \u2013 rollback COD reservation<\/td>\nname|mode<\/td>\nid1<\/td>\nid2<\/td>\n<\/tr>\n
enq: AM \u2013 shutdown<\/td>\nname|mode<\/td>\nid1<\/td>\nid2<\/td>\n<\/tr>\n
enq: AO \u2013 contention<\/td>\nname|mode<\/td>\nworkspace #<\/td>\nobject #<\/td>\n<\/tr>\n
enq: AS \u2013 modify service<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: AS \u2013 service activation<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: AT \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: AU \u2013 audit index file<\/td>\nname|mode<\/td>\nXML audit index file<\/td>\n0<\/td>\n<\/tr>\n
enq: AW \u2013 AW generation lock<\/td>\nname|mode<\/td>\noperation<\/td>\nworkspace #<\/td>\n<\/tr>\n
enq: AW \u2013 AW state lock<\/td>\nname|mode<\/td>\noperation<\/td>\nworkspace #<\/td>\n<\/tr>\n
enq: AW \u2013 AW$ table lock<\/td>\nname|mode<\/td>\noperation<\/td>\nworkspace #<\/td>\n<\/tr>\n
enq: AW \u2013 user access for AW<\/td>\nname|mode<\/td>\noperation<\/td>\nworkspace #<\/td>\n<\/tr>\n
enq: BF \u2013 PMON Join Filter cleanup<\/td>\nname|mode<\/td>\nnode#\/parallelizer#<\/td>\nbloom#<\/td>\n<\/tr>\n
enq: BF \u2013 allocation contention<\/td>\nname|mode<\/td>\nnode#\/parallelizer#<\/td>\nbloom#<\/td>\n<\/tr>\n
enq: BR \u2013 file shrink<\/td>\nname|mode<\/td>\noperation<\/td>\nfile #<\/td>\n<\/tr>\n
enq: BR \u2013 proxy-copy<\/td>\nname|mode<\/td>\noperation<\/td>\nfile #<\/td>\n<\/tr>\n
enq: CF \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\noperation<\/td>\n<\/tr>\n
enq: CI \u2013 contention<\/td>\nname|mode<\/td>\nopcode<\/td>\ntype<\/td>\n<\/tr>\n
enq: CL \u2013 compare labels<\/td>\nname|mode<\/td>\nobject #<\/td>\n0<\/td>\n<\/tr>\n
enq: CL \u2013 drop label<\/td>\nname|mode<\/td>\nobject #<\/td>\n0<\/td>\n<\/tr>\n
enq: CM \u2013 gate<\/td>\nname|mode<\/td>\ndisk group #<\/td>\ntype<\/td>\n<\/tr>\n
enq: CM \u2013 instance<\/td>\nname|mode<\/td>\ndisk group #<\/td>\ntype<\/td>\n<\/tr>\n
enq: CN \u2013 race with init<\/td>\nname|mode<\/td>\nreg id<\/td>\n0<\/td>\n<\/tr>\n
enq: CN \u2013 race with reg<\/td>\nname|mode<\/td>\nreg id<\/td>\n0<\/td>\n<\/tr>\n
enq: CN \u2013 race with txn<\/td>\nname|mode<\/td>\nreg id<\/td>\n0<\/td>\n<\/tr>\n
enq: CT \u2013 CTWR process start\/stop<\/td>\nname|mode<\/td>\noperation<\/td>\noperation parm<\/td>\n<\/tr>\n
enq: CT \u2013 change stream ownership<\/td>\nname|mode<\/td>\noperation<\/td>\noperation parm<\/td>\n<\/tr>\n
enq: CT \u2013 global space management<\/td>\nname|mode<\/td>\noperation<\/td>\noperation parm<\/td>\n<\/tr>\n
enq: CT \u2013 local space management<\/td>\nname|mode<\/td>\noperation<\/td>\noperation parm<\/td>\n<\/tr>\n
enq: CT \u2013 reading<\/td>\nname|mode<\/td>\noperation<\/td>\noperation parm<\/td>\n<\/tr>\n
enq: CT \u2013 state<\/td>\nname|mode<\/td>\noperation<\/td>\noperation parm<\/td>\n<\/tr>\n
enq: CT \u2013 state change gate 1<\/td>\nname|mode<\/td>\noperation<\/td>\noperation parm<\/td>\n<\/tr>\n
enq: CT \u2013 state change gate 2<\/td>\nname|mode<\/td>\noperation<\/td>\noperation parm<\/td>\n<\/tr>\n
enq: CU \u2013 contention<\/td>\nname|mode<\/td>\nhandle<\/td>\nhandle<\/td>\n<\/tr>\n
enq: DB \u2013 contention<\/td>\nname|mode<\/td>\nEnqMode<\/td>\n0<\/td>\n<\/tr>\n
enq: DD \u2013 contention<\/td>\nname|mode<\/td>\ndisk group<\/td>\ntype<\/td>\n<\/tr>\n
enq: DF \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\nfile #<\/td>\n<\/tr>\n
enq: DG \u2013 contention<\/td>\nname|mode<\/td>\ndisk group<\/td>\ntype<\/td>\n<\/tr>\n
enq: DL \u2013 contention<\/td>\nname|mode<\/td>\nobject #<\/td>\n0<\/td>\n<\/tr>\n
enq: DM \u2013 contention<\/td>\nname|mode<\/td>\ntype<\/td>\ntype<\/td>\n<\/tr>\n
enq: DN \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: DP \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: DR \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: DS \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: DT \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: DV \u2013 contention<\/td>\nname|mode<\/td>\nobject #<\/td>\n0<\/td>\n<\/tr>\n
enq: DX \u2013 contention<\/td>\nname|mode<\/td>\ntransaction entry #<\/td>\n0<\/td>\n<\/tr>\n
enq: FA \u2013 access file<\/td>\nname|mode<\/td>\ndisk group number<\/td>\nfile number<\/td>\n<\/tr>\n
enq: FB \u2013 contention<\/td>\nname|mode<\/td>\ntablespace #<\/td>\ndba<\/td>\n<\/tr>\n
enq: FC \u2013 open an ACD thread<\/td>\nname|mode<\/td>\ndisk group<\/td>\nthread<\/td>\n<\/tr>\n
enq: FC \u2013 recover an ACD thread<\/td>\nname|mode<\/td>\ndisk group<\/td>\nthread<\/td>\n<\/tr>\n
enq: FD \u2013 Flashback coordinator<\/td>\nname|mode<\/td>\nInternal<\/td>\nInternal<\/td>\n<\/tr>\n
enq: FD \u2013 Flashback on\/off<\/td>\nname|mode<\/td>\nInternal<\/td>\nInternal<\/td>\n<\/tr>\n
enq: FD \u2013 Marker generation<\/td>\nname|mode<\/td>\nInternal<\/td>\nInternal<\/td>\n<\/tr>\n
enq: FD \u2013 Restore point create\/drop<\/td>\nname|mode<\/td>\nInternal<\/td>\nInternal<\/td>\n<\/tr>\n
enq: FD \u2013 Tablespace flashback on\/off<\/td>\nname|mode<\/td>\nInternal<\/td>\nInternal<\/td>\n<\/tr>\n
enq: FG \u2013 FG redo generation enq race<\/td>\nname|mode<\/td>\ndisk group<\/td>\ntype<\/td>\n<\/tr>\n
enq: FG \u2013 LGWR redo generation enq race<\/td>\nname|mode<\/td>\ndisk group<\/td>\ntype<\/td>\n<\/tr>\n
enq: FG \u2013 serialize ACD relocate<\/td>\nname|mode<\/td>\ndisk group<\/td>\ntype<\/td>\n<\/tr>\n
enq: FL \u2013 Flashback database log<\/td>\nname|mode<\/td>\nLog #<\/td>\nzero<\/td>\n<\/tr>\n
enq: FL \u2013 Flashback db command<\/td>\nname|mode<\/td>\nLog #<\/td>\nzero<\/td>\n<\/tr>\n
enq: FM \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: FP \u2013 global fob contention<\/td>\nname|mode<\/td>\nlow file obj add<\/td>\nhigh file obj add<\/td>\n<\/tr>\n
enq: FR \u2013 contention<\/td>\nname|mode<\/td>\ndisk group<\/td>\nunused<\/td>\n<\/tr>\n
enq: FS \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\ntype<\/td>\n<\/tr>\n
enq: FT \u2013 allow LGWR writes<\/td>\nname|mode<\/td>\ndisk group<\/td>\nthread<\/td>\n<\/tr>\n
enq: FT \u2013 disable LGWR writes<\/td>\nname|mode<\/td>\ndisk group<\/td>\nthread<\/td>\n<\/tr>\n
enq: FU \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: HD \u2013 contention<\/td>\nname|mode<\/td>\ndisk group<\/td>\n0<\/td>\n<\/tr>\n
enq: HP \u2013 contention<\/td>\nname|mode<\/td>\ntablespace #<\/td>\ndba<\/td>\n<\/tr>\n
enq: HQ \u2013 contention<\/td>\nname|mode<\/td>\nobject #<\/td>\nhash value<\/td>\n<\/tr>\n
enq: HV \u2013 contention<\/td>\nname|mode<\/td>\nobject #<\/td>\n0<\/td>\n<\/tr>\n
enq: HW \u2013 contention<\/td>\nname|mode<\/td>\ntable space #<\/td>\nblock<\/td>\n<\/tr>\n
enq: IA \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: ID \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: IL \u2013 contention<\/td>\nname|mode<\/td>\nobject #<\/td>\n0<\/td>\n<\/tr>\n
enq: IM \u2013 contention for blr<\/td>\nname|mode<\/td>\npool #<\/td>\n0<\/td>\n<\/tr>\n
enq: IR \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0\/1<\/td>\n<\/tr>\n
enq: IR \u2013 contention2<\/td>\nname|mode<\/td>\n0<\/td>\n0\/1<\/td>\n<\/tr>\n
enq: IS \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\ntype<\/td>\n<\/tr>\n
enq: IT \u2013 contention<\/td>\nname|mode<\/td>\nobject #<\/td>\n0<\/td>\n<\/tr>\n
enq: JD \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: JI \u2013 contention<\/td>\nname|mode<\/td>\nview object #<\/td>\n0<\/td>\n<\/tr>\n
enq: JQ \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: JS \u2013 contention<\/td>\nname|mode<\/td>\nservice ID<\/td>\nqueue type<\/td>\n<\/tr>\n
enq: JS \u2013 evt notify<\/td>\nname|mode<\/td>\nservice ID<\/td>\nqueue type<\/td>\n<\/tr>\n
enq: JS \u2013 evtsub add<\/td>\nname|mode<\/td>\nservice ID<\/td>\nqueue type<\/td>\n<\/tr>\n
enq: JS \u2013 evtsub drop<\/td>\nname|mode<\/td>\nservice ID<\/td>\nqueue type<\/td>\n<\/tr>\n
enq: JS \u2013 job recov lock<\/td>\nname|mode<\/td>\nservice ID<\/td>\nqueue type<\/td>\n<\/tr>\n
enq: JS \u2013 job run lock \u2013 synchronize<\/td>\nname|mode<\/td>\nservice ID<\/td>\nqueue type<\/td>\n<\/tr>\n
enq: JS \u2013 q mem clnup lck<\/td>\nname|mode<\/td>\nservice ID<\/td>\nqueue type<\/td>\n<\/tr>\n
enq: JS \u2013 queue lock<\/td>\nname|mode<\/td>\nservice ID<\/td>\nqueue type<\/td>\n<\/tr>\n
enq: JS \u2013 sch locl enqs<\/td>\nname|mode<\/td>\nservice ID<\/td>\nqueue type<\/td>\n<\/tr>\n
enq: JS \u2013 wdw op<\/td>\nname|mode<\/td>\nservice ID<\/td>\nqueue type<\/td>\n<\/tr>\n
enq: KK \u2013 context<\/td>\nname|mode<\/td>\n0<\/td>\nredo thread<\/td>\n<\/tr>\n
enq: KM \u2013 contention<\/td>\nname|mode<\/td>\ntype<\/td>\ntype<\/td>\n<\/tr>\n
enq: KO \u2013 fast object checkpoint<\/td>\nname|mode<\/td>\n2<\/td>\n0<\/td>\n<\/tr>\n
enq: KP \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: KT \u2013 contention<\/td>\nname|mode<\/td>\nplan #<\/td>\n0<\/td>\n<\/tr>\n
enq: MD \u2013 contention<\/td>\nname|mode<\/td>\nmaster object #<\/td>\n0<\/td>\n<\/tr>\n
enq: MH \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: MK \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: ML \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: MN \u2013 contention<\/td>\nname|mode<\/td>\nsession ID<\/td>\n0<\/td>\n<\/tr>\n
enq: MO \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: MR \u2013 contention<\/td>\nname|mode<\/td>\n0 or file #<\/td>\ntype<\/td>\n<\/tr>\n
enq: MS \u2013 contention<\/td>\nname|mode<\/td>\nmaster object #<\/td>\n0<\/td>\n<\/tr>\n
enq: MW \u2013 contention<\/td>\nname|mode<\/td>\nSchedule Id<\/td>\n0<\/td>\n<\/tr>\n
enq: OC \u2013 contention<\/td>\nname|mode<\/td>\n1<\/td>\n2<\/td>\n<\/tr>\n
enq: OL \u2013 contention<\/td>\nname|mode<\/td>\nhash value<\/td>\n0<\/td>\n<\/tr>\n
enq: OQ \u2013 xsoq*histrecb<\/td>\nname|mode<\/td>\nresource id<\/td>\n0<\/td>\n<\/tr>\n
enq: OQ \u2013 xsoqhiAlloc<\/td>\nname|mode<\/td>\nresource id<\/td>\n0<\/td>\n<\/tr>\n
enq: OQ \u2013 xsoqhiClose<\/td>\nname|mode<\/td>\nresource id<\/td>\n0<\/td>\n<\/tr>\n
enq: OQ \u2013 xsoqhiFlush<\/td>\nname|mode<\/td>\nresource id<\/td>\n0<\/td>\n<\/tr>\n
enq: OQ \u2013 xsoqhistrecb<\/td>\nname|mode<\/td>\nresource id<\/td>\n0<\/td>\n<\/tr>\n
enq: OW \u2013 initialization<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: OW \u2013 termination<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: PD \u2013 contention<\/td>\nname|mode<\/td>\nproperty name<\/td>\nkey hash<\/td>\n<\/tr>\n
enq: PE \u2013 contention<\/td>\nname|mode<\/td>\nparno<\/td>\n0<\/td>\n<\/tr>\n
enq: PF \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: PG \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: PH \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: PI \u2013 contention<\/td>\nname|mode<\/td>\noperation<\/td>\nserial #<\/td>\n<\/tr>\n
enq: PL \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: PR \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: PS \u2013 contention<\/td>\nname|mode<\/td>\ninstance<\/td>\nslave ID<\/td>\n<\/tr>\n
enq: PT \u2013 contention<\/td>\nname|mode<\/td>\ndisk group #<\/td>\ntype<\/td>\n<\/tr>\n
enq: PV \u2013 syncshut<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: PV \u2013 syncstart<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: PW \u2013 flush prewarm buffers<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: PW \u2013 perwarm status in dbw0<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: RB \u2013 contention<\/td>\nname|mode<\/td>\ndisk group<\/td>\n0<\/td>\n<\/tr>\n
enq: RF \u2013 RF \u2013 Database Automatic Disable<\/td>\nname|mode<\/td>\nlock operation<\/td>\nlock value<\/td>\n<\/tr>\n
enq: RF \u2013 RF \u2013 FSFO Observed<\/td>\nname|mode<\/td>\nlock operation<\/td>\nlock value<\/td>\n<\/tr>\n
enq: RF \u2013 RF \u2013 FSFO connectivity<\/td>\nname|mode<\/td>\nlock operation<\/td>\nlock value<\/td>\n<\/tr>\n
enq: RF \u2013 RF \u2013 FSFO state<\/td>\nname|mode<\/td>\nlock operation<\/td>\nlock value<\/td>\n<\/tr>\n
enq: RF \u2013 RF \u2013 FSFO synchronization<\/td>\nname|mode<\/td>\nlock operation<\/td>\nlock value<\/td>\n<\/tr>\n
enq: RF \u2013 RF \u2013 FSFO wait<\/td>\nname|mode<\/td>\nlock operation<\/td>\nlock value<\/td>\n<\/tr>\n
enq: RF \u2013 atomicity<\/td>\nname|mode<\/td>\nlock operation<\/td>\nlock value<\/td>\n<\/tr>\n
enq: RF \u2013 new AI<\/td>\nname|mode<\/td>\nlock operation<\/td>\nlock value<\/td>\n<\/tr>\n
enq: RF \u2013 synch: DG Broker metadata<\/td>\nname|mode<\/td>\nlock operation<\/td>\nlock value<\/td>\n<\/tr>\n
enq: RF \u2013 synchronization: HC master<\/td>\nname|mode<\/td>\nlock operation<\/td>\nlock value<\/td>\n<\/tr>\n
enq: RF \u2013 synchronization: aifo master<\/td>\nname|mode<\/td>\nlock operation<\/td>\nlock value<\/td>\n<\/tr>\n
enq: RF \u2013 synchronization: chief<\/td>\nname|mode<\/td>\nlock operation<\/td>\nlock value<\/td>\n<\/tr>\n
enq: RF \u2013 synchronization: critical ai<\/td>\nname|mode<\/td>\nlock operation<\/td>\nlock value<\/td>\n<\/tr>\n
enq: RN \u2013 contention<\/td>\nname|mode<\/td>\nthread number<\/td>\nlog number<\/td>\n<\/tr>\n
enq: RO \u2013 contention<\/td>\nname|mode<\/td>\n2<\/td>\n0<\/td>\n<\/tr>\n
enq: RO \u2013 fast object reuse<\/td>\nname|mode<\/td>\n2<\/td>\n0<\/td>\n<\/tr>\n
enq: RP \u2013 contention<\/td>\nname|mode<\/td>\nfile #<\/td>\n1 or block<\/td>\n<\/tr>\n
enq: RR \u2013 contention<\/td>\nname|mode<\/td>\nlock#<\/td>\nnot used<\/td>\n<\/tr>\n
enq: RS \u2013 file delete<\/td>\nname|mode<\/td>\nrecord type<\/td>\nrecord id<\/td>\n<\/tr>\n
enq: RS \u2013 persist alert level<\/td>\nname|mode<\/td>\nrecord type<\/td>\nrecord id<\/td>\n<\/tr>\n
enq: RS \u2013 prevent aging list update<\/td>\nname|mode<\/td>\nrecord type<\/td>\nrecord id<\/td>\n<\/tr>\n
enq: RS \u2013 prevent file delete<\/td>\nname|mode<\/td>\nrecord type<\/td>\nrecord id<\/td>\n<\/tr>\n
enq: RS \u2013 read alert level<\/td>\nname|mode<\/td>\nrecord type<\/td>\nrecord id<\/td>\n<\/tr>\n
enq: RS \u2013 record reuse<\/td>\nname|mode<\/td>\nrecord type<\/td>\nrecord id<\/td>\n<\/tr>\n
enq: RS \u2013 write alert level<\/td>\nname|mode<\/td>\nrecord type<\/td>\nrecord id<\/td>\n<\/tr>\n
enq: RT \u2013 contention<\/td>\nname|mode<\/td>\nredo thread<\/td>\ntype<\/td>\n<\/tr>\n
enq: RU \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: RU \u2013 waiting<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: RW \u2013 MV metadata contention<\/td>\nname|mode<\/td>\ntable obj#<\/td>\n0<\/td>\n<\/tr>\n
enq: SB \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: SE \u2013 contention<\/td>\nname|mode<\/td>\nSession-id<\/td>\nSerial#<\/td>\n<\/tr>\n
enq: SF \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: SH \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: SI \u2013 contention<\/td>\nname|mode<\/td>\nobject #<\/td>\n0<\/td>\n<\/tr>\n
enq: SK \u2013 contention<\/td>\nname|mode<\/td>\ntablespace #<\/td>\ndba<\/td>\n<\/tr>\n
enq: SQ \u2013 contention<\/td>\nname|mode<\/td>\nobject #<\/td>\n0<\/td>\n<\/tr>\n
enq: SR \u2013 contention<\/td>\nname|mode<\/td>\noperation<\/td>\nsequence # \/ apply #<\/td>\n<\/tr>\n
enq: SS \u2013 contention<\/td>\nname|mode<\/td>\ntablespace #<\/td>\ndba<\/td>\n<\/tr>\n
enq: ST \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: SU \u2013 contention<\/td>\nname|mode<\/td>\ntable space #<\/td>\n0<\/td>\n<\/tr>\n
enq: SW \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: TA \u2013 contention<\/td>\nname|mode<\/td>\noperation<\/td>\nundo segment # \/ other<\/td>\n<\/tr>\n
enq: TB \u2013 SQL Tuning Base Cache Load<\/td>\nname|mode<\/td>\n1<\/td>\n2<\/td>\n<\/tr>\n
enq: TB \u2013 SQL Tuning Base Cache Update<\/td>\nname|mode<\/td>\n1<\/td>\n2<\/td>\n<\/tr>\n
enq: TC \u2013 contention<\/td>\nname|mode<\/td>\ncheckpoint ID<\/td>\n0<\/td>\n<\/tr>\n
enq: TC \u2013 contention2<\/td>\nname|mode<\/td>\ncheckpoint ID<\/td>\n0<\/td>\n<\/tr>\n
enq: TD \u2013 KTF dump entries<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: TE \u2013 KTF broadcast<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: TF \u2013 contention<\/td>\nname|mode<\/td>\ntablespace #<\/td>\nrelative file #<\/td>\n<\/tr>\n
enq: TL \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: TM \u2013 contention<\/td>\nname|mode<\/td>\nobject #<\/td>\ntable\/partition<\/td>\n<\/tr>\n
enq: TO \u2013 contention<\/td>\nname|mode<\/td>\nobject #<\/td>\n1<\/td>\n<\/tr>\n
enq: TQ \u2013 DDL contention<\/td>\nname|mode<\/td>\nQT_OBJ#<\/td>\n0<\/td>\n<\/tr>\n
enq: TQ \u2013 INI contention<\/td>\nname|mode<\/td>\nQT_OBJ#<\/td>\n0<\/td>\n<\/tr>\n
enq: TQ \u2013 TM contention<\/td>\nname|mode<\/td>\nQT_OBJ#<\/td>\n0<\/td>\n<\/tr>\n
enq: TS \u2013 contention<\/td>\nname|mode<\/td>\ntablespace ID<\/td>\ndba<\/td>\n<\/tr>\n
enq: TT \u2013 contention<\/td>\nname|mode<\/td>\ntablespace ID<\/td>\noperation<\/td>\n<\/tr>\n
enq: TW \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\noperation<\/td>\n<\/tr>\n
enq: TX \u2013 allocate ITL entry<\/td>\nname|mode<\/td>\nusn<<16 | slot<\/td>\nsequence<\/td>\n<\/tr>\n
enq: TX \u2013 contention<\/td>\nname|mode<\/td>\nusn<<16 | slot<\/td>\nsequence<\/td>\n<\/tr>\n
enq: TX \u2013 index contention<\/td>\nname|mode<\/td>\nusn<<16 | slot<\/td>\nsequence<\/td>\n<\/tr>\n
enq: TX \u2013 row lock contention<\/td>\nname|mode<\/td>\nusn<<16 | slot<\/td>\nsequence<\/td>\n<\/tr>\n
enq: UL \u2013 contention<\/td>\nname|mode<\/td>\nid<\/td>\n0<\/td>\n<\/tr>\n
enq: US \u2013 contention<\/td>\nname|mode<\/td>\nundo segment #<\/td>\n0<\/td>\n<\/tr>\n
enq: WA \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: WF \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: WL \u2013 contention<\/td>\nname|mode<\/td>\nlog # \/ thread id #<\/td>\nsequence #<\/td>\n<\/tr>\n
enq: WP \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: WR \u2013 contention<\/td>\nname|mode<\/td>\nthread id #<\/td>\nsequence #<\/td>\n<\/tr>\n
enq: XH \u2013 contention<\/td>\nname|mode<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
enq: XQ \u2013 recovery<\/td>\nname|mode<\/td>\ndisk group #<\/td>\nunused<\/td>\n<\/tr>\n
enq: XQ \u2013 relocation<\/td>\nname|mode<\/td>\ndisk group #<\/td>\nunused<\/td>\n<\/tr>\n
enq: XR \u2013 database force logging<\/td>\nname|mode<\/td>\noperation<\/td>\n0<\/td>\n<\/tr>\n
enq: XR \u2013 quiesce database<\/td>\nname|mode<\/td>\noperation<\/td>\n0<\/td>\n<\/tr>\n
enq: XY \u2013 contention<\/td>\nname|mode<\/td>\nid1<\/td>\nid2<\/td>\n<\/tr>\n
enq: ZG \u2013 contention<\/td>\nname|mode<\/td>\nfile group id<\/td>\nversion id<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Enqueue Type Description enq: AD \u2013 allocate AU Synchronizes accesses to a specific OSM (Oracle Software Manager) disk AU enq: AD \u2013 deallocate AU Synchronizes accesses to a specific OSM disk AU enq: AF \u2013 task serialization Serializes access to an advisor task enq: AG \u2013 contention Synchronizes generation use of a particular workspace enq: […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":59,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-337","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-5r","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/337","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=337"}],"version-history":[{"count":3,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/337\/revisions"}],"predecessor-version":[{"id":500,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/337\/revisions\/500"}],"up":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/59"}],"wp:attachment":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}