Dbms_auto_task_admin

Enable or Disable Oracle GATHER_STATS_JOB for Automatic Statistics Collection Purpose Two Oracle releases, two different switches. In Oracle Database 10g, automatic optimizer statistics ran as a Scheduler job named GATHER_STATS_JOB, and you turned it on or off with DBMS_SCHEDULER.ENABLE and DBMS_SCHEDULER.DISABLE. From …