maximum sga size for a given RAM

From: Richard Chen <chenri_at_snet.net>
Date: Wed, 02 May 2001 09:20:21 -0400
Message-ID: <3AF00995.966E46AC@snet.net>

I have the recollection that the size of sga should be no more than one third of the physical RAM. A search on google site also confirms my recollection:

http://groups.google.com/groups?q=oracle+sga+size+guideline+ram&hl=en&lr=&safe=o

ff&rnum=1&ic=1&selm=lpe89tcmemeq3mnta64l5mbfnvj8e8rs45%404ax.com

However, a recent magazine article recommends that 60% of physical RAM should be devoted to sga:

http://www.sysadminmag.com/current/0105b/0105b.htm

Does oracle8 changed things so that sga can be twice as large as before? Anyone know authoritive references on this?

Thanks for any info.

Richard Received on Wed May 02 2001 - 08:20:21 CDT