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 -> Re: very low hit ratio

Re: very low hit ratio

From: Carl Kayser <kayser_c_at_bls.gov>
Date: Fri, 16 Apr 2004 08:55:53 -0400
Message-ID: <c5ol4r$b39$1@blsnews.bls.gov>


I don't know about DW (and I'm primarily a Sybase DBA) but 90% hit ratio means a 10% miss ratio which I do not consider to be good. Consider chapter 7 of Alan Packers book which is available (along with the TOC) online at

http://www.amazon.com/gp/reader/0130834173/ref=sib_dp_rdr/104-8369762-3779959#reader-page

"Harry Sheng" <harrysheng00_at_hotmail.com> wrote in message news:AUK9c.5955$1A6.273669_at_news20.bellglobal.com...
> I get a data buffer hit ratio of more than 90%. The users still yell at me
> that the database is not responding !
> So it really depends. If your users do not yell at you, forget about the
> hit-ratio and have a good sleep.
>
> "JW" <jwu_at_nctr.fda.gov> wrote in message
> news:f4d9400.0403241310.150b1fb4_at_posting.google.com...
> > we have a data warehouse type of database and I noticed that buffer
> > cache hit ratio is very low: db block gets 37,173,962; consistent gets
> > 349,994,093; physical reads 888,341,652. Is this normal in a
> > datawarehouse environment? Thanks.
>
>
Received on Fri Apr 16 2004 - 07:55:53 CDT

Original text of this message

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