get sql text for a given hash value.sql

on June 23, 2008 at 12:25 pm
Posted In: Oracle DB and SQL performance analysis (Cat)

— 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