Show Table of Contents
The Oracle::Locks probe monitors an Oracle database instance and collects the following metric:
- Active Locks — The current number of active locks as determined by the value in the v$locks table. Database administrators should be aware of high numbers of locks present in a database instance.
Locks are used so that multiple users or processes updating the same data in the database do not conflict. This probe is useful for alerting database administrators when a high number of locks are present in a given instance.
Table C.58. Oracle::Locks settings
|Critical Maximum Active Locks|
|Warning Maximum Active Locks|