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 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 configured to use Microsoft ODBC Driver for Oracle.
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.
- JDBC string (optional): allows you to specify the raw JDBC
connection string, for example if you wish to use a different driver.
When this is set, the above username and password will be ignored.
- JDBC class: when using a custom JDBC string, you can also
specify a different JDBC class (the default is Sun's JDBC/ODBC bridge).
- TNS name: the Oracle TNS name to connect to.
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, such as extents, bytes used and bytes free.
- Bufferpools: holds bufferpool information.
- Dynamic SQL: holds details for all SQL statements executed
by the system, such as reads and sorts.