Set auto extend off for all of your temporary tablespace datafiles. And use fixed but large maxextent value. And please provide few more details like total memory of server, OS etc.. It looks like you are having problems with paging.. Reduce your sort area size and set your sort_area_retained_size as "0" . Please get back with more details...