DBMS Configuration Syntax

Oracle provide databases for performance and capacity related information. To provide this information in Records, DBMS Configuration entries must be entered to identify the databases to gather the information from. Performance counters in the Windows registry are gathered without configuration.

It is important to understand the difference between the two types of records provided. Performance related records for Oracle deal with such information as user counts, query performance and I/O rates while the records gathered by configured query collection deal with database configuration information and usage and capacity statistics.

The following static configuration entries relate to the Oracle Advanced Systems Manager records that are not automatically collected from the Windows Performance Registry.

SUBSYS DBMS

ODBC RECONNINT (<Interval>, <Unit>)
ORACLE DRIVER (ORACLE_ODBC_DRIVER|ORACLE_OCI_DRIVER)
ORACLE ALIAS (<DBName>)

Syntax Elements

ODBC RECONNINT

Specifies how often to reconnect to the DBMS after a failure. The minimum is 1 minute.

ORACLE DRIVER

This parameter defines the ORACLE database is to be monitored.
Always use the entry (ORACLE_OCI_DRIVER) for the Oracle collector on UNIX.
Always use the entry (ORACLE_ODBC_DRIVER) for the Oracle collector on Windows.

ORACLE ALIAS

Specifies the database names that are going to be monitored, add one per line. Use the connection names as defined in tnsnames.ora.01

The user names and passwords for Oracle and Oracle Alias are configured in Prognosis Configuration for Oracle DB.
Provide feedback on this article