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

Home -> Community -> Usenet -> c.d.o.server -> DB Buffer Cache Size

DB Buffer Cache Size

From: ImPrecise <f_puhan_at_precise.com>
Date: Fri, 20 Aug 2004 13:43:34 -0400
Message-ID: <f_puhan-3F030B.13433420082004@news101.his.com>


This is a silly question.

Is there a point where the DB Buffer Cache can be sized too large? One of the Oracle "luminaries" (who will remain nameless in this post) I used to speak with was somewhat adamant that proper SQL tuning, data placement, and SGA tuning would thus result in a reduction in the size of the data cache. He would maintain that Oracle9i's new features (such as PGA_AGGREGATE_TARGET, WORKAREA_SIZE_POLICY, V$DB_CACHE_ADVICE, an entire Oracle SGA can be kept to a minimum, workable size.

Okay, maybe I am simplifying the case a bit. What got me to thinking about this was the way a customer had his instance configured. This was an Oracle 8.1.7.4 database, with over 5 terabytes of online storage. The SGA had been configured with several gigabytes of data cache. As I understand it, this is a financial system, not OLTP. I was just wondering if perhaps the database had been OVER-sized due to the perception that so much data would be better handled by a large buffer cache.

I am interested in hearing experts' opinions pro or con or otherwise on this question. TIA.

Fred

-- 
The underscore character does not belong in my address. You know the drill...
***
Anyone sufficiently smart enough to configure and use USEnet for research should
be smart enough to Read The Freakin' Documentation!
Received on Fri Aug 20 2004 - 12:43:34 CDT

Original text of this message

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