Lock held by one instance while change tracking is enabled, to guarantee access to thread-specific resources
Lock held to ensure that only one CTWR process is started in a single instance Serializes access to cleanup client query cache registrations Synchronizes accesses to label cache when dropping a labelĭuring transaction commit to see concurrent registrations Synchronizes accesses to label cache for label comparison
#Oracle enqueue waits update
Lock held to prevent multiple process to update the headers at the same timeĬoordinates cross-instance function invocations Lock held to request controlfile autobackups Lock held to allow cleanup from backup mode during an RMAN proxy-copy backup Lock held to perform a new controlfile autobackup Lock held to serialize section access during multi-section restore Lock held to serialize file header access during multi-section restore Lock held to prevent file from decreasing in physical size during RMAN backup Synchronizes user accesses to a particular workspaceĪffinity Dictionary test affinity synchronizationĢPC distributed transaction branch across RAC instancesĪllocate a bloom filter in a parallel statement Global access synchronization to the AW$ table Row lock synchronization for the AW$ table In-use generation state for a particular workspace Lock held to operate on the audit index file Synchornizes access to objects and scalar variables
#Oracle enqueue waits registration
Prevent DB instance registration during ASM instance shutdown Registers DB instance to ASM client state object hash Synchronizes check for Storage (PST) split in disk groups Prevents a user from being dropped if it owns any open files Synchronizes generation use of a particular workspaceĪllow only one AMDU dump when block read failureĪllow one ASM password file update per cluster at a time This enqueue is used to serialize access to an advisor task Synchronizes accesses to a specific ASM disk AU Lock held to ensure that only one ABMR is started in the cluster Lock held to ensure that ABMR process is initialized This is the new list of enqueue waits in 11gR2: Group Well, a lot has changed in 11g including the enqueue waits. Over 1 and a half year ago I posted the enqueue waits for Oracle 10g.
0 kommentar(er)
