Script to show SQL by HASH value in Oracle
The script will show the sql statement text for a given hash value
accept addr prompt 'Hash do Comando => ';
def hash=&&1
col hv noprint
col ln heading 'Line' format 9,999
col text heading 'SQL Statement Text' format A65
start osmtitle
select t.hash_value hv,
t.piece ln,
t.sql_text text
from v$sqlarea a,
v$sqltext t
where a.hash_value = t.hash_value
and a.hash_value = '&hash'
order by 1,2
/
