ORACLE的DBMS_SQLTUNE调优某个SQL

----对某个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;
----查看调优任务的报告

SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK( 'TASK_287620') from DUAL;