The system table SYSINFO.LOCKSTATISTICSRESET describes the degree to which lock management is being utilized and the number of special events that have occurred during lock management since the last RESET LOCKSTATISTICS or RESET ALL.
RESETDATE |
TIMESTAMP |
Time of the last RESET for these entries |
AVGUSEDENTRYCOUNT |
FIXED(10) |
Average number of entries used |
AVGUSEDENTRYCOUNTPERCENTAGE |
FIXED(3) |
Average percentage of entries used |
MAXUSEDENTRYCOUNT |
FIXED(10) |
Maximum number of entries used |
MAXUSEDENTRYCOUNTPERCENTAGE |
FIXED(3) |
Maximum percentage of entries used |
LOCKESCALATIONCOUNT |
FIXED(10) |
Number of lock escalations executed |
SQLLOCKCOLLISIONCOUNT |
FIXED(10) |
Number of lock collisions for SQL database objects |
OMSLOCKCOLLISIONCOUNT |
FIXED(10) |
Number of lock collisions for OMS objects |
DEADLOCKCOUNT |
FIXED(10) |
Number of dead locks recognized |
SQLREQUESTTIMEOUTCOUNT |
FIXED(10) |
Number of unfulfilled lock requests for SQL database objects |
OMSREQUESTTIMEOUTCOUNT |
FIXED(10) |
Number of unfulfilled lock requests for OMS objects |