Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find sql query using hash value

904735Mar 29 2012 — edited Apr 16 2013

Hi,

DBVERSION: 9.2.0.8

I generated statspack report and i want to see total query and i have hash_value here.

in v$sql am not able to see all the querys ...pls suggest me other ways..

Thanks,
Srini...

This post has been answered by Aman.... on Mar 29 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 14 2013

Added on Mar 29 2012

#11g, #general-database-discussions

10 comments

10,432 views