Red Hat NETWORK SATELLITE 5.1.0 - CHANNEL MANAGEMENT, Справочное руководство

Страница: 274 / 300

Table C.52. Oracle::Client Connectivity settings
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.
Field Value
Oracle SID*
Oracle Username*
Oracle Password*
Oracle Port* 1521
Timeout* 30
Warning Minimum Data Dictionary Hit Ratio
Critical Minimum Data Dictionary Hit Ratio
Table C.53. Oracle::Data Dictionary Cache settings
9.7. Oracle::Disk Sort Ratio
The Oracle::Disk Sort Ratio probe monitors an Oracle database instance and collects the
following metric:
• Disk Sort Ratio — The rate of Oracle sorts that were too large to be completed in memory
and were instead sorted using a temporary segment.
Field Value
Oracle SID*
Oracle Username*
Appendix C. Probes
260