Documentation‎ > ‎Monitoring Agents‎ > ‎

Oracle

This agent retrieves information about an Oracle database system. It uses SQL providers to retrieve its information and can be extended with other providers to return more data. Along with the Unix agents, the Oracle agent can be used as an example when creating your own monitoring data providers.


Local/Remote Modes

The agent supports both local and remote modes, provided that it can open a database connection from the machine it is deployed on. By default the agent is using the Type 4 JDBC driver so there is no need for any Oracle libraries to be available on the deployment host.


Supported Versions

The agent supports Oracle version 8, 9i and Oracle 10g.


Configuration

The following configuration options are available:
  • Username: user name to use when connecting to Oracle.
  • Password: password to use when connecting to Oracle.
  • Port: port number for the Oracle database server; it defaults to 1521
  • SID: the Oracle SID of the database to monitor.
  • JDBC driver class: the name of the java class implementing the Oracle JDBC driver; it defaults to oracle.jdbc.driver.OracleDriver
  • JDBC driver class path: the path to the jar file with the JDBC driver, relative to the IxoraRMS installation folder.

Contents

The agent returns the following information about an Oracle database:
  • Events: holds statistics about Oracle system events.
  • Sessions: contains information about existing Oracle client sessions.
  • Tablespaces: contains details about tablespaces defined in the system.
  • Bufferpools: holds bufferpool information.
  • Dynamic SQL: holds details for the most expensive SQL statements executed by the system.
  • Data access statistics: holds statistics about data access patterns.
  • Data dictionary cache: holds information about the data dictionary cache.
  • Library cache: holds information about the library cache.
  • I/O statisics: holds statistics for general I/O activity in the database.