Oracle捞取系统未采用绑定变量sql的语句

绑定变量目的:减少硬解析，增加sql语句的共享性，避免sql注入，降低数据被盗风险。   

捞取系统未采用绑定变量sql的语句如下:

 

with force_mathces as
 (select l.force_matching_signature mathces,
          max(l.sql_id || l.child_number) max_sql_child,
          dense_rank() over(order by count(*) desc) ranking,count(*) times 
     from v$sql l
    where l.force_matching_signature <> 0
      and l.parsing_schema_name <> 'SYS'
    group by l.force_matching_signature
   having count(*) > 10)
 select v.sql_id, v.sql_text, v.parsing_schema_name, fm.ranking,fm.times
   from force_mathces fm, v$sql v
  where fm.max_sql_child = (v.sql_id || v.child_number)
    and fm.ranking <= 50
  order by fm.ranking;