Disk Sorts

Overview

The Disk Sorts alarm monitors the percentage of all sort operations executed on disk using memory and disk I/O operations.

This alarm may occur when only PFM - RM for Oracle is manipulating the Oracle Database and no other applications are running. If this is the case, you can suppress this alarm from occurring by increasing the value of SORT_AREA_SIZE (or the value of SORT_AREA_RETAINED_SIZE, if specified). The guideline for this value is 204,800. After specifying this value, restart the Oracle Database to apply the new setting.

Main settings

Alarm properties in PFM - Web ConsoleSetting
ItemDetailed item
MainProductRM Oracle
Message text%CVS% sorts on disk
Enable alarmSelected
Evaluate all dataNot selected
Monitoring time rangeAlways
Alarm when damping conditions are satisfiedNot selected
Interval--
Maximum occurrences--
ActionsE-mail--
Command--
SNMPAbnormal, Warning, Normal
Conditional ExpressionsRecordSystem Stat Summary Interval (PI)
FieldSort Overflow %
Abnormal conditionSort Overflow % > 15
Warning conditionSort Overflow % > 10
Legend:
--: The setting is always invalid.

Related reports

Reports/RM Oracle/Troubleshooting/Real-Time/Disk Sorts - Top 10 Sessions (5.0)