ORA-13663: The task SYS_AUTO_SQL_TUNING_TASK contains no results for execution (Doc ID 1364523.1)

Last updated on SEPTEMBER 29, 2017

Applies to:

Enterprise Manager for Oracle Database - Version: 10.2.0.1 to 11.2.0.3 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms


The database alert log file shows:

Process 0x0x3f6bccc18 appears to be hung in Auto SQL Tuning task



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:

java.sql.SQLException: ORA-13663: The task SYS_AUTO_SQL_TUNING_TASK contains no results for execution EXEC_3428.
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.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms