Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get the execution plan based on PlanHashValue

Vinod Kumar G MMay 31 2019 — edited Jun 3 2019

Hi Team,

I am using the below query to get the execution plan based on the PlanHashValue, but i am not getting the result. Please help me .

select * from table (dbms_xplan.display_cursor(table_name=>'PLAN_TABLE',NULL, plan_hash_value=>2979454223, format => 'TYPICAL +PEEKED_BINDS'))

Regards

Vinod

This post has been answered by Vinod Kumar G M on Jun 3 2019

Jump to Answer

Added on May 31 2019

#general-database-discussions

8 comments

12,048 views