-
sql hash value in statspack
DBAs,
If I know the hash value for a query from the statspack report,
is there any way to know the actual execution plans for the queries?
I mean: don't run the query again.
(I know we can query the sql text from the v$sqlarea using the hash value to get the full query and run it again.)
Thanks!
-
Run sprepsql.sql and enter the snapid and hash value.
Assistance is Futile...
-
Thank you very much!
It works as what I need.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|