i have a disk contention, the ratios in the database as well, but a physical disk is 100% busy, sqlplus send me a next message
Monitor the sorts in memory vs disk. Try to keep the disk/memory ratio to less than .10 by increasin
i think there are too many sorts (disk), the sorts are
sorts (memory) 274045
sorts (disk) 310
how can i detect wich user is doing the sorts.
the next step is increse the parameters SORT_AREA_SIZE.