SQL Tuning Advisor

DECLARE
  l_sql_tune_task_id  VARCHAR2(100);
BEGIN
  l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task (
                          sql_id      => '3rfdxk7fxh9b9',
                          scope       => DBMS_SQLTUNE.scope_comprehensive,
                          time_limit  => 60,
                          task_name   => '3rfdxk7fxh9b9_tuning_task11',
                          description => 'Tuning task1 for statement 87s8z2zzpsg88');
  DBMS_OUTPUT.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id);
END;
/


XEC DBMS_SQLTUNE.execute_tuning_task(task_name => '3rfdxk7fxh9b9_tuning_task11');



set long 65536
set longchunksize 65536
set linesize 100
select dbms_sqltune.report_tuning_task('3rfdxk7fxh9b9_tuning_task11') from dual;



execute dbms_sqltune.drop_tuning_task('3rfdxk7fxh9b9_tuning_task11');