使用quicktune调整单条sql.txt

来自「在oracle中」· 文本 代码 · 共 12 行

--创建目录WORK_DIR
create directory TUNE_DIR as 'E:\oracle\product\10.2.0\Tune';
--替换掉SQL TEXT
VARIABLE task_name VARCHAR2(255);
VARIABLE sql_stmt VARCHAR2(4000);
EXECUTE :task_name := 'MY_QUICKTUNE_TASK1';
EXECUTE :sql_stmt := 'select * from sosv3.user_info where user_name=''xxx''';
EXECUTE DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR,:task_name, :sql_stmt);
--如果输出创建目录WORK_DIR
EXECUTE dbms_advisor.get_task_report(:task_name,'TEXT','ALL'),'WORK_DIR','quicktune.txt');

execute dbms_advisor.create_file(dbms_advisor.get_task_script('MY_QUICKTUNE_TASK1'),'TUNE_DIR','quicktune.txt');