Locks per Table
Use this report to view information about the locks on a database server by table.
The report displays the following information for each lock:
- Database
- The name of the database that contains the table on which the locks are held.
- Table name
- The name of the table on which the locks are held.
- Active Locks
- The number of active locks on the table.
- Lock Requests
- The number of times that a lock was requested on the table since the database server was initialized.
- Lock Waits
- The number of threads that waited for a lock on the table.
- Dead Locks
- The number of deadlocks on the table.
- Lock Timeouts
- The number of locks that timed out on the table.