Re: RE: Hit Ratio

i dont think many people are using bchr anymore. I think its been talked down to death. only place I hear about it is offshore. people still using the old niemic book. his new took all that stuff out.

or am i wrong?
>
> From: "Jesse, Rich" <Rich.Jesse_at_qtiworld.com>
> Date: 2003/12/22 Mon PM 02:14:26 EST
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: RE: Hit Ratio
>
> My BCHR is currently 96.62%. In the past, it was normally over 99%. What
> should I do?
>
> I'll be waiting for Mladen's reply... :)
>
>
> Rich
>
> Rich Jesse System/Database Administrator
> rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA
>
>
> -----Original Message-----
> Sent: Monday, December 22, 2003 10:14 AM
> To: Multiple recipients of list ORACLE-L
>
>
> As a friendly reminder, when debunking myths, I suggest we keep sober and
> never
> go overboard. The recently popular formula to get an arbitrary hit ratio is
> not
> what a database in normal usage naturally gets. Unless a mischievous
> developer
> plays a prank, hit ratios are still useful to some extent in checking
> database
> health, although other indicators such as wait events should be given a
> greater
> weight.
>
> Yong Huang
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <ryan_oracle_at_cox.net
  INET: ryan_oracle_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).