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
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- Re: Rego generation while executing select statement
- From: Tanel Põder
- References:
- Rego generation while executing select statement
- From: Sami Seerangan
- Re: Rego generation while executing select statement
- From: Connor McDonald
Other related posts:
- » Rego generation while executing select statement
- » Re: Rego generation while executing select statement
- » Re: Rego generation while executing select statement
- » Re: Rego generation while executing select statement
- » Re: Rego generation while executing select statement
- » Re: Rego generation while executing select statement
- Re: Rego generation while executing select statement
- From: Tanel Põder
- Rego generation while executing select statement
- From: Sami Seerangan
- Re: Rego generation while executing select statement
- From: Connor McDonald