Databases Reference
In-Depth Information
V$LOCK
This view lists the locks held by the database.
Fields
The most relevant view fields are:
F
SID
: An identifier for the session holding or acquiring the lock
F
ID1
: Lock identifier #1 (depends on
TYPE
)
F
ID2
: Lock identifier #2 (depends on
TYPE
)
F
TYPE
: The type of lock; user locks can be
TM
(DML enqueue),
TX
(transaction
enqueue), or
UL
(user supplied)
F
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)
F
REQUEST
: A lock mode in which the process request locks; values are the same as
for the
LMODE
ield
F
CTIME
: The time since current mode was granted
F
BLOCK
: If the lock is blocking another lock the value is 1, otherwise the value is 0
See also
F
The
DBA_BLOCKERS
,
DBA_WAITERS
,
V$ENQUEUE_LOCK
, and
V$LOCKED_OBJECT
sections in this appendix