Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> hit ratio

hit ratio

From: Stephen <poffs_at_tteam.com>
Date: Thu, 25 Mar 1999 14:37:35 -0500
Message-ID: <7de34g$b5l@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:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US