Ok, thank you, I have the book of TKyte, but not yet read, and the basic
are far...
"EscVector" <Junk_at_webthere.com> a écrit dans le message de news:
1168957969.286282.107450_at_q2g2000cwa.googlegroups.com...
>
> 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 - 16:06:42 CST
