Problém
2018-04-01T12:20:41.773391+02:00
Errors in file /u01/app/oracle/diag/rdbms/zmserv/zmserv2/trace/zmserv2_j001_18259.trc:
ORA-12012: error on auto execute of job „SYS“.“ORA$AT_OS_OPT_SY_85360″
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: at „SYS.DBMS_STATS“, line 47207
ORA-06512: at „SYS.DBMS_STATS_ADVISOR“, line 882
ORA-06512: at „SYS.DBMS_STATS_INTERNAL“, line 20059
ORA-06512: at „SYS.DBMS_STATS_INTERNAL“, line 22201
ORA-06512: at „SYS.DBMS_STATS“, line 47197
Řešení
Bug 25710407
SQL> select name, ctime, how_created
from sys.wri$_adv_tasks
where owner_name = 'SYS'
and name in ('AUTO_STATS_ADVISOR_TASK','INDIVIDUAL_STATS_ADVISOR_TASK'); 2 3 4
no rows selected
SQL> EXEC dbms_stats.init_package();
PL/SQL procedure successfully completed.
SQL> select name, ctime, how_created from sys.wri$_adv_tasks where owner_name
= 'SYS' and name in
('AUTO_STATS_ADVISOR_TASK','INDIVIDUAL_STATS_ADVISOR_TASK'); 2 3
NAME
--------------------------------------------------------------------------------
CTIME HOW_CREATED
--------- ------------------------------
AUTO_STATS_ADVISOR_TASK
04-APR-18 CMD
INDIVIDUAL_STATS_ADVISOR_TASK
04-APR-18 CMD