Re: sort area and temp in 9i

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Fri, 30 Aug 2002 05:52:57 +1000
Message-ID: <3d6e7b5b@dnews.tpgi.com.au>

Michael Streeton wrote:

> In 9i it seems better to have a LMT temp tablespace. When specifying a pga
> target aggregate size, is it possible to influence the sort area size by
> setting the temp tablespace to a uniform extent allocation or does it not
> matter.
>
> Many Thanks
>
> Mike

Temporary tablespaces should *always* be uniform size.

create temporary tablespace blah tempfile 'blah01.dbf' size 75m extent management local
uniform size 64k (or whatever your sort_area_size is set to).

Nothing wrong with the above, and everything right. Autoallocated temporary tablespace is a disaster.

Regards
HJR Received on Thu Aug 29 2002 - 14:52:57 CDT