|
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. TX = transaction enqueue. |
|
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 |
