Skip to Content
Former Member
Apr 22, 2008 at 12:53 PM

Estimate cache displacement - optimum size of CACHE_SIZE


Is there a way to determine out of the statistics data in the dbanalyzer what would be the optimum cache size for the database?

I want to know that because we plan to buy a new box and I want to size it so the actual "daily used data" is in the cache -> no (or few) User-UKTs doing reading I/O. So basically building something like an "in memory database".