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 Console | Setting | |
---|---|---|
Item | Detailed item | |
Main | Product | RM Oracle |
Message text | %CVS% sorts on disk | |
Enable alarm | Selected | |
Evaluate all data | Not selected | |
Monitoring time range | Always | |
Alarm when damping conditions are satisfied | Not selected | |
Interval | -- | |
Maximum occurrences | -- | |
Actions | -- | |
Command | -- | |
SNMP | Abnormal, Warning, Normal | |
Conditional Expressions | Record | System Stat Summary Interval (PI) |
Field | Sort Overflow % | |
Abnormal condition | Sort Overflow % > 15 | |
Warning condition | Sort Overflow % > 10 |
Related reports
Reports/RM Oracle/Troubleshooting/Real-Time/Disk Sorts - Top 10 Sessions (5.0)