Database

Presentation

Find all the service models dedicated to the supervision of your Database Application.

Service Models

BOX mode

ORACLE-tablespace-usage-all

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.

Available from version 3.13

ORACLE-sga-shared-pool-reloadrate

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.

Available from version 3.13

ORACLE-Soft_Parse_Ratio

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.

Available from version 3.13

ORACLE-tablespace-can-allocate-next

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.

Available from version 3.13

ORACLE-tablespace-can-allocate-next-all

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.

Available from version 3.13

ORACLE-tablespace-free

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.

Available from version 3.13

ORACLE-tablespace-free-all

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.

Available from version 3.13

ORACLE-Tablespace-FreeSpace-Fragmentation-Index

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.

Available from version 3.13

ORACLE-Tablespace-IO-Balance

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.

Available from version 3.13

ORACLE-tablespace-remaining-time

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.

Available from version 3.13

ORACLE-tablespace-usage

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.

Available from version 3.13

ORACLE-PGA-MemorySort-Ratio

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.

Available from version 3.13

ORACLE-process-usage

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.

Available from version 3.13

ORACLE-redo-io-traffic

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.

Available from version 3.13

ORACLE-redolog-switch-interval

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.

Available from version 3.13

ORACLE-Request-String

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.

Available from version 3.13

ORACLE-rman-errors

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.

Available from version 3.13

ORACLE-session-usage

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.

Available from version 3.13

ORACLE-sga-shared-pool-free

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.

Available from version 3.13

ORACLE-Tablespace-Allocated-usage-all

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.

Available from version 4.13

ORACLE-Datafiles-Max-Possible

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.

Available from version 3.13

ORACLE-db-access

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

Available from version 3.13

ORACLE-DictionnaryCache-Hitratio

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.

Available from version 3.13

ORACLE-Flash-Recovery-Area

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.

Available from version 3.13

ORACLE-Latches-Hitratio

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.

Available from version 3.13

ORACLE-LibraryCache-Hitratio

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.

Available from version 3.13

ORACLE-nb-invalid-objects

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.

Available from version 3.13

ORACLE-Objects-Stale-Statistics

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.

Available from version 3.13

ORACLE-one-tablespace-remaining-time

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.

Available from version 3.13

ORACLE-Alltablespaces-FreeSpace-Fragmentation-Index

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.

Available from version 3.13

ORACLE-Alltablespaces-IO-Balance

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.

Available from version 3.13

ORACLE-connected-users

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.

Available from version 3.13

ORACLE-DataBufferCache-Hitrate

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.

Available from version 3.13

ORACLE-datafile-io-traffic

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.

Available from version 3.13

ORACLE-datafile-single-io-traffic

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.

Available from version 3.13

Documentations

en_GB

Welcome to ServiceNav!

Do you need some help? More information about our products? Write to us!
You have taken note of our privacy policy.
We use cookies to ensure the best experience on our site. If you continue to use this site, we will assume that you are satisfied with it.

Reserve your place

You have taken note of our privacy policy.