Red Hat NETWORK SATELLITE SERVER 3.7 Guide d'installation télécharger pdf (Page 122)

Table A.52. Oracle::Client Connectivity sett ings

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

A.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 - T he 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 - T he number of accesses made to the block buffer to retrieve data in a consistent

mode.

Table A.53. Oracle::Data Dictionary Cache set tings

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

A.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 - T he rate of Oracle sorts that were too large to be completed in memory and were

instead sorted using a temporary segment.

Probes

119

1 2 ... 117 118 119 120 121 122 123 124 125 126 127 ... 135 136

Pas de commentaire

Red Hat NETWORK SATELLITE SERVER 3.7 Guide d'installation Page 122