MONITOR_LOCK

Definition

The monitor system table MONITOR_LOCK contains information about operations performed by the lock management functions of the database system.

Structure

DESCRIPTION Column

Value

Explanation

Lock list avg used entries

Average number of entries in the lock list

Lock list max used entries

Maximum number of entries in the lock list

Lock list collisions

Number of lock collisions

Lock list escalations

Number of lock escalations

Lock list inserted row entries

Number of inserted row locks

Lock list inserted table entries

Number of inserted table locks

Detected deadlocks

Number of situations where at least two transactions collided with each other due to held and requested locks in such a way that this collision can be resolved only by implicitly ending a transaction

Request timeouts

Number of lock requests that could not be satisfied because they had exceeded the maximum wait time

See also:

MONITOR

Concepts of the Database System, Locking for Database Objects