ORA-13663: The task SYS_AUTO_SQL_TUNING_TASK contains no results for execution
(Doc ID 1364523.1)
Last updated on FEBRUARY 14, 2019
Applies to:Enterprise Manager for Oracle Database - Version 10.2.0.1 to 188.8.131.52 [Release 10.2 to 11.2]
Information in this document applies to any platform.
The database alert log file shows:
When you try to use the OEM -> Advisor Central -> SQL Advisors -> Automatic SQL Tuning Results -> choose the last 7 days
Then click on any of the links under Overal Task Statistics, ie., SQL Skipped Due to Errors, you get the following error:
ORA-06512: at "SYS.WRI$_REPT_SQLT", line 420 ORA-06512: at "SYS.DBMS_REPORT", line 706 ORA-06512: at "SYS.DBMS_REPORT", line 729 ORA-06512: at line 6.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document