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
查找库中未绑定变量的语句
最新推荐文章于 2024-06-08 08:16:40 发布