sql hash value in statspack

[Lily_Liu_2004]

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!

[waitecj]

Run sprepsql.sql and enter the snapid and hash value.

[Lily_Liu_2004]

Thank you very much!
It works as what I need.