sizing buffer cache from "scratch"?

From: Fredrik <nospam_at_allowed.localhost>
Date: Mon, 7 Jan 2002 21:41:12 +0100
Message-ID: <Cyn_7.5166$_N.10501@news1.bredband.com>

Hi group!

If we want to take a more scientific approach - just boldly chosing a round figure and watch hit ratio seems somewhat too random... How would you go about when trying to find/estimate a reasonable number of buffers for the db block buffer cache? Is there some "well-practiced" route to identify those bound to be most used blocks?

Maybe I should add that this is from a standpoint with pre-packaged systems that doesn't come with much knowledge of data and sql-code (but instance and/or storage parameters are often default or something worse).

Your replies are most appreciated.
Regards
Fredrik Received on Mon Jan 07 2002 - 14:41:12 CST