Sql tuning advisor

EXEC DBMS_WORKLOAD_REPOSITORY.create_snapshot;　
DECLARE
l_sql_tune_task_id VARCHAR2(100);
BEGIN
l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task (
begin_snap => 8550,
end_snap => 8552,
sql_id => '3p7qbwascyz7n',
scope => DBMS_SQLTUNE.scope_comprehensive,
time_limit => 400,
task_name => '3p7qbwascyz7n_AWR_tuning_task',
description => 'Tuning task for statement 3p7qbwascyz7n in AWR.');
DBMS_OUTPUT.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id);
END;
/
EXEC DBMS_SQLTUNE.execute_tuning_task (task_name => '3p7qbwascyz7n_AWR_tuning_task');
　
　
　
SET LONG 100000000;
SET PAGESIZE 1000
SET LINESIZE 200
SELECT DBMS_SQLTUNE.report_tuning_task('3p7qbwascyz7n_AWR_tuning_task') AS recommendations FROM dual;
SET PAGESIZE 24