Re: How much RAM is to much
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: vit.spinka@xxxxxxxxxxxx
- Date: Wed, 16 Feb 2011 11:08:26 -0600
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@xxxxxxxxxxxx>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@xxxxxxxxxxxxxxxxxx <mailto:RStorey@xxxxxxxxxxxxxxxxxx>> wrote:
>>
>> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
