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 |