Tunning Task

DECLARE
   RET_VAL VARCHAR2(4000);
BEGIN
   RET_VAL := DBMS_SQLTUNE.CREATE_TUNING_TASK(SQL_ID => '4wfdvbuf06c2t',
   SCOPE => DBMS_SQLTUNE.SCOPE_COMPREHENSIVE,
   TIME_LIMIT => 10000,
   TASK_NAME => '4wfdvbuf06c2t',
   DESCRIPTION => '4wfdvbuf06c2t');
END;
/

4wfdvbuf06c2t

EXEC DBMS_SQLTUNE.EXECUTE_TUNING_TASK('4wfdvbuf06c2t');

SET linesize 200
SET LONG 5005009
SET pages 1000
SET longchunksize 20000
SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK('4wfdvbuf06c2t') RECOMMENTATION FROM DUAL;


SET linesize 200
SET LONG 5005009
SET pages 1000
SET longchunksize 20000
SELECT DBMS_SQLTUNE.SCRIPT_TUNING_TASK('4wfdvbuf06c2t') RECOMMENTATION FROM DUAL;


EXEC DBMS_SQLTUNE.DROP_TUNING_TASK('4wfdvbuf06c2t');