Re: So how big is your buffer cache ?

  • From: Tim Gorman <tim@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 31 Aug 2004 05:38:19 -0600

DW with 16G Buffer Cache on Sol8 E15K with 36 CPUs and 144Gb RAM.  DBAs
wanted it even though nothing called for it;  doesn't seem to have hurt
anything, though I can't say it's helped much either.  Partitioning and
indexing has been *much* more useful for reducing I/O.  Just like any other
DW.  We did it just because we had 144Gb of RAM to use up;  we've still
never been able to use more than 50Gb or so total...

Thank you so much, Jared.  Welcome back, Steve!



on 8/31/04 3:14 AM, Richard Foote at richard.foote@xxxxxxxxxxx wrote:

> Hi Jared,
> 
> No worries, thanks for the follow-up, it's very much appreciated.
> 
> Again, thank you for all your efforts on this list, it's been much
> appreciated by all.
> 
> In answer to my specific question, the largest buffer cache anyone has
> admitted to so far is 10G. Thanks to all who responded.
> 
> 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
-----------------------------------------------------------------

Other related posts: