Installation guide

Table A.56. Oracle::Index Extents settings
Field Value
Oracle SID*
Oracle Username*
Oracle Password*
Oracle Port* 1521
Index Owner* %
Index Name* %
Timeout* 30
Critical Maximum of Allocated Extents
Warning Maximum of Allocated Extents
Critical Maximum of Available Extents
Warning Maximum of Available Extents
A.9.10. Oracle::Library Cache
The Oracle::Library Cache probe computes the Library Cache Miss Ratio so as to optimize the
SHARED_POOL_SIZE in init.ora. It collects the following metrics:
Library Cache Miss Ratio - T he rate at which a library cache pin miss occurs. T his happens when a
session executes a statement that it has already parsed but finds that the statement is no longer in
the shared pool.
Executions - The number of times a pin was requested for objects of this namespace.
Cache Misses - T he number of pins that must now retrieve the object of the disk. T hese pins are
made up of objects with previous pins from the time the object handle was created.
Table A.57. Oracle::Library Cache settings
Field Value
Oracle SID*
Oracle Username*
Oracle Password*
Oracle Port* 1521
Timeout* 30
Critical Maximum Library Cache Miss Ratio
Warning Maximum Library Cache Miss Ratio
A.9.11. Oracle::Locks
The Oracle::Locks probe monitors an Oracle database instance and collects the following metric:
Active Locks - The current number of active locks as determined by the value in the v$locks table.
Database administrators should be aware of high numbers of locks present in a database instance.
Locks are used so that multiple users or processes updating the same data in the database do not
conflict. T his probe is useful for alerting database administrators when a high number of locks are
present in a given instance.
Probes
121