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: Cache Hit Ratio from system views

Re: Cache Hit Ratio from system views

From: Bob Jones <email_at_me.not>
Date: Thu, 16 Aug 2007 22:28:10 -0500
Message-ID: <eB8xi.1326$i75.244@newssvr19.news.prodigy.net>


>> Why is BHCR meaningless? The answer should be short and simple. I want
>> to hear your opinion.
>
> One can not prove a negative.
> Where is your proof BCHR is a reliable indicator of GOOD performance?

BCHR alone does not tell you about overall performance. It simply tell you the disk I/O percentage. It is an indicator, a very meaningful one. Received on Thu Aug 16 2007 - 22:28:10 CDT

Original text of this message

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