| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Hit Ratio
My BCHR is currently 96.62%. In the past, it was normally over 99%. What
should I do?
I'll be waiting for Mladen's reply... :)
Rich
Rich Jesse System/Database Administrator rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA
-----Original Message-----
Sent: Monday, December 22, 2003 10:14 AM
To: Multiple recipients of list ORACLE-L
As a friendly reminder, when debunking myths, I suggest we keep sober and
never
go overboard. The recently popular formula to get an arbitrary hit ratio is
not
what a database in normal usage naturally gets. Unless a mischievous
developer
plays a prank, hit ratios are still useful to some extent in checking
database
health, although other indicators such as wait events should be given a
greater
weight.
Yong Huang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
INET: Rich.Jesse_at_qtiworld.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Dec 22 2003 - 13:14:26 CST
 |
 |