sql tuning advisor giving error
Below is the error after running statement SELECT DBMS_SQLTUNE.report_tuning_task('&TASK_NAME') AS recommendations FROM dual;
GENERAL INFORMATION SECTION
----------------------------------------------------
---------------------------
Tuning Task Name : 9xpraph8f0yxz_MCK
Tuning Task Owner : SYS
Workload Type : Single SQL Statement
Scope : COMPREHENSIVE
Time Limit(seconds): 60
Completion Status : INTERRUPTED
Started at : 01/09/2014 09:03:55
Completed at : 01/09/2014 09:05:21
---------------------------------------------------
----------------------------
Error: ORA-13639: The current operation was interru
pted because it timed out.
----------------------------------------------------
---------------------------
Tuning Task Name : 9xpraph8f0yxz_MCK
Tuning Task Owner : SYS
Workload Type : Single SQL Statement
Scope : COMPREHENSIVE
Time Limit(seconds): 60
Completion Status : INTERRUPTED
Started at : 01/09/2014 09:03:55
Completed at : 01/09/2014 09:05:21
---------------------------------------------------
----------------------------
Error: ORA-13639: The current operation was interru
pted because it timed out.
0