Re: Dynamic SGA and pinned

andre_at_xxx.mail.ee wrote:

> Howard J. Rogers wrote:
>

>>>> from the total pool of available physical RAM, and hence that RAM is 
>>>> not
>>>> available for any other programs running on that server to make use of.
>>>
>>>
>>> In other words, the whole "dynamic" thing is pointless. It's like making
>>> a bowl of cereal and then having half of the bowl covered , so you don't
>>> see it. An exercise in futility.
>>
>>
>>
>>
>> Well, as I said... it's entirely true that the SGA is not actually 
>> dynamic.
>> But the feature that they call 'dynamic SGA' (ie, the ability to 
>> dynamically
>> resize the various pools within the SGA) is not to be sniffed at, and I
>> wouldn't call it futile.
>>

If Howard says it is true ... I'd bet hard cash it is.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)