DECLARE
  a_sql_tune_task_id  VARCHAR2(100);
BEGIN
  a_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task (
                          begin_snap  => 1436,
                          end_snap    => 1439,
                          sql_id      => '51wpmnhjhmaj7',
                          scope       => DBMS_SQLTUNE.scope_comprehensive,
                          time_limit  => 60,
                          task_name   => '51wpmnhjhmaj7_AWR_tuning_task',
                          description => 'Tuning task for statement 51wpmnhjhmaj7 in AWR.');
  DBMS_OUTPUT.put_line('a_sql_tune_task_id: ' || a_sql_tune_task_id);
END;
/

a_sql_tune_task_id: 51wpmnhjhmaj7_AWR_tuning_task
*** SCRIPT END :  Session:SYS@NEOIBM(1)   25-Sep-2007 17:01:22 *** 

SQL> EXEC DBMS_SQLTUNE.execute_tuning_task(task_name => '51wpmnhjhmaj7_AWR_tuning_task');
PL/SQL procedure successfully completed.

SQL> select task_name, status
  2  from dba_advisor_log
  3  where task_name like '5%';

TASK_NAME                      STATUS
------------------------------ -----------
51wpmnhjhmaj7_AWR_tuning_task  COMPLETED
5ctw1qj4wyd6b_tuning_task      COMPLETED

SQL> select dbms_sqltune.report_tuning_task('51wpmnhjhmaj7_AWR_tuning_task')
  2  as RECOMMENDATIONS
  3  from dual;

RECOMMENDATIONS
--------------------------------------------------------------------------------

GENERAL INFORMATION SECTION
-------------------------------------------------------------------------------
Tuning Task Name   : 51wpmnhjhmaj7_AWR_tuning_task
Tuning Task Owner  : SYS
Scope              : COMPREHENSIVE
Time Limit(seconds): 60
Completion Status  : COMPLETED
Started at         : 09/25/2007 17:06:18
Completed at       : 09/25/2007 17:06:18

-------------------------------------------------------------------------------
Schema Name: CCS_ADMIN
SQL ID     : 51wpmnhjhmaj7
SQL Text   : SELECT   ID, NAME, detail_file, picture_file, statusbar_text,
             menu_level, parent_id, NVL (window_prop, ' ') window_prop,
             window_width,  window_height, NVL (window_param, ' ')
             window_param FROM menu a     ,(select distinct menu_id
             from menu_access a              ,user_role   b         where
             b.role_id =a.role_id              and b.user_id='QBH'         )
             b WHERE style = 'top'   AND publish = 1   AND a.ID = b.men