Viewing Lock Status

How To

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