fix plan in awr to running sql
hello,
After upgrade from 11.2.0.3 to 11.2.0.4,
some sql plans have changed .
and after a while we add some comments our sqls, so sql_id has also changed.
I'm trying to fix my sql to plan that is running before upgrade.
but in this case there are sql_id1, sql_plan1 (these ara only available in awr) and sql_id2, sql_plan2(currentl running).
i want to fix sql_id2 to sql_plan1.
firstly i have loaded plan with sql_plan2 to baseline from cache,
i created a sql_tuning set and loaded sql_plan1 and sql_id1 to STS.
And then i am trying to inject the plan in STS to baseline with same sql_handle that was already loaded from cache.