Red Hat NETWORK 4.0 -, Reference Manual

Page: 261 / 290

Appendix C. Probes 245
C.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 — The rate of Oracle sorts that were too large to be completed in mem-
ory and were instead sorted using a temporary segment.
Field Value
Oracle SID*
Oracle Username*
Oracle Password*
Oracle Port*
1521
Timeout* 30
Critical Maximum Disk Sort Ratio
Warning Maximum Disk Sort Ratio
Table C-54. Oracle::Disk Sort Ratio settings
C.9.8. Oracle::Idle Sessions
The Oracle::Idle Sessions probe monitors an Oracle instance and collects the following
metric:
•
Idle Sessions — The number of Oracle sessions that are idle, as determined by the
required Time Idle value you provide. Only those sessions that have been idle for this
duration, which is measured in seconds, are counted as idle sessions.
Field Value
Oracle SID*
Oracle Username*
Oracle Password*
Oracle Port*
1521
Time Idle (seconds)* 20