Red Hat NETWORK SATELLITE 5.2 - CHANNEL MANAGEMENT, Reference Manual

Page: 242 / 268

Appendix C. Probes
230
C.9. Oracle 8i, 9i, and 10g
The probes in this section may be applied to instances of the Oracle database matching the versions
supported. Oracle probes require the configuration of the database and associations made by running
the following command:
$ORACLE_HOME/rdbms/admin/catalog.sql
In addition, for these probes to function properly, the Oracle user configured in the probe must have
minimum privileges of CONNECT and SELECT_CATALOG_ROLE.
Some Oracle probes are specifically aimed at tuning devices for long-term performance gains,
rather than avoiding outages. Therefore, Red Hat recommends scheduling them to occur less
frequently, between every hour and every two days. This provides a better statistical representation,
de-emphasizing anomalies that can occur at shorter time intervals. This applies to following probes:
Buffer Cache, Data Dictionary Cache, Disk Sort Ratio, Library Cache, and Redo Log.
For CRITICAL and WARNING thresholds based upon time to work as intended, their values cannot
exceed the amount of time allotted to the timeout period. Otherwise, an UNKNOWN status is returned
in all cases of extended latency, thereby nullifying the thresholds. For this reason, Red Hat strongly
recommends ensuring that timeout periods exceed all timed thresholds. In this section, this refers
specifically to the probe TNS Ping.
Finally, customers using these Oracle probes against a database using Oracle's Multi-Threaded
Server (MTS) must contact Red Hat support to have entries added to the RHN Server's /etc/hosts file
to ensure that the DNS name is resolved correctly.
C.9.1. Oracle::Active Sessions
The Oracle::Active Sessions probe monitors an Oracle instance and collects the following metrics:
• Active Sessions — The number of active sessions based on the value of
V
$PARAMETER.PROCESSES
.
• Available Sessions — The percentage of active sessions that are available based on the value of
V
$PARAMETER.PROCESSES
.
Field Value
Oracle SID*
Oracle Username*
Oracle Password*
Oracle Port*
1521
Timeout* 30
Critical Maximum Active Sessions
Warning Maximum Active Sessions
Critical Maximum Available Sessions Used
Warning Maximum Available Sessions Used
Table C.48. Oracle::Active Sessions settings