Red Hat NETWORK 3.6 - Technical Information PDF herunterladen (Seite 173)

Appendix C. Probes 161

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 to the buffer instead of the hard 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-

1 2 ... 168 169 170 171 172 173 174 175 176 177 178 ... 197 198

Keine Kommentare

Red Hat NETWORK 3.6 - Technical Information Seite 173