Lock List
Use this report to view information about the locks on a database server.
The report displays the following information for each lock:
- Owner
- The user name of the lock owner.
- Owner Session ID
- The session ID of the lock owner.
- Waiter
- The user name of the first waiter on the lock.
- Waiter Session ID
- The session ID of the first waiter on the lock.
- Lock Type
- HDR: Header
- B: Bytes
- S: Shared
- X: Exclusive
- I: Intent
- U: Update
- IX: Intent-exclusive
- IS: Intent-shared
- SIX: Shared, intent-exclusive
- Locked Object
- The name of the database and table on which the lock is held.
- Row ID
- The ID of the row on which the lock is held.
- Partition Number
- The partition number of the table on which the lock is held.
- Lock Start Time
- When the lock started.