select to_char(FORCE_MATCHING_SIGNATURE), count(1)
from v$sql
where FORCE_MATCHING_SIGNATURE > 0
and FORCE_MATCHING_SIGNATURE != EXACT_MATCHING_SIGNATURE
group by FORCE_MATCHING_SIGNATURE
having count(1) > &a
order by 2 desc;
参考maclean文章: 利用FORCE_MATCHING_SIGNATURE捕获非绑定变量SQL
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15747463/viewspace-756366/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15747463/viewspace-756366/