Re: sort area and temp in 9i

When using workarea_size_policy = auto, the maximum fraction of the pga_aggregate_target that a single process can use is 5% of the target, so perhaps that (5%) is the most appropriate size.

Of course, since pga_aggregate_target does apply to shared servers (at least according to the documents, I haven't confirmed exactly what that means) you may want to stick with the old rule of thumb if you are heavily reliant on shared servers (o.k.a. MTS)

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
 UK  Sept, Nov
 USA x 2  November

http://www.jlcomp.demon.co.uk/seminar.html







Howard J. Rogers wrote in message
<338c9.20191$g9.60952_at_newsfeeds.bigpond.com>...
Richard Foote wrote:



> 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 ...

>



Ah. Now I see the point (thanks for that!), and my apologies to the
original poster. I don't have a good suggestion either, other than perhaps
to set the uniform size to the pga_aggregate_target itself.

It is possible, though, that this is one place where autoallocate might be
a good idea.

Regards
HJR