Viewing Lock Status |
Lock status items are statistics related to the cumulative number of locks, lock escalations, deadlocks, and failed events due to lock timeouts. The lock status page displays lock information statistics from the SYSINFO table. Lock status items and their corresponding SYSINFO.INFO values are summarized in Table.
|
Lock Status Item |
Description |
|
Number of Page Locks Escalation |
The accumulated number of row locks that have been escalated to page locks. (NUM_ROW_LOCK_UPG) |
|
Number of Table Locks Escalation |
The accumulated number of page locks that have been escalated to table locks. (NUM_PAGE_LOCK_UPG) |
|
Number of fail locks because of timeout |
The accumulated number of actions failing due to a timeout while waiting to acquire a lock on an object. (NUM_LOCK_TIMEOUT) |
|
Number of Locks Waited |
The accumulated number of events waiting to place locks on objects. (NUM_LOCK_WAIT) |
|
Number of Locks Requested |
The accumulated number of locks requested on data objects. (NUM_LOCK_REQUEST) |
|
Number of deadlocks detected |
The accumulated number of deadlocks detected. (NUM_DEADLOCK) |
Table: Lock Status Items
Related topic:
Waiting
Information
Monitoring Database Locks
Monitoring Database Status