SQL> select * from DBA_AUTOTASK_CLIENT_HISTORY order by 3;
no rows selected
从DBA_AUTOTASK_CLIENT.STATUS看,任务状态是开启的:
SQL> select * from DBA_AUTOTASK_CLIENT;
查看视图,发现自动任务子系统是关闭的:
SQL> select WINDOW_NAME, WINDOW_NEXT_TIME, WINDOW_ACTIVE, AUTOTASK_STATUS, OPTIMIZER_STATS from DBA_AUTOTASK_WINDOW_CLIENTS;
7 rows selected.
最终经确认,这是预安装的BUG导致的。