Dynamic Performance (V$) Views, 52 of 179

V$ENQUEUE_LOCK

This view displays all locks owned by enqueue state objects. The columns in this view are identical to the columns in V$LOCK.

See Also:
"V$LOCK".

Column	Datatype	Description
`ADDR`	`RAW(4)`	Address of lock state object
`KADDR`	`RAW(4)`	Address of lock
`SID`	`NUMBER`	Identifier for session holding or acquiring the lock
`TYPE`	`VARCHAR2(2)`	Type of lock. For a list of user and system types that can have locks.
`ID1`	`NUMBER`	Lock identifier #1 (depends on type)
`ID2`	`NUMBER`	Lock identifier #2 (depends on type)
`LMODE`	`NUMBER`	Lock mode in which the session holds the lock: 0, None 1, Null (NULL) 2, Row-S (SS) 3, Row-X (SX) 4, Share (S) 5, S/Row-X (SSX) 6, Exclusive (X)
`REQUEST`	`NUMBER`	Lock mode in which the process requests the lock: 0, None 1, Null (NULL) 2, Row-S (SS) 3, Row-X (SX) 4, Share (S) 5, S/Row-X (SSX) 6, Exclusive (X)
`CTIME`	`NUMBER`	Time since current mode was granted
`BLOCK`	`NUMBER`	The lock is blocking another lock