识别'低效执行'的SQL语句

以下SQL语句根据Oracle提供的内部SQL区域表,编写出识别SQL语句执行低效的查询语句:

 

SELECT EXECUTIONS , DISK_READS, BUFFER_GETS, 
ROUND((BUFFER_GETS-DISK_READS)/BUFFER_GETS,2) Hit_radio, 
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 4 DESC;

 

posted @ 2018-04-13 16:22  MorePrograms  阅读(462)  评论(0编辑  收藏  举报