This
monitor system table contains information on the lock management operations performed by the database system.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 in which at least two transactions collided due to existing or requested locks with the result that this collision could only be solved by terminating a transaction implicitly. |
|
Request timeouts |
Number of lock requests that could not be satisfied because they had exceeded the maximum wait time |