Wow, 30 GB plus!?!?! Well, we don't have any SGAs that currently break the 4GB barrrier. Our platform is 32-bit Oracle on Solaris. As we are moving to 9i, we are going to 64-bit Oracle, and may be judiciously increasing the SGA sizes. We are big believers in KEEP, RECYCLE, and DEFAULT buffer pools which definitely help make the most of the buffer cache. Our largest system currently runs on a 6800, configured with 8 CPUs and 12 GB of RAM in the primary domain. PGAs account for about 7.5GB, the total SGA is about 2.5GB, of which the buffer cache is 2GB. -Mark -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Richard Foote Sent: Sat 8/28/2004 7:56 AM To: oracle-l@xxxxxxxxxxxxx Cc: Subject: So how big is your buffer cache ? Hi All, In an interesting insight into how Don Burleson performs tuning at the c.d.o.s newsgroup (http://groups.google.com/groups?dq=&hl=en&lr=&ie=UTF-8&th=73f606eef5e7e99f) . Don suggests he has "no problem throwing hardware at crappy code when the client doesn't want to tune it". He's also basically recommending using AWE and utilising all available RAM on 32bit windows, whether you need to or not. I mean, AWE has no disadvantages right ... :) However, he also makes the claim that "It's not uncommon to see working sets of frequently-referenced data of for than 30-gig for a large database. AWE is a great techniques for 32-bit Windows databases and I do it for dozens of databases every year, ALWAYS with great results." So my question to you all is how large are your largest buffer caches ? How many of you have a buffer cache that is 30G+ ? And on 32bit windows ? Love to know !! Cheers Richard ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- -- Binary/unsupported file stripped by Ecartis -- -- Type: application/ms-tnef -- File: winmail.dat ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------