LLI Wiki — My Digital Knowledge Base

Oracle: monitoring modes of the check_oracle_health plugin

Reference list of Oracle monitoring counters (tablespaces, SGA, redo, rollback, waits).

This is a reference list of the Oracle monitoring modes (counters) exposed by the check_oracle_health plugin, which Nagios-compatible tools such as Centreon use to monitor an Oracle database.

Availability and sessions

Mode Description
tnsping Check the reachability of the server
connection-time Time to connect to the server
connected-users Number of currently connected users
invalid-objects Number of invalid objects in the database
stale-statistics Find objects with stale optimizer statistics

Memory (SGA / PGA)

Mode Description
sga-data-buffer-hit-ratio Data buffer cache hit ratio
sga-library-cache-hit-ratio Library cache hit ratio
sga-dictionary-cache-hit-ratio Dictionary cache hit ratio
sga-latches-hit-ratio Latches hit ratio
sga-shared-pool-reload-ratio Shared pool reloads vs. pins
sga-shared-pool-free Shared pool free memory
pga-in-memory-sort-ratio PGA in-memory sort ratio
soft-parse-ratio Percentage of soft parses

Tablespaces and datafiles

Mode Description
tablespace-usage Used space in tablespaces
tablespace-free Free space in tablespaces
tablespace-remaining-time Remaining time until a tablespace is full
tablespace-io-balance Balance of I/O across all datafiles
tablespace-can-allocate-next Segments of a tablespace can allocate the next extent
datafile-io-traffic I/O operations per second of a datafile
flash-recovery-area-usage Used space in the flash recovery area
flash-recovery-area-free Free space in the flash recovery area

The tablespace-fragmentation mode (free space fragmentation index) is listed as no longer used.

Redo log

Mode Description
switch-interval Time between redo log file switches
retry-ratio Redo buffer allocation retries
redo-io-traffic Redo log I/O bytes per second

Rollback segments

Mode Description
roll-header-contention Rollback segment header contention
roll-block-contention Rollback segment block contention
roll-hit-ratio Rollback segment hit ratio (gets/waits)
roll-wraps Rollback segment wraps per second
roll-extends Rollback segment extends per second
roll-avgactivesize Rollback segment average active size

Top segments

Mode Description
seg-top10-logical-reads User objects among the top 10 logical reads
seg-top10-physical-reads User objects among the top 10 physical reads
seg-top10-buffer-busy-waits User objects among the top 10 buffer busy waits
seg-top10-row-lock-waits User objects among the top 10 row lock waits

Waits, enqueues and latches

Mode Description
event-waits Process wait events
event-waiting Time spent by processes waiting for an event
enqueue-contention Percentage of enqueue requests which must wait
enqueue-waiting Percentage of time spent waiting for the enqueue
latch-contention Percentage of latch get requests which must wait
latch-waiting Percentage of time a latch spends sleeping
sysstat Change of v$sysstat values over time
sql Any SQL command returning a single number

Convenience modes

Mode Description
list-tablespaces Lists all tablespaces
list-datafiles Lists all datafiles
list-enqueues Lists all enqueues
list-latches Lists all latches
list-events Lists all events
list-background-events Lists all background events
list-sysstats Lists all statistics from v$sysstat
Mastodon LLIMastodon SocialFosstodon