Skip to content

Instantly share code, notes, and snippets.

@dotmaik1

dotmaik1/admin: hashsql.sql

Created October 6, 2016 16:32
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dotmaik1/7ca7aefe2b179e18f29d832b414c7198 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dotmaik1/7ca7aefe2b179e18f29d832b414c7198 to your computer and use it in GitHub Desktop.
Download ZIP
It gets the query that was issue by Hash Value
Raw
admin: hashsql.sql
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment