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

Mladen Gogala <gogala_at_sbcglobal.net> wrote:
> On Mon, 05 Sep 2005 02:39:15 +0000, HansF wrote:
>
> > So why couldn't the info be kept in the 'SGA' along side other dynamic
> > V$ info?
>
> Because there is need to wake up processes. Namely, if a process is
> sleeping, he's not actively reading SGA and if it has allocated memory
> that is needed, the process must shrink.

Wouldn't the process have relinquished unneeded memory before going to sleep?

> The process is in the sleep
> state, so it doesn't know that it needs to relinquish memory. There must
> be some kind of "conductor" which will send a signal and wake it up in
> order to free memory.

Since most systems don't allow allocated memory to be returned to the system until the process ends, do dedicated process relinquish memory simply by promising not use it, in the hopes that the VM system will do the right thing?

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB