Snapshot Information Level Database Application |
API Structure(s) sqlm_dbase sqlm_appl |
Monitor Group Basic Basic |
Resettable |
Yes |
|
Event Information Level Database Connection |
API Structure(s) sqlm_db_event sqlm_conn_event |
|
API Element Name Element Type |
lock_timeouts counter |
Description: The number of times that a request to lock an object timed-out instead of being granted.
Usage: This element can help you adjust the setting for the locktimeout database configuration parameter. If the number of lock time-outs becomes excessive when compared to normal operating levels, you may have an application that is holding locks for long durations.
You could also have too few lock time-outs if your locktimeout database configuration parameter is set too high. In this case, your applications may wait excessively to obtain a lock. See the Administration Guide for more information.
[ Top of Page | Table of Contents | Glossary | Index ]