物理读：
select disk_reads,executions,disk_reads/(executions+0.01),sql_text from v$sql
where disk_reads/(executions+0.01)>1000 order by disk_reads desc;
逻辑读：
select buffer_gets,executions,buffer_gets/(executions+0.01),sql_text from v$sql
where buffer_gets/(executions+0.01)>1000 order by buffer_gets desc;
select disk_reads,executions,disk_reads/(executions+0.01),sql_text from v$sql
where disk_reads/(executions+0.01)>1000 order by disk_reads desc;
逻辑读：
select buffer_gets,executions,buffer_gets/(executions+0.01),sql_text from v$sql
where buffer_gets/(executions+0.01)>1000 order by buffer_gets desc;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/563971/viewspace-626504/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
