Current Agents Waiting On Locks


 
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.