Red Hat NETWORK SATELLITE 5.3.0 - CHANNEL MANAGEMENT, Reference Manual

Page: 293 / 318

Oracle::Availability
281
D.9.2. Oracle::Availability
The Oracle::Availability probe determines the availability of the database from the RHN Satellite.
Field Value
Oracle SID*
Oracle Username*
Oracle Password*
Oracle Port*
1521
Timeout* 30
Table D.49. Oracle::Availability settings
D.9.3. Oracle::Blocking Sessions
The Oracle::Blocking Sessions probe monitors an Oracle instance and collects the following metric:
• Blocking Sessions — The number of sessions preventing other sessions from committing changes
to the Oracle database, as determined by the required
Time Blocking
value you provide. Only those
sessions that have been blocking for this duration, which is measured in seconds, are counted as
blocking sessions.
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 D.50. Oracle::Blocking Sessions settings
D.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 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.