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

I believe that it is CKPT that deals with co-coordinating PGA memory across sessions.

Individual sessions display their current workareas in v$sql_workarea_active, and processes display their PGA usage in v$process. These figures allow the background process to calculate values for V$pgastat, updating it every three seconds.

One of the critical values in v$pgastat is the global memory bound (which starts life at _smm_max_size) that restricts the size of a single workarea in a session - and this is the figure that a session checks to restrict its memory demand at various stages in the lifetime of a workarea operation.

-- 
Regards

Jonathan Lewis

Now waiting on the publishers:    Cost Based Oracle - Volume 1

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

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 8th July 2005







<Ranko.Mosic_at_gmail.com> wrote in message 
news:1125863313.629287.193090_at_g47g2000cwa.googlegroups.com...


> thanks, rm.

>