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 |