RE: UGA and PGA basic question
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <tanel.poder.003@xxxxxxx>
- Date: Wed, 30 Nov 2005 10:33:39 -0500
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
