识别低效的语句
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;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/47696/viewspace-671793/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
oracle 10g 归档日志清除
请登录后发表评论
登录
全部评论
