Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news-hog.berkeley.edu!ucberkeley!tethys.csu.net!nntp.csufresno.edu!sn-xit-03!sn-xit-12!sn-xit-08!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: Max SGA size for 32-bit 9.2.0.6 on Solaris Date: Thu, 07 Jul 2005 20:11:26 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: sybrandb@hccnet.verwijderdit.nl References: <1120644105.203903.325520@g49g2000cwa.googlegroups.com> <1120672557.011985.59310@g49g2000cwa.googlegroups.com> <1120689642.976233.141030@g49g2000cwa.googlegroups.com> <1120755343.406890.297280@g44g2000cwa.googlegroups.com> X-Newsreader: Forte Agent 2.0/32.652 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 12 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:246789 On 7 Jul 2005 09:55:43 -0700, bchorng@yahoo.com wrote: >We standardize all DB buffer cache to 48 GB now. We did not do this >without careful assessments. We collect all statspack and OS data >for before and after comparison. Turst me, if the problem out-weighs >the benefit we wouldn't be doing this. And obviously we never tune our sql-statements. -- Sybrand Bakker, Senior Oracle DBA