Re: individual query hit ratio

From: Anna C. Dent <anacdent_at_hotmail.com>
Date: Thu, 27 Nov 2003 05:52:01 -0800
Message-ID: <0knxb.33861$kl6.2182@fed1read03>

Robert wrote:

> Hi,
>
> If I would like to compute hit ratio for individual query by quering
> v$sqlarea, is this query good?
>
> select ( 1 - DISK_READS / (BUFFER_GETS + DISK_READS+0.0001) ) * 100,
> ROWS_PROCESSED, EXECUTIONS, ELAPSED_TIME, SQL_TEXT from v$sqlarea;

What is an acceptable answer for the above query & why is that value deemed correct/acceptable?

It depends.

"Good" is a relative term.

BCHR is a meaningless indicator of performance/reality.

An alternative measure would be number of sun spots per day. Received on Thu Nov 27 2003 - 07:52:01 CST