Red Hat NETWORK SATELLITE 5.1.1 - RELEASE NOTES, Reference Manual

Page: 246 / 268

Appendix C. Probes
234
Field Value
Warning Maximum Idle Sessions
Table C.55. Oracle::Idle Sessions settings
C.9.9. Oracle::Index Extents
The Oracle::Index Extents probe monitors an Oracle instance and collects the following metric:
• 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 matches 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 at which a library cache pin miss occurs. This 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 — 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