My Oracle Support Banner

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 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.



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.