oracle 性能优化查看（DBMS_SQLTUNE.REPORT_SQL_MONITOR）

参照查看：

Oracle调优之看懂Oracle执行计划 - smileNicky - 博客园 (cnblogs.com)

Oracle SQL调优系列之SQL Monitor Report - smileNicky - 博客园 (cnblogs.com)

 

临时查看监控需添加 /*+ MONITOR */ 注意空格，不然监控不了

select /*+ MONITOR */temp2.*
  from (select rownum as rn, temp1.*
          from (select BATCH_ID, PARENT_BATCH_ID
                  from t_column_value tcv
                 where tcv.table_id = 603
                  and exists (select 1
                          from T_COLUMN_STRING tcs
                         where tcs.batch_id = tcv.batch_id
                           and tcs.column_id = 3930
                           and tcs.column_value = '申请表、申请书') 
                 order by create_date desc, BATCH_ID asc) temp1
         where rownum <= 10) temp2
 where temp2.rn >= 1

　　查看监控对应sql_id

select sql_id,sql_text,a.* from v$sql_monitor  a
where a.SQL_TEXT like '%t_column_value%'

　　执行结果如图：

 查看真实的计划报告

 
 SELECT DBMS_SQLTUNE.REPORT_SQL_MONITOR(sql_id=>'djpz68jy0wbgv',type =>'TEXT',report_level => 'ALL') AS report FROM dual;

　　报告如下：