Re: How much RAM is to much

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:


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

Other related posts: