Re: How much RAM is to much

 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