SQL Performance (MOSC)

MOSC Banner

How to get the execution plan from a hash_plan_value.

edited May 25, 2016 5:03AM in SQL Performance (MOSC) 2 commentsAnswered

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 |

-------------------------------------------------------------------------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center