Re: Rego generation while executing select statement

  • From: Alexander Gorbachev <gorbyx@xxxxxxxxx>
  • To: hamcdc@xxxxxxxxxxx
  • Date: Sat, 26 Feb 2005 16:49:36 +0100

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

Other related posts: