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 |
---|---|
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 |