Saturday, 27 June 2015

To find HashSql of SQL statment By using SID

set verify off
accept trgthash number default 0 prompt 'What is the SQL Hash Value : '
select t.sql_text
from v$sqltext_with_newlines t
where t.hash_value + 0 = &trgthash
and &trgthash != 0
order by t.piece;

No comments:

Post a Comment