Oracle Test Parameters

The Oracle monitor discovers and monitors availability and performance metrics from Oracle database. It performs SQL queries to extract raw data and formulate relevant metrics. Includes: Buffer Cache Hit Ratio, Data Dictionary Cache Hit Ratio, Data File Read Operations, Data File Write Operations, Library Cache Hit Ratio, Number Of Logged In Users, Number Of Open Cursors, Number Of Sort Operations, Number Of Space Requests, Number Of Table Scan Operations, Ratio of Sort Operations, Tablespace Status, and Tablespace Usage.

Note: To use this monitor, the Oracle database must support remote network (SQL*net) queries.

Credential/Configuration Settings

• Username (SYSDBA) - The Oracle system database administrator username. Defaults to SYS.
• Password - The SYSDBA password.
• System Identifier (SID) - The unique identifier for an Oracle database.
• Database Port - Defaults to 1521.