Snapshot Information Level Database Lock |
API Structure(s) sqlm_dbase sqlm_dbase_lock |
Monitor Group Basic Basic |
Resettable |
No |
|
API Element Name Element Type |
locks_waiting gauge |
Description: Indicates the number of applications waiting on a lock.
Usage: When used in conjunction with "Applications Connected Currently", this element indicates the percentage of applications waiting on locks. If this number is high, the applications may have concurrency problems, and you should identify applications that are holding locks or exclusive locks for long periods of time.
[ Top of Page | Table of Contents | Glossary | Index ]