RE: UGA and PGA basic question

Thanks for that update Tanel.  I know you've written a bit on the subject of 
realfree heap management before.  Now, I just need to digest and understand it 
all. ;-)

So, follow-up question:  If realfree heap management is being used, does this 
imply that the DBMS_SESSION.FREE_UNUSED_USER_MEMORY call will have an effect in 
dedicated server?  (Since the UGA is a top-level heap and not a subheap of the 
PGA?)

-Mark

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Tanel Põder
Sent: Tuesday, November 29, 2005 6:43 PM
To: ORACLE-L
Subject: Re: UGA and PGA basic question

Database & Oracle Reports 10g - passing large param listsHi,

> If the server is dedicated, the UGA is a sub-heap of the PGA.

If realfree heap management is used (starting from 9i, used if 
_use_realfree_heap is true), then UGA heap is actually a top-level heap, 
allocated directly from OS. That allows Oracle to free UGA memory back to OS 
when the session is closed, but connection (server process) remains active.

But the fact that with dedicated server, UGA is accessible only for the 
allocating process, remains the same (which, again, might be different if using 
_use_ism_for_pga parameter in Solaris ;)

Tanel.

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Other related posts: