Error: Error in alert log file for SQL Advisor every day
ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 14140
ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 14167
ORA-06512: at "SYS.WRI$_ADV_SPM_EVOLVE", line 7
ORA-06512: at "SYS.PRVT_ADVISOR", line 915
ORA-06512: at "SYS.PRVT_ADVISOR", line 3451
ORA-06512: at "SYS.DBMS_ADVISOR", line 276
ORA-06512: at "SYS.DBMS_SPM", line 2790
ORA-06512: at line 34
Solution:
To avoid these errors from the alert log. Disable the SQLTUNE advisory for avoiding the error in alert log.
BEGIN
dbms_auto_task_admin.disable(
client_name => 'sql tuning advisor',
operation => NULL,
window_name => NULL);
END;
/