Check manual page of oracle_sessions

oracle_sessions

Author: Mathias Kettner

License: GPL

Distribution: official part of Check_MK

Supported Agents: Linux, HPUX

This check monitors the number of active sessions in an ORACLE database. You can set warn/crit levels.

This check needs the Check_MK mk_oracle-plugin installed in the agent. Please refer to the online documentation for how to install that plugin.

Item

The SID of the database (as appearing in the process name of the pmon_... process).

Check parameters

Parameter	Type	Description
warning	int	The number of active sessions triggering a warning
critical	int	The number of active sessions making the check critical

Performance data

One value: the current number of active sessions.

Inventory

One separate check for each database found running will be created.

Configuration variables

Variable	Type	Description
oracle_sessions_default_levels	int, int	Global default levels used for all checks which have no specific configuration. This is preset to (50, 100).

Examples

# Set global default values to 20 sessions for
# warning and 100 sessions for critical
oracle_sessions_default_levels = (20, 100)

# Set higher levels for productive systems
# (having the host tag 'prod')
check_parameters += [
   ( (80, 160), [ 'prod' ], ALL_HOSTS, [ "ORA .* sessions" ])
]