----对某个SQL进行调优任务
DECLARE
my_task_name VARCHAR2(30);
BEGIN
my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK(sql_id => '3p5t99gj4c02t');
DBMS_SQLTUNE.EXECUTE_TUNING_TASK( task_name => my_task_name);
END;
/
----查看调优任务的结果
SELECT task_name,status FROM USER_ADVISOR_TASKS;
----查看调优任务的报告
DECLARE
my_task_name VARCHAR2(30);
BEGIN
my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK(sql_id => '3p5t99gj4c02t');
DBMS_SQLTUNE.EXECUTE_TUNING_TASK( task_name => my_task_name);
END;
/
----查看调优任务的结果
SELECT task_name,status FROM USER_ADVISOR_TASKS;
----查看调优任务的报告
SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK( 'TASK_287620') from DUAL;