We use cookies to ensure that we give you the best experience on our website. Visit our Privacy Policy to learn more. If you continue to use this site, we will assume that you are okay with it.

Your choices regarding cookies on this site.
Your preferences have been updated.
In order for the changes to take effect completely please clear your browser cookies and cache. Then reload the page.

Check manual page of oracle_tablespaces

Checkmk Manual

On this page

Search in the manual

Various aspects of ORACLE tablespaces

Distribution: official part of Check_MK
License: GPL
Supported Agents: Linux, HPUX, Solaris, Windows

This check monitors the state of ORACLE tablespaces. It checks the current and maximum size, the online state and the autoextension and optionally the setting of the increment size.

Autoextension: During inventory the autoextension setting is determined and remembered for later. That means that if the auto extension setting changes later, the check will get critical. A table space may consist of several data files with different settings. If at least one data file has auto extension turned on, the table space is considered to have auto extension turned on. The behaviour of autoextension setting can be configured with a check parameter.

Increment size: If the configuration parameter oracle_tablespaces_check_default_increment is set to True (which is the default), then the check will warn you, if the increment size is set to the ORACLE default value of 1 (which is generally considered as a non-optimal setting).

State: Only table spaces in state ONLINE and READONLY will be found by inventory and monitored. If the state changes later, the check will not get critical. The state will just be displayed. We assume that state changes are due to normal operations.

Size: The logic of the size check depends on whether autoextend is on or off. If auto extension is on, then the still possible extensions are accounted for as free spaces as well as the space currently free in the data files. If auto extension is off, only the currently free space will be honored. Table spaces in state READONLY will not be checked for the size.

temptablespace: Ignore temporary Tablespace by default. This can be changed when this parameter is True.

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

A string composited of the SID and the tablespace name, separated by a dot, for example "pengt.TEMP".

Discovery

One separate check will be created for each tablespace which is ONLINE.