Snapshot Information Level Database Application |
API Structure(s) sqlm_dbase sqlm_appl |
Monitor Group Lock Lock |
Resettable |
Yes |
|
Event Information Level Database Connection |
API Structure(s) sqlm_db_event sqlm_conn_event |
|
API Element Name Element Type |
lock_waits counter |
Description: The total number of times that applications or connections waited for locks.
Usage: At the database level, this is the total number of times that applications have had to wait for locks within this database.
At the application-connection level, this is the total number of times that this connection requested a lock but had to wait because another connection was already holding a lock on the data.
This element may be used with "Time Waited On Locks" to calculate, at the database level, the average wait time for a lock. This calculation can be done at either the database or the application-connection level.
If the average lock wait time is high, you should look for applications that hold many locks, or have lock escalations, with a focus on tuning your applications to improve concurrency, if appropriate. If escalations are the reason for a high average lock wait time, then the values of one or both of the locklist and maxlocks configuration parameters may be too low. See the Administration Guide for more information.
[ Top of Page | Table of Contents | Glossary | Index ]