Our current sort_area is 64K. When we run a query with order by clause causing it do a sort (by examining TKPROF output), the system runs much slower than without the order by. The funny thing is that it only sorts 1100 items, not much data at all. Is there an easy to verify that my sort area is too small on the fly, so I can change the parameter, or I have to run BSTAT and ESTAT? Same thing with IO?
