Recently I faced a new issue in 12C. In automated maintenance task, sql tuning advisor was already enabled. but its still showing not running. Even I have validated dba_autotask_operation, it states “sql tuning advisor” is enabled. However view -dba_scheuler_job_run_details and dba_autotask_task showed that it is NOT running.
Further looking into it , I found its a bug in 12c.
As per metalink note, either we have to apply a patch”20540751″ or as a workaround, run @?/rdbms/admin/execsqlt.sql to create the scheduler program “‘AUTO_SQL_TUNING_PROG” that was dropped. This program should then show in in dba_scheduler_programs.
References:
Automatic SQL Tuning Task Not Executing after upgrading to 12.1.0.2 (Doc ID 2171154.1)
Recent Posts
