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 -----------------------------------------------------------------