Re: pga_aggregate_target plus sort_area_size set in init.ora

Good point - big memory allocations for shared servers are outside the scope of pga_aggregate_target because some components of the memory have to be in the UGA, which is kept in the SGA.

I think it's still true for 9.2 - by the way. Haven't thought about checking it for 10.1 yet.

-- 
Regards

Jonathan Lewis

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

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st


"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
news:40E2C7F9.4C0F_at_yahoo.com...


> Jonathan Lewis wrote:




>

> Can't remember if its 9.0 or 9.2, but I think one or both of those

> versions doesn't support pga_agg_ for shared server and thus falls back

> to s_a_s et al.

>

> hth

> connor

> -- 

> Connor McDonald