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 Sun Mar 28 2004 - 19:23:53 CST
