RE: dbms_spm.load_plans_from_sqlset is loading wrong xplan into thebaseline

From: <fmhabash_at_gmail.com>
Date: Mon, 11 Jul 2016 12:09:07 -0400
Message-ID: <5783c4a3.4705240a.5e780.6892_at_mx.google.com>

Thanks.
I realize the difference between plan_id and phv. The ‘display_sql_plan_baseline’ api shows both. This is how we verify the baseline contains the correct phv. Are you saying this is not the case?

select * from table(
dbms_xplan.display_sql_plan_baseline(
sql_handle=>'SQL_f882ed7d0f4c8b06',
format=>'all'));
 
Plan name: SQL_PLAN_gj0rdgn7nt2s62ada8df3         Plan id: 718966259                                                                                                                                                                                            Enabled: YES     Fixed: YES     Accepted: YES     Origin: MANUAL-LOAD                                                                                                                                                                                          

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

                                                                                                                                                                                                                                                                 Plan hash value: 3798909502  

---

Thank you

From: Dominic Brooks

--
http://www.freelists.org/webpage/oracle-l




image/png attachment: 38FE97C2662943B7A719CE52790EAFC8.png

Received on Mon Jul 11 2016 - 18:09:07 CEST