Re: sort area and temp in 9i

Hi Howard,

I think Michael is asking what to set the uniform size if you set a pga aggregate target (and hence don't actually set a sort_area_size).

The standard sort_area_size should influence the size of the uniform size in the temp tablespace but I strongly doubt Oracle will do this the other way around.

It's a good question and one for which I don't have an immediate answer, although I'm working on it ...

Cheers

Richard
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:3d6e7b5b_at_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 - 20:29:44 CDT