literal Sql Check

메모리 공유가 안되고 있는 리터럴 SQL 확인

 

 

select substr(sql_text, 1, 40) "SQL",
      count(*) cnt,
      sum(executions) "TotExecs",
      sum(sharable_mem) mem,
      min(first_load_time) start_time,
      max(first_load_time) end_time,
      max(hash_value) hash
from v$sqlarea where executions < 2
group by substr(sql_text, 1, 40)
having count(*) > 20
order by 3 desc, 1, 2 ;