big query to analyze dbms_sqltune.report_tuning_task('&task') then error : ORA-13639:
hello gurus,
I try to execute select dbms_sqltune.report_tuning_task('&task') from dual; then i retrieve the error : ORA-13639.
my timeout is 1800s. "Time Limit(seconds): 1800"
- i retrieve my query very long by awr,
- DBMS_SQLTUNE.CREATE_TUNING_TASK(sql_id => '37n75bp7sr87p');
- EXEC DBMS_SQLTUNE.EXECUTE_TUNING_TASK(task_name => '&Task');
- dbms_sqltune.report_tuning_task('&task') from dual;
Therefore
1 - is normal that my treatment is very long ?
2 - how may i to increase the timeout for my analyse ?
3 - i would like improve my query it is why i try to analyse by report_tuning_task ?
Tagged:
1