Cancel sql tuning task run by SQLTXTRACT
Sometimes i do not need sqltuning advisor to be run in sqlxtract.sql just to expedite the sqlxtract output.I want to run it individually later.
This one time sqlxtract took very long to run and when i checked the status using SELECT * FROM SQLTXADMIN.sqlt$_log_v, found it to be waiting on sqltuning advisor:
TIME LINE
-------- ------------------------------------------------------------
11:24:24 sqlt$i: => sql_tuning_advisor
11:24:25 sqlt$i: max_plan_et_secs:345.868 sta_time_limit_secs:1800
11:24:25 sqlt$i: -> SYS.DBMS_SQLTUNE.EXECUTE_TUNING_TASK('sqlt_s49960
344 rows selected.
i tried to cancel the sql tuning task by running
exec dbms_sqltune.cancel_tuning_task('sqlt_s49960_mem');