抓取关注TopSQL

抓取关注TopSQL

select executions, hash_value, sql_text
  from v$sqlarea
 where hash_value in
       (select distinct hash_value
          from v$sqlarea
         where substr(sql_text, 1, 40) in
               (select substr(sql_text, 1, 40)
                  from v$sqlarea
                having count(*) > 10
                 group by substr(sql_text, 1, 40)))
 order by executions desc;
Trackback

no comment untill now

Add your comment now

切换到手机版