物理读:
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博客 ” ,链接:http://blog.itpub.net/563971/viewspace-626504/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/563971/viewspace-626504/