Appendix C. Probes 175
C.9.11. Oracle::Locks
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
C.9.12. Oracle::Redo Log
The Oracle::Redo Log probe monitors an Oracle database instance and collects the following metrics:
• Redo Log Space Request Rate — The average number of redo log space requests per minute since
the server has been started.
• Redo Buffer Allocation Retry Rate — The average number of buffer allocation retries per minute
since the server was started.
The metrics returned and the thresholds they’re measured against are numbers representing the rate of
change in events per minute. The rate of change for these metrics should be monitored because fast
growth can indicate problems requiring investigation.
Field Value
Oracle SID*
Oracle Username*
Oracle Password*
Oracle Port* 1521
Timeout* 30
Critical Maximum Redo Log Space Request Rate
Warning Maximum Redo Log Space Request Rate
