Re: Memory Allocations

"Brian Peasland" <dba_at_nospam.peasland.net> wrote in message news:46e744d7$0$15142$88260bb3_at_free.teranews.com...
> Dereck L. Dietz wrote:
>> I was told by someone that the general rule of thumb for the initial
>> memory allocation in an Oracle instance was something like 40% for the
>> SGA and 60% for the PGA.
>>
>> Anybody willing to comment on how accurate/inaccurate that statement was?
>>
>> Thanks.
>
> Personally, I've never used that rule of thumb. The sizes of the PGA and
> SGA should be determined by your application and data usage patterns. Your
> application and the way your users access the data may denote that a 2GB
> SGA is appropriate. Servers with 4GB, 8GB, and 16GB of physical memory
> (RAM) would arrive at entirely different estimates for the SGA using this
> 40% rule.
>
> You can use rules of thumb similar to these as a starting point. But I
> would expect that in short order, you would need to adjust your SGA and
> PGA.
>
> If you sized your instance by the rules you stated, 100% of the server's
> physical memory would be tied up with just the Oracle instance!
>
>
> HTH,
> Brian
>
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_nospam.peasland.net
> http://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
>
> --
> Posted via a free Usenet account from http://www.teranews.com
>

Thanks. I realize it's just a starting point. Also, it's not for all the server's memory - just the amount of memory which is going to be allocated to the Oracle instance. Received on Wed Sep 12 2007 - 18:10:14 CDT