Re: Rego generation while executing select statement

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
--
http://www.freelists.org/webpage/oracle-l

Other related posts: