MONITOR_LOCK
The monitor system table <DATABASE_SYSTEM_ADMINISTRATOR>.MONITOR_LOCK
contains information about operations performed by the lock management functions of the database system.
Value |
Explanation |
|---|---|
|
Average number of entries in the lock list |
|
Maximum number of entries in the lock list |
|
Number of lock collisions |
|
Number of lock escalations |
|
Number of inserted row locks |
|
Number of inserted table locks |
|
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 |
|
Number of lock requests that could not be satisfied because they had exceeded the maximum wait time |