查找库中未绑定变量的语句

http://www.askmaclean.com/archives/%e5%88%a9%e7%94%a8force_matching_signature%e6%8d%95%e8%8e%b7%e9%9d%9e%e7%bb%91%e5%ae%9a%e5%8f%98%e9%87%8fsql.html

select a.*,
       (select b.sql_text
          from v$sqlarea b
         where b.sql_id = a.sql_id
           and rownum <= 1) as sql_text,
       (select b.sql_fulltext
          from v$sqlarea b
         where b.sql_id = a.sql_id
           and rownum <= 1) as sql_fulltext
  from (select count(1) as 执行次数, max(sql_id) as sql_id
          from v$sql
         where FORCE_MATCHING_SIGNATURE > 0
           and FORCE_MATCHING_SIGNATURE != EXACT_MATCHING_SIGNATURE
         group by FORCE_MATCHING_SIGNATURE
        having count(1) > 1) a
 order by 1 desc