This Oracle 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.
Install the Oracle database instant client on the Network Monitor server or gateway. Download and install the 32-bit client, even if your server is 64-bit. This is because Network Monitor is a 32-bit application and requires 32-bit drivers.
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 account
These fields are required to connect to the database to perform configured tests.
Inherit credentials - If checked, inherits credentials from the device. If blank, enter monitor-specific credentials.
Username/password - Credential used to authenticate access for this monitor.
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.
Fail if no rows - Check this option to make the monitor fail the test if the query returns no rows.
SYSDBA privilege - If checked, elevates the credential to SYSDBA.
Value type - Type of value that is compared with the retrieved value from the database.
Compare operation - Operation to evaluate the returned query result and the compare value to determine if the test succeeded or failed.
Compare value - Value to compare the query result with.
