I thought that it might be the case, but the output shows that sorts are in memory. > > 3 sorts (memory) > > 0 sorts (disk) Maybe SQL plus doesn't repors disk sorts correctly. Regards, Alex On Sat, 26 Feb 2005 02:27:23 +0000 (GMT), Connor McDonald <hamcdc@xxxxxxxxxxx> wrote: > You have a "traditional" temporary tablespace (ie datafile not tempfile)? > > If so, the sorting could generating redo > > hth > connor -- //www.freelists.org/webpage/oracle-l