UGA and PGA basic question

Hi,  

This is with reference to 10g on solaris 10.

It is clear from the documentation that in Shared Server mode UGA is part of the SGA and in dedicated mode it is in PGA.

1. if we are using workarea=auto and pga_aggregate_target is set In Dedicated mode since UGA is part of PGA all the sorting, hashing will come from PGA area, but if we are using Shared server do sorting, hashing still comes from PGA or since now UGA is part of SGA it comes from SGA?
2. if we are using workarea=manual and sort_area_size and hash_area_size is set Do these areas belongs to the UGA or PGA?

Thanks
--Harvinder
     

--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 29 2005 - 16:25:18 CST