check_oracle_health is a plugin for the Shinken (Nagios) monitoring software that allows you to monitor various metrics of an Oracle database. It includes connection time, SGA data buffer hit ratio, SGA library cache hit ratio, SGA dictionary cache hit ratio, SGA shared pool free, PGA in memory sort ratio, tablespace usage, tablespace fragmentation, tablespace I/O balance, invalid objects, and many more.
|Tags||Monitoring Systems Administration Database Oracle Diagnostics Nagios shinken|
|Operating Systems||POSIX Windows|
Release Notes: This release optimizes tablespace-can-allocate-next. It adds the parameters --mitigation, --notemp, and --noreadonly. It implements all sorts of thresholds. It adds an sql-runtime mode.
Release Notes: New modes were added: sga-library-cache-pinhit-ratio, sga-library-cache-gethit-ratio, and sga-library-cache-reloads. The mode sql now correctly handles DML SQL errors like missing tables, etc.
Release Notes: This release adds the option –commit. It adds error handling for unwritable status files. It fixes a bug with statefilesdir and capital letters. Enhanced stale statistics and invalid objects mode. The plugin can now be used with the OMD framework.
Release Notes: New modes were added: session-usage, process-usage, rman-backup-problems, and datafiles-existing. When used in an OMD environment, check_oracle_health's temporary files are now saved locally.
Release Notes: This release fixes a bug that lead to numerous leftover temp files under Windows. Upgrading is recommended.