SPM

alter session set optimizer_use_sql_plan_baselines=false; alter session set cursor_sharing = force; alter session set optimizer_capture_sql_plan_baselines=true; alter system flush shared_pool; select object_id,object_name, object_type  from t1 where object_id between 103 and 108; select * from table(dbms_xplan.display_cursor(null,null,'advanced')); select sql_handle,plan_name,origin,enabled,accepted,sql_text from dba_sql_plan_baselines where sql_text like 'select object_id,object_name, object_type  from t1%'; exec dbms_stats.set_index_stats(ownname=>'SDE',indname=>'IDX_T1',clstfct=>2400000000000000,no_invalidate=>false); select index_name,clustering_factor from  dba_indexes where index_name='IDX_T1'; select object_id,object_name, object_type  from t1 where object_id between 103 and 108; select * from table(dbms_xplan.display_cursor(null,null,'advanced')); exec dbms_stats.gather_table_stats(ownname=>'SDE',tabname=>'T1',estimate_percent=>100,cascade=>true,no_invalidate=>true); SQL_PLAN_8a1fntd5dbh5w844cb98a alter session set optimizer_use_sql_plan_baselines=true; alter session set optimizer_capture_sql_plan_baselines=false;