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 ValueOracle SID*Oracle Username*Oracle Password*Oracle Port* 1521Index Owner* %Index Name* %Timeout* 30Critical Maximum of Allocated ExtentsWarning Maximum of Allocated ExtentsCritical Maximum of Available ExtentsWarning Maximum of Available ExtentsTable C-56. Oracle::Index Extents settingsC.9.10. Oracle::Library CacheThe Oracle::Library Cache probe computes the Library Cache Miss Ratio so as to optimize theSHARED_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 asession executes a statement that it has already parsed but finds that the statement is no longer inthe 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 wascreated that must now retrieve the object from disk.Field ValueOracle SID*Oracle Username*Oracle Password*Oracle Port* 1521Timeout* 30Critical Maximum Library Cache Miss RatioWarning Maximum Library Cache Miss RatioTable C-57. Oracle::Library Cache settings
