Execution Plan of query [message #684690] |
Tue, 27 July 2021 03:32 |
|
saipradyumn
Messages: 419 Registered: October 2011 Location: Hyderabad
|
Senior Member |
|
|
Hi All
How to get the execution plan of the query specific to one plan hash value .I am using the following query to get the current plan :
select * from table(DBMS_XPLAN.display_cursor('SQL_ID'));
But as per history multiple plans are available for the same SQL ID. I Wants to get the plans of the all SQL PLAN HASH VLAUE
select distinct PLAN_HASH_VALUE from DBA_HIST_SQL_PLAN where SQL_ID ='SQL_ID';
Is there any way to get the Detailed plans all those plan ids
Thanks
SaiPradyumn
|
|
|
|
|