Appendix C. Probes 171
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
Table C-50. Oracle::Blocking Sessions settings
C.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 — The number of blocks accessed via single block gets (not through the consistent
get mechanism).
• Consistent Gets — The number of accesses made to the block buffer to retrieve data in a consistent
mode.
• Physical Reads — The cumulative number of blocks read from disk.
• Buffer Cache Hit Ratio —The rate the database goes tothe buffer instead of thehard disk to retrieve
data. A low ratio suggests more RAM should be added to the system.
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
Table C-51. Oracle::Buffer Cache settings
C.9.5. Oracle::Client Connectivity
The Oracle::Client Connectivity probe determines if the database is up and capable of receiving con-
nections from the monitored system. This probe opens an rhnmd connection to the system and issues
a sqlplus connect command to be run on the same monitored system.
The Expected DB name parameter is the expected value of V$DATABASE.NAME. This value is case-
