Rem
Rem    NAME
Rem      tune.sql
Rem
Rem    AUTHOR: Steeve Bisson
Rem
Rem    DESCRIPTION
Rem      This script create a tuning task, then display the tuning advisor recommendations.
Rem
Rem

prompt
prompt Using &&query for the query.

set termout off;

var task varchar2(100);
begin
  :task := tune_advisor('&&query');
end;
/

set termout on;

set pagesize 300
set linesize 200
set long 80000
set longchunksize 1000
col tuning_task format a200

select dbms_sqltune.report_tuning_task(:task) tuning_task from dual;

Undefine query