plan not accepted in dba_sql_plan_baselines
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