Next Topic

Previous Topic

Book Contents

Oracle monitor

Monitor description

This monitor type is capable of monitoring several key aspects of an Oracle database. The monitor uses the native Oracle interface and does not require an ODBC driver installed on the Network Monitor host machine.

  • System type: All
  • Category: Databases

Prerequisites

Install the Oracle database instant client on the Network Monitor host machine.

After installation ensure that the folder where you installed the package is in the Windows system path. This might require a reboot of the server. After altering the system path, restart the Network Monitor service for the change to take effect. If Network Monitor cannot access the DLL files it requires, the Oracle monitor fails with an error message specifying that it cannot find the DLL files.

Oracle monitor properties

Monitor specific properties

These fields are required to connect to the database to perform configured tests.

  • Logon account - The logon account contains the credentials to use when authenticating with the Oracle database.
  • Service name - This is the name of the service defined in the tnsnames.ora file. Network Monitor uses this information to connect to the Oracle database.
  • Port - The port number the Oracle database server listens to.

Performance monitoring options

  • Max open cursors - A numeric value that represents the maximum number of simultaneously opened cursors. If the number of open cursors exceeds this value the monitor fails the test. Leave the field blank to not perform this test.
  • Long op. threshold - A value in seconds that is the maximum time an operation can execute. If this time is exceeded, the monitor fails the test. Leave the field blank to not perform this test.
  • Buffer cache hit ratio - The buffer cache hit ratio indicates the percent of total number of requests that have been served without accessing the disk. A higher value translates into better database performance. Set this value to the lowest acceptable value. If the ratio falls below this value the monitor fails the test. Leave the field blank to not perform this test.
  • Failed logons - A numeric value that represents the maximum allowed number of failed logons during a day. To test this value, auditing must be enabled. Leave the field blank to not perform this test.

Tablespace monitoring options

A table space is associated with physical files stored on disk, each database can be associated with one or more table spaces for storages of tables and indexes. By monitoring table space usage, you can be warned before the remaining free space in a table space passes below a threshold.

  • Tablespace usage (any) - A threshold value that sets the maximum percent usage of a table space allowed. This field applies to all table spaces in the database. Subsequent fields can be used to configure exceptions for this rule, for up to five other table spaces. Leave the field blank to not perform this test.
  • Tablespace usage (1-5) - A threshold value for the maximum usage allowed for a specific table space. These fields override the global table space threshold. Leave the field blank to not perform this test.

SQL query option

An optional SQL statement can be executed and its output compared to a predefined value using a compare operation.

  • SQL query - Optional SQL query to perform.
  • No rows fail - Check this option to make the monitor fail the test if the query returns no rows.
  • Compare value - Value to compare the query result with.
  • Value type - Type of value that is compared with the retrieved value from the database.
  • Operation - Operation to evaluate the returned query result and the compare value to determine if the test succeeded or failed.