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.
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.
The agent supports Oracle version 8, 9i and Oracle 10g.
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.
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.