look for sql in the sga containing the provided text.sql
— 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
Discussion ¬