Oracle Database Discussions

Hi All,

oracle 11.2.0.3

IBM Aix box

I ran sql tuning advisor manually using procedure

sample procedure:

DBMS_SQLTUNE.create_tuning_task (

begin_snap => 139758,

end_snap => 139762,

sql_id => 'ct4u2889m1458',

scope => DBMS_SQLTUNE.scope_comprehensive,

time_limit => 60,

task_name => 'tuning',)

i got the message PL/SQL procedure successfully completed.

Then i executed the created tuning task using the procedure

EXEC DBMS_SQLTUNE.execute_tuning_task(task_name => 'tuning');

again got message like PL/SQL procedure successfully completed.

But when i query using SELECT * FROM dba_advisor_log WHERE task_name ='_tuning';

i got this output in respective column, INTERRUPTED, ORA-13639: The current operation was interrupted because it timed out.

Any idea or suggestions, why im getting this error , i should get the COMPLETED as status. I even tried to increase the time_limit values, but still no go..

Regards,