hit ratio

From: Stephen <poffs_at_tteam.com>
Date: Thu, 25 Mar 1999 14:37:56 -0500
Message-ID: <7de35a$bcu@tuna.eky.com>

Here are my stats:

block_buffers: 10500
shared_pool: 20000000

block_size: 4096

my hit ratio is .59 and should be .9 or greater how much more do i need to add to the block_buffers paramter? Is there a methodology or is it trial and error?

Thanks in advance.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Stephen E. Poff, Database Developer
Technology TEAM, Inc.
5501 Cherokee Ave. 1st Floor
Alexandria, VA 22312-2305
http://www.tteam.com/
Voice: (703) 256-6661 x133
Fax: (703) 256-3810
poffs_at_tteam.com <mailto:poffs_at_tteam.com>
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Received on Thu Mar 25 1999 - 13:37:56 CST