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.)