系统报错ORA-13785: 缺失对象"SYS_AUTO_SPM_EVOLVE_TASK"

ZhangQi

在告警日志中发现了如下错误：

2026-03-16T02:02:24.707723+08:00
VTE(5):Errors in file /u01/app/odaorabase/oracle/diag/rdbms/ptdb/ptdb1/trace/ptdb1_j002_25687.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_SQ_SQL_SW_26203"
ORA-13785: missing target object for tuning task "SYS_AUTO_SPM_EVOLVE_TASK"
ORA-06512: at "SYS.DBMS_SPM", line 2853
ORA-06512: at "SYS.PRVT_ADVISOR", line 3550
ORA-06512: at "SYS.PRVT_ADVISOR", line 934
ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 14147
ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 14174
ORA-06512: at "SYS.WRI$_ADV_SPM_EVOLVE", line 7
ORA-06512: at "SYS.PRVT_ADVISOR", line 917
ORA-06512: at "SYS.PRVT_ADVISOR", line 3455
ORA-06512: at "SYS.DBMS_ADVISOR", line 276
ORA-06512: at "SYS.DBMS_SPM", line 2833
ORA-06512: at line 34


Oracle 自动 SQL 计划管理（SPM）演进任务执行失败，缺失 SYS_AUTO_SPM_EVOLVE_TASK 调优任务对象导致的报错。

解决方法：
1.先执行 SELECT DBMS_SPM.REPORT_AUTO_EVOLVE_TASK FROM DUAL; 确认报错信息

登录/注册后可看大图