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.'