individual query hit ratio

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;

Thanks in advance
Robert Received on Thu Nov 27 2003 - 06:03:59 CST