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