Re: So how big is your buffer cache ?

From: Tim Gorman <tim_at_sagelogix.com>
Date: Tue, 31 Aug 2004 05:38:19 -0600
Message-ID: <BD59BF4B.1B6D9%tim@sagelogix.com>

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_at_bigpond.com 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_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 Tue Aug 31 2004 - 06:30:42 CDT