SQL Performance (MOSC)

MOSC Banner

plan not accepted in dba_sql_plan_baselines

edited Feb 15, 2016 4:01AM in SQL Performance (MOSC) 5 commentsAnswered

Hello,

Please see below:

select SIGNATURE,SQL_HANDLE,SQL_TEXT,PLAN_NAME,VERSION,ENABLED,ACCEPTED,FIXED,OPTIMIZER_COST from dba_sql_plan_baselines ;

              16025064201104178623 SYS_SQL_de6476fc89a4bdbf                  select * from t where id=4                       SYS_SQL_PLAN_89a4bdbf94ecae5c                                                               11.1.0.7.0                YES        NO        NO                    14

              16025064201104178623 SYS_SQL_de6476fc89a4bdbf                  select * from t where id=4                       SYS_SQL_PLAN_89a4bdbfc31c3355                                                               11.1.0.7.0                YES        YES       NO                     1

When I the index was changed to invisible another plan I can see here but that's not accepted.Not sure why

Best regards,

Vishal

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