Installation guide

Table A.50. Oracle::Blocking Sessions set tings
Field Value
Oracle SID*
Oracle Username*
Oracle Password*
Oracle Port* 1521
Time Blocking (seconds)* 20
Timeout* 30
Critical Maximum Blocking Sessions
Warning Maximum Blocking Sessions
A.9.4. Oracle::Buffer Cache
The Oracle::Buffer Cache probe computes the Buffer Cache Hit Ratio so as to optimize the system
global area (SGA) Database Buffer Cache size. It collects the following metrics:
Db Block Gets - T he number of blocks accessed via single block gets (not through the consistent get
mechanism).
Consistent Gets - T he number of accesses made to the block buffer to retrieve data in a consistent
mode.
Physical Reads - T he cumulative number of blocks read from disk.
Buffer Cache Hit Ratio - T he rate at which the database goes to the buffer instead of the hard disk to
retrieve data. A low ratio suggests more RAM should be added to the system.
Table A.51. Oracle::Buffer Cache settings
Field Value
Oracle SID*
Oracle Username*
Oracle Password*
Oracle Port 1521
Timeout* 30
Warning Minimum Buffer Cache Hit Ratio
Critical Minimum Buffer Cache Hit Ratio
A.9.5. Oracle::Client Connectivity
The Oracle::Client Connectivity probe determines if the database is up and capable of receiving
connections from the monitored system. T his probe opens an rhnm d connection to the system and
issues a sqlplus connect command on the monitored system.
The Expected DB nam e parameter is the expected value of V$DATABASE.NAME. This value is case-
insensitive. A CRITICAL status is returned if this value is not found.
Requirements - T he Red Hat Network monitoring daemon (rhnm d) must be running on the monitored
system to execute this probe. For this probe to run, the nocpulse user must be granted read access to
your log files.
Red Hat Satellite 5.6 Reference Guide
118