Re: UGA and PGA basic question
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 29 Nov 2005 17:43:00 -0600
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
Other related posts: