Re: Database without temporary tablespace

From: <dickca_at_my-dejanews.com>
Date: Tue, 02 Feb 1999 12:52:41 GMT
Message-ID: <796sem$v12$1@nnrp1.dejanews.com>

In article <79044k$gtq$1_at_guinness.serv.psi.calva.net>, "jbmorlaATcalva.net" <jbmorla_at_calva.net> wrote:
> Hi
> I just inherited a system without temporary tablespace. So where does oracle
> do all the sorts?
>

Where the sorts take place is dependant on whether you are using MTS or not. In an MTS environment they will take place in the UGA otherwise they will be in the users PGA. If they require more space they will use the users default temp tablespace.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Feb 02 1999 - 06:52:41 CST