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

Other related posts: