SQL Performance (MOSC)

MOSC Banner

Cancel sql tuning task run by SQLTXTRACT

edited Aug 31, 2016 4:19PM in SQL Performance (MOSC) 7 commentsAnswered ✓

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');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center