Another Oracle blog

  • Home
  • About
  • About

Tag Archives: Optimizer

Home / Posts Tagged: Optimizer

DISABLE optimizer stats

BEGIN dbms_auto_task_admin.disable(client_name => ‘auto optimizer stats collection’, operation => NULL, window_name => NULL); END; # Disable all of them BEGIN dbms_auto_task_admin.disable(); END;

October 23, 2015mardaffSQLOptimizer
ora-base.com