SELECT
EXECUTIONS,
DISK_READS,
BUFFER_GETS,
ROUND((BUFFER_GETS – DISK_READS) / BUFFER_GETS, 2) Hit_radio,
&oracle账号nbsp;
ROUND(DISK_READS / EXECUTIONS, 2) Reads_per_run,
SQL_TEXT
FROM V$SQLAREA
WHERE EXECUTIONS > 0 AND BUFFER_GETS > 0 AND (BUFFER_GETS – DISK_READS) / BUFFER_GETS < 0.8
ORDER BY 2 DESC;
摘自 sxdtzhp的专栏