Database Administration (MOSC)

MOSC Banner

Curiosities in Automated Database Maintenance Tasks Management in Oracle 11.2.0.3.

edited Dec 7, 2012 4:26AM in Database Administration (MOSC) 1 commentAnswered
The following issues were observed with this new "feature" that replaces among others the previous GATHER_STATS_JOB
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).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center