Xref: alice comp.databases.oracle.server:39549
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.cwix.com!204.238.120.130!news-feeds.jump.net!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail
From: dickca@my-dejanews.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Database without temporary tablespace
Date: Tue, 02 Feb 1999 12:52:41 GMT
Organization: Deja News - The Leader in Internet Discussion
Lines: 14
Message-ID: <796sem$v12$1@nnrp1.dejanews.com>
References: <79044k$gtq$1@guinness.serv.psi.calva.net>
X-Article-Creation-Date: Tue Feb 02 12:52:41 1999 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT)
X-Http-Proxy: 1.0 AMLPROX1, 1.0 x16.dejanews.com:80 (Squid/1.1.22) for client 195.92.129.172

In article <79044k$gtq$1@guinness.serv.psi.calva.net>,
  "jbmorlaATcalva.net" <jbmorla@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