Introducing the Oracle Database Solution

To address the needs of Oracle database performance monitoring, Mercury Interactive offers the Oracle Database Solution. The SiteScope Oracle Database Solution provides efficient and thorough monitoring of performance, availability, and usage statistics for Oracle 8i, 9i and 10g databases.

This solution uses a new monitor type called the Database Counter Monitor. This monitor collects performance metrics from JDBC-accessible databases. In addition to the new monitor type, you can use the Oracle Database Solution template to deploy a collection of monitors configured with default metrics. These built-in default monitors and metrics use monitoring configurations have been researched from best practice data and expertise from Mercury’s professional services organization, customers and industry experts.

Note: You must have the applicable SiteScope option license to use the Oracle Database Solution template. Contact your Mercury sales representative for more information about Solution licensing.

The purpose of a solution template is to provide comprehensive Oracle database monitoring without requiring the SiteScope user or the IT organization to be an expert on the application. Benefits of the Oracle Database Solution Template include:

Reduces the need for Oracle performance domain expertise
Reduces the time to configure and deploy Database Counter Monitors against Oracle databases
Helps identify both real-time performance bottlenecks and longer term trends
Ensures that SiteScope monitoring license points are not wasted on lower priority monitors and metrics

The Oracle Database Solution Template deploys monitors that target the following aspects of Oracle performance and health:

General System Statistics
The most important V$SYSSTAT statistics are monitored by default in the monitors deployed by the Oracle Database Solution. Where applicable, these metrics are combined to calculate deltas and rates on a per-second or per-transaction basis. When monitoring the important metrics from the V$ tables in the database, the Oracle Database Solution is a replacement for manually generated SQL scripts.
Oracle Logs
Important Oracle log files are monitored for "ORA-" errors. Users may customize the these monitors to look for specific text in a log file, depending on their database configuration.
Diagnosing Database Problems
In addition to the deployed monitors, the Oracle Solution offers several tools which can be used to gain diagnostic information about a database. Resource-intensive SQL statements, shared server process contention, and the number of sessions waiting for specific events are all examples of the diagnostic data that these tools can provide. Since the tools are made available in the form of disabled monitors, this important information is literally just a click away.