SQL Performance (MOSC)

MOSC Banner

fix plan in awr to running sql

edited Oct 5, 2015 10:29AM in SQL Performance (MOSC) 4 commentsAnswered

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.

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