— get_text.sql
— get the sqltext for a stated hash_value (which may or may not be
— unique)
set pages 42
set pause on
set trim on
spool get_text.lst
select sql_text
from v$sqltext
where hash_value = ‘&hash_val’
order by address,piece
/
spool off