Disk Sorts
- Organization of this page
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 - Agent 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 Information |
Product |
Oracle(9.2) |
Alarm message |
%CVS% sorts on disk |
|
Enable alarm |
Selected |
|
Alarm notification |
Notify when the state changed |
|
Notification target |
State changes for the alarm |
|
Evaluate all data |
Not selected |
|
Monitoring time range |
Always |
|
Report alarm when the following damping condition is reached |
Not selected |
|
occurrence(s) during |
-- |
|
interval(s) |
-- |
|
Alarm Conditions |
Record |
System Stat Summary Interval (PI) |
Field |
Sort Overflow % |
|
Abnormal condition |
Sort Overflow % > 15 |
|
Warning condition |
Sort Overflow % > 10 |
|
Actions |
|
-- |
Command |
-- |
|
SNMP |
Abnormal, Warning, Normal |
- Legend:
-
--: The setting is always invalid.
Related reports
Reports/Oracle/Troubleshooting/Real-Time/Disk Sorts - Top 10 Sessions (9.1)