Monitor the sorts in memory vs disk. Try to keep the disk/memory ratio to less than 1

[JDoyle]

SELECT N.NAME, S.STATISTIC#, S.SID, S.VALUE FROM V$STATNAME N, V$SESSTAT S WHERE
N.STATISTIC# IN(SELECT STATISTIC# FROM V$STATNAME WHERE NAME LIKE 'sort%') AND
S.STATISTIC#=N.STATISTIC#;