识别低效的语句
- 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
- ORDER BY 4 DESC;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/47696/viewspace-671793/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/47696/viewspace-671793/