-- Starten  Tuning Task
EXEC DBMS_SQLTUNE.execute_tuning_task(task_name => 'my_sample_tuning_task');

-- Interrupt and resume 
EXEC DBMS_SQLTUNE.interrupt_tuning_task (task_name => 'my_sample_tuning_task');
EXEC DBMS_SQLTUNE.resume_tuning_task (task_name => 'my_sample_tuning_task');

-- Cancel 
EXEC DBMS_SQLTUNE.cancel_tuning_task (task_name => 'my_sample_tuning_task');

-- Reset
EXEC DBMS_SQLTUNE.reset_tuning_task (task_name => 'my_sample_tuning_task');

--Prüfen des Status einer Tuning Task

SELECT task_name, status FROM dba_advisor_log WHERE owner = 'SCOTT';

TASK_NAME                      STATUS
------------------------------ -----------
my_sample_tuning_task           COMPLETED

1 row selected.