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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Cache Hit Ratio?

Re: Cache Hit Ratio?

From: Compaq User <lllacey_at_msn.com>
Date: 1997/08/19
Message-ID: <01bcac76$7fd33dc0$f5cb2399@default>#1/1 









SatarNag <satarnag_at_aol.com> wrote in article 


> Cache Hit Ratio = (1-(Physical Reads/(db block gets = consistent gets)))

 *


> 100

> 

> I know the variables are right, but is that the correct formula?

Hi Satar,


Hit Ratio = 1 – ( physical reads / (db block gets + consistent gets) )



Nevin Hahn


DBA, CU Cancer Center
Received on Tue Aug 19 1997 - 00:00:00 CDT












Original text of this message













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