Projects / check_oracle_health

check_oracle_health

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
Operating Systems
Implementation

RSS Recent releases

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.

  •  22 Aug 2011 01:21

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.

  •  16 Jun 2011 13:05

    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.

    •  10 Feb 2011 22:02

    Release Notes: This release fixes a bug that lead to numerous leftover temp files under Windows. Upgrading is recommended.

    Screenshot

    Project Spotlight

    Grenouille

    An online service for weather data.

    Screenshot

    Project Spotlight

    Knot DNS

    An authoritative DNS server.