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.
| Field | Value |
|---|---|
| Oracle SID* | |
| Oracle Username* | |
| Oracle Password* | |
| Oracle Port* | 1521 |
| Timeout* | 30 |
| Critical Maximum Active Locks | |
| Warning Maximum Active Locks |
Table C.58. Oracle::Locks settings