Re: DB Buffer Cache Size

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sat, 21 Aug 2004 22:00:03 +0100
Message-ID: <4127b7c9$0$20250$cc9e4d1f@news-text.dial.pipex.com>

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:412753cb$0$25143$afc38c87_at_news.optusnet.com.au...

> Maybe when you have 100GB of RAM to throw at your caches (and a disk
> subsystem to match) you can afford it. Most people can't.

Arguable I'd say, given the overhead that this would generate. I'm not at all sure that allocating that RAM to PGA might not be more appropriate for most apps that deal with stupidly large datasets

> > db_cache_size = 4000M
> > db_recycle_cache_size = 500M
> > db_8k_cache_size = 200M
> > db_16k_cache_size = 4056M
> > db_2k_cache_size = 35430M

The sum of the above is 44186M or 43.1G. I'm almost sure that this is 1.1gb too much.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

Received on Sat Aug 21 2004 - 16:00:03 CDT