Re: very low hit ratio

From: Fred DENIS <fred.denis_at_gmx.net>
Date: Wed, 24 Mar 2004 22:15:36 +0100
Message-ID: <4061fa6f$0$9116$626a14ce@news.free.fr>

Dont care about hit ratio; the questions is "do you have performance problem ?"

Read this : http://www.oradream.com/pdf/LIOs%20vs%20PIOs.pdf and this http://www.oradream.com/pdf/Why%20a%2099%20Cahe%20Hit%20Ratio%20is%20Not%20OK.pdf

Fred

"JW" <jwu_at_nctr.fda.gov> a écrit dans le message de 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 Wed Mar 24 2004 - 15:15:36 CST