Database

Indicates the percentage of disk space used by all tablespaces in the database and changes state when this percentage exceeds a configured threshold for a tablespace. Configuration: database alias, access account and password, ALERT and CRITICAL status thresholds for the percentage used. Prerequisite: Oracle client installed on the supervisor.

Indicates the percentage of disk space used by a tablespace in the database and changes state when this percentage exceeds a configured threshold. Configuration: database alias, access account and password, ALERT and CRITICAL status thresholds for the percentage used, tablespace name. Prerequisite: Oracle client installed on the supervisor.

Indicates the number of days remaining for 100% usage of the tablespaces in the database and changes state when the number of days remaining for a tablespace falls below a configured threshold. This analysis is performed according to the consumption of the last 30 days by default. Configuration: database alias, access account and password, ALERT and CRITICAL status thresholds for the number of days remaining, analysis period in days. Prerequisite: Oracle client installed on the supervisor.

Collects the I/O balance on the data files of a table of the database, specified in argument. Configuration: the alias of the database, the account and password of the user with access to the database, the threshold for going to the ALERT state, the threshold for going to the CRITICAL state, the name of the table.

The fragmentation index of the free space of a table in the database, specified in argument. This index must be as high as possible. The control changes state if the index is in the alert or critical threshold range. Configuration: the alias of the database, the account and password of the user with access to the database, the threshold for going to the ALERT state, the threshold for going to the CRITICAL state, the table.

Shows the remaining disk space for all tablespaces in the database and changes state when the disk space for a tablespace falls below a configured threshold. Configuration: database alias, access account and password, ALERT and CRITICAL status thresholds for the remaining percentage. Prerequisite: Oracle client installed on the supervisor.

Indicates the percentage of disk space remaining for a tablespace in the database and changes state when this percentage falls below a configured threshold. Configuration: database alias, access account and password, ALERT and CRITICAL status thresholds for the remaining percentage, tablespace name. Prerequisite: Oracle client installed on the supervisor.

Collects the percentage of soft parses for a database. This rate must be as high as possible. Configuration : the alias of the database, the account and password of the user having access to the database, the threshold of passage to the ALERT state, the threshold of passage to the CRITICAL state.

Indicates if there is enough space left for the next group of contiguous data (Extent), for the indicated tablespace. Configuration: database alias, access account and password, tablespace name. Prerequisite: Oracle client installed on the supervisor.

Indicates if there is enough space left for the next group of contiguous data (Extent), for all the tablespace. Configuration: database alias, account and access password. Prerequisite: Oracle client installed on the supervisor.

The Reload Rate for the Oracle database in the shared memory area (SGA). This rate should be as low as possible. Configuration: the alias of the database, the account and password of the user with access to the database, the threshold for going to the ALERT state, the threshold for going to the CRITICAL state.

Indicates the percentage of memory in the shared memory area (SGA). Configuration: database alias, access account and password, ALERT and CRITICAL status thresholds for the remaining percentage. Prerequisite: Oracle client installed on the supervisor.

The percentage of use of the number of sessions available for the Oracle database. Configuration: the alias of the database, the account and password of the user with access to the database, the percentage above which the status changes to ALERT, the percentage above which the status changes to CRITICAL.

Shows the number of errors on the backup/restore performed with the Oracle RMAN tool over the last three days. Configuration: database alias, access account and password, ALERT and CRITICAL status thresholds for the number of errors. Prerequisite: Oracle client installed on the supervisor.

Indicates the number of IO per second on the database log file in megabytes per second, and changes state when this number exceeds a configured threshold. Configuration: database alias, access account and password, ALERT and CRITICAL status thresholds. Prerequisite: Oracle client installed on the supervisor.

Indicates the last interval from one redo log file to another in minutes, and the estimate for the next interval in minutes. The control changes state when the estimate exceeds a configured threshold in seconds. Configuration: database alias, access account and password, ALERT and CRITICAL status thresholds in seconds. Prerequisite: Oracle client installed on the supervisor.

Executes a SQL query on an Oracle database that returns a String value. Changes state depending on the string returned by the query in comparison with the plug-in. Supported versions: all Oracle editions. Configuration: the tnsname.ora file, the name of the database, an account and a password of a user having the rights to execute the query, SQL query, the string to compare with the result, its status if the string is present and its status if not.

