Curiosities in Automated Database Maintenance Tasks Management in Oracle 11.2.0.3.
responsible for building up to date optimizer statistics:
(1) All AutoTasks were not being run suddenly
(Symptoms like MOS 1506612.1: DBA_AUTOTASK_JOB_HISTORY no rows, optimizer statistics were no longer being updated.
But in contrast to the note all STATUS columns in the various views like
DBA_AUTOTASK_TASK, DBA_AUTOTASK_CLIENT, DBA_AUTOTASK_OPERATION, DBA_SCHEDULER_WINDOWS were "ENABLED" resp. "TRUE" !).
(2) After EXEC sys.dbms_auto_task_admin.enable all tasks were executed in the scheduled windows again.
The EXEC sys.dbms_auto_task_admin.enable/disable had no impact on the STATUS columns from (1).