SQL TUNE
-
编辑 删除
通过AWR REPORT 或 ADDM REPORT进行SQLTUNE
1.建立SQL TUNE任务 SET SERVEROUTPUT ON DECLARE l_sql_tune_task_id VARCHAR2(100); BEGIN l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task ( sql_id => 'aaz58jt1sgjk3', scope => DBMS_SQLTUNE.scope_comprehensive, time_limit => 60, task_name => 'aaz58jt1sgjk3_tuning_task', description => 'Tuning task for statement aaz58jt1sgjk3.'); DBMS_OUTPUT.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id); END; /[@more@]2.执行任务，并查看执行状态EXEC DBMS_SQLTUNE.EXECUTE_TUNIN
