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

[jmodic]

[QUOTE][i]Originally posted by fmedina [/i]
[B]
i think there are too many sorts (disk), the sorts are


sorts (memory) 274045
sorts (disk) 310
[/B][/QUOTE]

I don't think your real problems for disk contention are disk sorts. From the above figures, your ratio of disk_sorts/memory_sorts is 0.1%, which *usually* should not cause obvious performance degradation...

You should check other areas of possible causes of disk contention, mainly physical db_datafiles and redo/arch_log_files layout....

HTH,