STA (SQL Tuning Advisor) のコマンド

メモメモ。。。

VARIABLE STMT_TASK VARCHAR2(64);
EXEC :STMT_TASK := DBMS_SQLTUNE.CREATE_TUNING_TASK(sql_id=>'xxxxxxxxxxxxx', time_limit=>300);
EXEC DBMS_SQLTUNE.EXECUTE_TUNING_TASK(:STMT_TASK);
SET LONGCHUNKSIZE 2000000 LONG 2000000 LINESIZE 300 PAGESIZE 1000;
COLUMN REPORT FORMAT A300
SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK(:STMT_TASK) AS REPORT FROM DUAL;