V$ENQUEUE_LOCK
This view shows the locks owned by enqueue state objects.
Fields
The most relevant view fields are as follows:
ADDR
: The address of the lock state objectKADDR
: The address of the lockSID
: The identifier for the session holding or acquiring the lockTYPE
: The type of lockID1
: Lock identifier #1 (depends onTYPE
)ID2
: Lock identifier #2 (depends onTYPE
)LMODE
: A lock mode in which the session holds the lock; values can be:NONE
NULL (NULL)
ROW-S (SS)
ROW-X
SHARE (S)
S/ROW-X (SSX)
EXCLUSIVE (X)
REQUEST
: A lock mode in which the process request locks; values are the same as forLMODE
fieldsCTIME
: The time since the current mode was grantBLOCK
: Whether this lock is blocking another lock
See also
- The
V$LOCK
,V$LOCKED_OBJECT
,DBA_WAITERS
, andDBA_BLOCKERS ...
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.