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_at_yahoo.co.uk> 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