Re: hit ratio

From: Kenny Gump <kgump_at_mylanlabs.com>
Date: Fri, 26 Mar 1999 12:38:52 -0500
Message-ID: <36fbc5cc.0@news.mountain.net>

Look in the tuning manual about 'lru_extended_statistics' parameter. You can set this and start your database and gather stats over time. Then looking at a table that is populated by the parameter you can determine how many additional hits you will get with each buffer you add.

As far as a hit ratio of .59 if it is a data warehouse with a lot of adhoc queries, that is not bad.

Kenny Gump
OCP 7.3 DBA

---

Stephen wrote in message <7de34g$b5l_at_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 Fri Mar 26 1999 - 11:38:52 CST