Re: How much RAM is to much

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 16 Feb 2011 11:08:26 -0600
Message-ID: <AANLkTin15nEv=7xg5o0P0GimfwvJA_Ui+WAZPHcgit9U_at_mail.gmail.com>

At one point, I had found that somewhere between 4 and 8g per cpu/core was a fairly comfortable number. Haven't really done any further research to determine if that was valid. Even then, that was an observation on a fairly limited number of servers, so it may not have been valid universally then.

On Wed, Feb 16, 2011 at 10:51 AM, Vit Spinka <vit.spinka_at_vitspinka.cz>wrote:

> Hi,
>
> From another point of view, a curious question:
> Is there any absolute value that one should not go over? E.g. if I have
> 256GB in my Oracle-dedicated server, will Oracle effectively manage an SGA
> of 192GB?
> Keeping in mind size of shared pool allocations and db blocks - won't all
> the housekeeping of such vast number of structures negatively impact the
> performance?
>
> Vit
>
> Dne 14.2.2011 14:53, Subodh Deshpande napsal(a):
>
>> Robert,
>> somewhere 15 gb comes to 60%+ of your total 24Gb of memory, I think it
>> is comfortable value one..default installation of oracle takes 60-80% of
>> total memory available..
>> and if you are sure that your database can work well with present values
>> (i.e. 3gig and 500 mb or may be some plus increment to it..) then how
>> about exploring times ten database..
>> http://en.wikipedia.org/wiki/TimesTen
>> thanks..subodh
>> On 14 February 2011 18:55, Storey, Robert (DCSO)
>> <RStorey_at_dcso.nashville.org <mailto:RStorey_at_dcso.nashville.org>> wrote:
>>
>> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 16 2011 - 11:08:26 CST