How to get the execution plan from a hash_plan_value.
Hi
I am running on 11gR2 and I would like to get the execution plan table as below, providing a hash_plan_value, as I have a query that is taking two different plan hash values.
Something like this:
Plan Table
-------------------------------------------------------------------------------
| Operation | Name | Rows | Bytes| Cost | Pstart | Pstop|
-------------------------------------------------------------------------------
| SELECT STATEMENT | | 105 | 8K| 1 | | |
| PARTITION RANGE ALL | | | | | 1 | 5 |
| TABLE ACCESS FULL |EMP_RANGE | 105 | 8K| 1 | 1 | 5 |
-------------------------------------------------------------------------------