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

Not sure I understand the question ....

My understanding: the PGA is the memory assigned to the server process. In a dedicated connection, the server process is the dedicated process created to handle the user request sent by the user process (such as SQL Plus or an app) and is not a background process. In a 'shared server' config, some of the memory requirements are moved from the PGA to the SGA.

Definition of PGA is in the Concepts manual, in Chapter 8 under "Overview of the Program Global Areas".

Server Process and Background Process definitions in Chapter 9 of Concepts manual.

Setting/tuning the PGA is discussed in the Performance Tuning Guide, in chapter 7 for the 10g.

As far as I can tell, no background process is responsible for regulating the PGA.

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