Appendix D. Probes
282
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 D.51. Oracle::Buffer Cache settings
D.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. This probe opens an
rhnmd
connection to the system and
issues a
sqlplus connect
command on the monitored system.
The
Expected DB name
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
— The Red Hat Network Monitoring Daemon (
rhnmd
) 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.
Field
Value
Oracle Hostname or IP address*
Oracle SID*
Oracle Username*
Oracle Password*
Oracle Port*
1521
ORACLE_HOME*
/opt/oracle
Expected DB Name*
Timeout*
30
Table D.52. Oracle::Client Connectivity settings
D.9.6. Oracle::Data Dictionary Cache
The Oracle::Data Dictionary Cache probe computes the Data Dictionary Cache Hit Ratio so as to
optimize the SHARED_POOL_SIZE in
init.ora
. It collects the following metrics:
• Data Dictionary Hit Ratio — The ratio of cache hits to cache lookup attempts in the data dictionary
cache. In other words, the rate at which the database goes to the dictionary instead of the hard disk
to retrieve data. A low ratio suggests more RAM should be added to the system.
• Gets — The number of blocks accessed via single block gets (not through the consistent get
mechanism).
• Cache Misses — The number of accesses made to the block buffer to retrieve data in a consistent
mode.
Summary of Contents for NETWORK SATELLITE 5.3.0 - CHANNEL MANAGEMENT
Page 1: ...Red Hat Network Satellite 5 3 0 Reference Guide Red Hat Network Satellite ...
Page 32: ...20 ...
Page 44: ...Chapter 4 Red Hat Update Agent 32 Figure 4 11 Available Package Updates ...
Page 168: ...156 ...
Page 180: ...168 ...
Page 216: ...204 ...
Page 232: ...220 ...
Page 248: ...236 ...
Page 260: ...248 ...
Page 309: ...297 Appendix E Revision History Revision 1 0 Fri Feb 27 2009 ...
Page 310: ...298 ...
Page 318: ...306 ...