识别低效执行的SQL语句

点击(此处)折叠或打开

1. --识别低效的SQL语句
   
2. SELECT executions, disk_reads, buffer_gets,
   
3. ROUND((buffer_gets-disk_reads)/buffer_gets, 2) hit_ration,
   
4. ROUND(disk_reads/executions, 2) READS_per_run, SQL_text
   
5. FROM v$sqlarea
   
6. WHERE executions > 0 AND buffer_gets > 0 AND (buffer_gets -disk_reads)/buffer_gets < 0.8
   
7. AND parsing_schema_name = \'SCOTT\'
   
8. ORDER BY 4 DESC;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1070478/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17013648/viewspace-1070478/