-- Purpose: View recommendations of SQL Tuning Advisor SET LONG 10000; SET PAGESIZE 1000 SET LINESIZE 155 col recommendations for a150 SELECT DBMS_SQLTUNE.report_tuning_task('&task_name') AS recommendations FROM dual;