Search notes:

Oracle: Init parameter OPTIMIZER_USE_PENDING_STATISTICS

TODO

begin
   dbms_stats.set_schema_prefs(
      ownname => user,
      pname   =>'PUBLISH',
      pvalue  =>'FALSE'
   );
end;
/

Links

Connor McDonald: The Catch-22 problem with gathering statistics

Index