sort_area_size in MTS

[reydp]

what will happen to the memory allocated for the value of sort_area_size when MTS is configured in a server?

[pando]

sort_area_size in MTS is part of SGA in MTS (called UGA)

[reydp]

Originally posted by pando
sort_area_size in MTS is part of SGA in MTS (called UGA)

So since it is no longer part of the PGA and it become part of the SGA, does this means that the value of the sort_area_size will be added to the SGA and it becomes fix? And there will be no subsequent accumulated allocation of sort_area_size(max) each time each user can exhaust with extensive query?

By the way, thus the large_pool_size increases in MTS?


thanks PANDO.