Appendix C. Probes 161Field ValueOracle SID*Oracle Username*Oracle Password*Oracle Port* 1521Time Blocking (seconds)* 20Timeout* 30Critical Maximum Blocking SessionsWarning Maximum Blocking SessionsTable C-50. Oracle::Blocking Sessions settingsC.9.4. Oracle::Buffer CacheThe Oracle::Buffer Cache probe computes the Buffer Cache Hit Ratio so as to optimize the systemglobal 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 consistentget mechanism).• Consistent Gets — The number of accesses made to the block buffer to retrieve data in a consistentmode.• Physical Reads — The cumulative number of blocks read from disk.• Buffer Cache Hit Ratio — The rate the database goes to the buffer instead of the hard disk to retrievedata. A low ratio suggests more RAM should be added to the system.Field ValueOracle SID*Oracle Username*Oracle Password*Oracle Port 1521Timeout* 30Warning Minimum Buffer Cache Hit RatioCritical Minimum Buffer Cache Hit RatioTable C-51. Oracle::Buffer Cache settingsC.9.5. Oracle::Client ConnectivityThe 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 issuesa 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-
