174 Appendix C. Probes
• Allocated Extents — The number of allocated extents for any index.
• Available Extents — The percentage of available extents for any index.
The required Index Name field contains a default value of % that will match any index name.
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
Table C-56. Oracle::Index Extents settings
C.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 — The rate a library cache pin miss occurs. This will happen 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 — The number of pins of objects with previous pins since the object handle was
created that must now retrieve the object from disk.
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
Table C-57. Oracle::Library Cache settings
