Originally posted by gareth
Hi,

the output from that query is:

NAME VALUE
---------------------------------------------------------------- ---------
sorts (memory) 18091
sorts (disk) 9
sorts (rows) 29094566

thanks
You are doing fine. No need to increase SORT_AREA_SIZE. What to do next.. Well, in SQL*PLUS type SET AUTOTRACE ON, run again the query and post the output.