select d.plan_hash_value plan_hash_value, d.execnt execnt, a.hash_value hash_value, a.sql_text sql_text from v$sqltext a, (select plan_hash_value, hash_value, execnt from (select c.plan_hash_value, b.hash_value, c.execnt, rank() over(partition by c.plan_hash_value order by b.hash_value) as hashrank from v$sql b, (select count(*) as execnt, plan_hash_value from v$sql where plan_hash_value <> 0 group by plan_hash_value having count(*) > 10 order by count(*) desc) c where b.plan_hash_value = c.plan_hash_value group by c.plan_hash_value, b.hash_value, c.execnt) where hashrank <= 3) d where a.hash_value = d.hash_value order by d.execnt desc, a.hash_value, a.piece
查看shared_pool中未使用绑定变量的语句
作者:czjie
出处:http://www.cnblogs.com/czjie/
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。