| Owner |
Owner name of object, if applicable |
| Object |
Object name, if applicable |
| SID |
Session ID |
| Session User |
Login name |
| Type |
Lock type. Only the following types are shown:
- RW
- Materialized View Flags
- TM
- DML enqueue (table lock)
- TX
- Transaction enqueue (row lock)
- UL
- User-defined enqueue
|
| Lock Mode |
Lock mode being held:
- Exclusive (X)
- NULL
- Row Exclusive (SX)
- Row Share (SS)
- Share (S)
- Share Row (SSX)
|
| Requested |
Lock mode being requested:
- Exclusive (X)
- NULL
- Row Exclusive (SX)
- Row Share (SS)
- Share (S)
- Share Row (SSX)
|
| ID1 |
Lock ID #1 (depends on type) |
| ID2 |
Lock ID #2 (depends on type) |