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.

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	E-mail	--
	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

Legend:

--: The setting is always invalid.

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