Oracle SQL Tuning Advisor

Oracle SQL Tuning Advisor Steps sqlplus / as sysdba begin dbms_sqltune.drop_tuning_task(task_name => 'my_sql_tuning_task'); end; / declare my_task_name varchar2(30); begin my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK( sql_id => '&sql_id', --make sure that you enter proper SQL_ID task_name => 'my_sql_tuning_task', time_limit => 1800, description => 'Task to tune a query '); END; / begin DBMS_SQLTUNE.EXECUTE_TUNING_TASK( task_name => 'my_sql_tuning_task' ); end; / spool Report.out set long 10000000 select dbms_sqltune.report_tuning_task('my_sql_tuning_task') from dual / spool off