— chk_sga_txt.sql
— mdw – look for sql in sga containing the provided txt

set pause on
set pages 36
spool chk_sga_txt
select
first_load_time
,parse_calls prse
,executions  excs
,buffer_gets buffs
,disk_reads   discs
,rows_processed rws
–,address        address
,hash_value     hash_value
,sql_text
from v$sqlarea
–where parsing_schema_id !=’0′
where sql_text like ‘%’||nvl(‘&sql_txt’,’whoops’)||’%’
–order by first_load_time desc
order by (greatest(buffer_gets,1)/greatest(rows_processed,1)) desc
/
spool off