Table stored historic HASH_VALUE?

[sumit]

Good Afternoon,

I got a sql_id from awr which is 8 days old. I need to know the hash value for that sql_id.

with the help of "awrsqrpt" I could see the hash_value but would like to know is which Dictionary TABLE oracle stores that value?

So that, hHow to get the hash_value without running awrsqrpt?


Regards

[vnktummala]

have you tried in v$sql or v$sqlarea views??

Thanks,

[sumit]

Alright,

I believe Oracle use DBA_HIST_SQLSTAT & DBA_HIST_SQLTEXT ... the first one has snap_id and both can be joined through sql_id

Regards

[vnktummala]

Thanks for the update Sumit. Have you tried with those DBA_ views and find the hash value that you are looking for?

Thanks,