SQL Tuning Advisor - DBMS_SQLTUNE

-- Create a tuning task
DBMS_SQLTUNE.create_tuning_task

-- Execute a task
DBMS_SQLTUNE.execute_tuning_task

-- Report of a task
DBMS_SQLTUNE.report_tuning_task

-- Interrupt a tuning task.
DBMS_SQLTUNE.interrupt_tuning_task

-- Resume a tuning task.
DBMS_SQLTUNE.resume_tuning_task

-- Cancel a tuning task.
DBMS_SQLTUNE.cancel_tuning_task

-- Reset a tuning task allowing it to be re-executed.
DBMS_SQLTUNE.reset_tuning_task

-- Cancel a tuning task.
 DBMS_SQLTUNE.cancel_tuning_task

--Check the status of a task
SELECT task_name, status FROM dba_advisor_log WHERE owner = 'SCOTT';

TASK_NAME                      STATUS
------------------------------ -----------
emp_dept_tuning_task           COMPLETED

1 row selected.