Dba_optstat_operations

Oracle: Enable or Disable GATHER_STATS_JOB
Oct 1, 2025 / Oct 12, 2026 · 8 min read · statistics gathering maintenance tasks dbms scheduler optimizer statistics performance tuning dbms_scheduler dbms_auto_task_admin dbms_stats dba_scheduler_jobs dba_autotask_client dba_autotask_window_clients dba_optstat_operations ·
Share on:
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 …

Read More