Re: sga_max_size

Sylvestre wrote:
> Hello
>
> I read in a previous post about memory that sga_max_size include pga,
> I think it is wrong in dedicated server mode, anyone can confirm ?
>
> Thank you

"each process must be allocated pga, which is upper bounded by by sga_max_size, "

This was in reference to shared server... Wasn't clear in the post and should have said UGA not PGA. Sorry!

PGA and UGA are the same with dedicated and separate in shared. UGA is bounded by SGA when shared.
Automatic PGA settings work for shared in 10g and not in 9i.

See:
Chapter 4, Memory Structures, Expert Oracle Database Architecture, tkyte.. Page 130 has a good example of how this is bounded... or not... Received on Tue Jan 16 2007 - 08:32:51 CST