点击(此处)折叠或打开

--识别低效的SQL语句
SELECT executions, disk_reads, buffer_gets,
ROUND((buffer_gets-disk_reads)/buffer_gets, 2) hit_ration,
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
AND parsing_schema_name = \'SCOTT\'
ORDER BY 4 DESC;

ITPub博客

识别低效执行的SQL语句