The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 |
Newsgroups: comp.databases.oracle.server
From: "Harry Sheng" <harryshen...@hotmail.com>
Date: Sun, 28 Mar 2004 20:23:53 -0500
Local: Sun, Mar 28 2004 8:23 pm
Subject: Re: very low hit ratio
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. news:f4d9400.0403241310.150b1fb4@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. You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||