Re: Which background process regulates amount of pga memory per session in 10g ? Thanks, rm.

I really don't see the need for a 'manager', as the individual server processes should not be starved - an alternate in some cases is to use TEMP and that can be expensive. Also remember that it's a target, not a limit, so the sum of individual PGA's could grow past the target.

So why couldn't the info be kept in the 'SGA' along side other dynamic V$ info? And under automatic PGA, the remotes (server processes) would basically be watching for opportunity to shrink as possible - start from the 20% of SGA as initial (per manual), grow only when necessary, update the in-memory table and shrink as soon as feasible after checking whether there is a need to shrink. (Supporting this idea - V$PGASTAT)

At least that's the first stab I'd take if it were my code. (Algorithm revision then based on field experience <g>)

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***