Appendix C. Probes 173
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 memory 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 provided by you. Only those sessions that have been idle for this duration, which is
measured in seconds, will be counted as idle sessions.
Field Value
Oracle SID*
Oracle Username*
Oracle Password*
Oracle Port* 1521
Time Idle (seconds)* 20
Timeout* 30
Critical Maximum Idle Sessions
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:
