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