Snapshot Level Database Application Lock |
Logical Data Grouping dbase appl dbase_lock |
Monitor Switch Basic Basic Basic |
Resettable |
No |
|
Element Name Element Type |
locks_waiting gauge |
Description: Indicates the number of agents 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.