Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: So how big is your buffer cache ?

Re: So how big is your buffer cache ?

From: Fuad Arshad <fuadar_at_yahoo.com>
Date: Sat, 28 Aug 2004 07:22:01 -0700 (PDT)
Message-ID: <20040828142201.44802.qmail@web80503.mail.yahoo.com>


one i'd never use 2 bit windows in a production env. second 30g cache is i think way to large even for crappy cooe i'd think that a 30g cache would be abottle nect itslef sine the system has to sequentially scan the cache everytime. Richard Foote <richard.foote_at_bigpond.com> wrote: 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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Sat Aug 28 2004 - 09:17:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US