Improving the Oracle Optimizer - Oracle Database 11gR2 Performance Tuning - page 326

l_task := DBMS_SQLTUNE.CREATE_TUNING_TASK(
sql_text => l_sql,
bind_list => sql_binds(anydata.ConvertNumber(10000),
anydata.ConvertNumber(11000),
anydata.ConvertNumber(15000)),
user_name => 'SH',
scope => 'COMPREHENSIVE',
time_limit => 120,
task_name => 'test_tuning_task',
description => 'Specific SQL tuning');
END;
/

3. Execute the SQL Tuning Task just defined:
BEGIN
DBMS_SQLTUNE.EXECUTE_TUNING_TASK(task_name => 'test_tuning_task');
END;
/

4. View the results of the tuning process:

SET LINESIZE 120
SET LONG 1000
SET LONGCHUNKSIZE 1000
SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK('test_tuning_task')
FROM DUAL;

5. Drop the SQL Tuning Task and revoke grants from user SH :

EXEC DBMS_SQLTUNE.DROP_TUNING_TASK('test_tuning_task');
CONNECT / AS SYSDBA
REVOKE ADVISOR FROM SH;