Indicates the number of days remaining for 100% usage of a tablespace in the database and changes state when the number of days remaining for that tablespace falls below a configured threshold. This analysis is performed according to the consumption of the last 30 days by default. Configuration: database alias, access account and password, ALERT and CRITICAL status thresholds for the number of days remaining, analysis period in days. Prerequisite: Oracle client installed on the supervisor.

The in-memory sort ratio for the Oracle database in the Program Global Area (PGA). This ratio must be as high as possible. Configuration: the alias of the database, the account and password of the user with access to the database, the threshold for going to the ALERT state, the threshold for going to the CRITICAL state.

The utilization rate of the processes available for the Oracle database. Configuration: the alias of the database, the account and password of the user with access to the database, the percentage above which the status changes to ALERT, the percentage above which the status changes to CRITICAL.

For each tablespace, checks the percentage of database file usage and alerts if the value exceeds the configured thresholds.
If the database is configured to dynamically allocate more space, this template can create false alarms, use the ORACLE-tablespace-free-all template in this case.
Configuration: database alias, access account and password, alert and critical status thresholds in percent.

The number of objects with obsolete statistics. These statistics are used by the Oracle optimizer. The collection of these statistics can be disabled. Configuration: the alias of the database, the account and password of the user with access to the database, the threshold for going to the ALERT state, the threshold for going to the CRITICAL state.

Indicates the number of invalid objects (indexes, partitions, objects, registry components). Configuration: database alias, account and access password. Prerequisite: Oracle client installed on the supervisor.

The Hitrate in the Library Cache for the Oracle database. This rate should be as high as possible. Configuration: the alias of the database, the account and password of the user with access to the database, the threshold for going to the ALERT state, the threshold for going to the CRITICAL state.

The Hitrate of the Latches for the Oracle database. This rate must be as high as possible. Configuration: the alias of the database, the account and password of the user with access to the database, the threshold for going to the ALERT state, the threshold for going to the CRITICAL state.

Collects the free disk space in the flash restore area. Configuration: the alias of the database, the account and password of the user with access to the database, the threshold for going to the ALERT state, the threshold for going to the CRITICAL state.

The Hitrate in the Dictionnary Cache for the Oracle database. This ratio should be as high as possible. A Dictionary Cache Hit Ratio value > 85% is satisfactory. Configuration: the database alias, the account and password of the user with access to the database, the threshold for going to the ALERT state, the threshold for going to the CRITICAL state.

Test the access to the database with the TNSPING method. Configuration: database alias, account and access password. Prerequisite: Oracle client installed on the supervisor.

Collects the percentage of existing data files compared to the maximum number of data files for a database. Configuration : the alias of the database, the account and password of the user having access to the database, the threshold to go to the ALERT state, the threshold to go to the CRITICAL state.

Indicates the number of input/output (IO) operations per second on a datafile in the database and changes state when this number exceeds a configured threshold. Configuration: database alias, access account and password, ALERT and CRITICAL status thresholds for the number of IOs per second, datafile name. Prerequisite: Oracle client installed on the supervisor.

Indicates the number of input/output (IO) operations per second on the database datafile and changes state when this number exceeds a configured threshold. Configuration: database alias, access account and password, ALERT and CRITICAL status thresholds for the number of IO per second. Prerequisite: Oracle client installed on the supervisor.

The Hitrate in the Data Buffer Cache for the Oracle database. Configuration: the alias of the database, the account and password of the user with access to the database, the percentage above which the status changes to ALERT, the percentage above which the status changes to CRITICAL.

The total number of users connected to the Oracle database. Configuration: the alias of the database, the account and password of the user with access to the database, the number of users above which the status changes to ALERT, the number of users above which the status changes to CRITICAL.

Collects the I/O balance on the data files of all tables in the database. Configuration: the alias of the database, the account and password of the user with access to the database, the threshold for going to the ALERT state, the threshold for going to the CRITICAL state.

The fragmentation index of the free space of all tables in the database. This index should be as high as possible. The control changes state if at least one index is in the alert or critical threshold range. Configuration: the alias of the database, the account and password of the user with access to the database, the threshold for going to the ALERT state, the threshold for going to the CRITICAL state.