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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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