Oracle SQLTUNE性能分析

--执行SQL后先查询最后1次执行的SQL 的sql id
select *   from v$sql order by last_load_time desc

--执行存储过程获取分析报告
DECLARE  
    l_tuning_task VARCHAR2(30);  
BEGIN  
    l_tuning_task := dbms_sqltune.create_tuning_task(sql_id => '460020ygxfsjc');       
    dbms_sqltune.execute_tuning_task(l_tuning_task);  
    dbms_output.put_line(l_tuning_task);  
END; 
 
--查看执行计划
select dbms_sqltune.report_tuning_task('TASK_224')  from dual; 

上一篇：Spring 调度处理，异常被吃掉问题