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

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

 

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

select /*+ MONITOR */temp2.*from (select rownum as rn, temp1.*from (select BATCH_ID, PARENT_BATCH_IDfrom t_column_value tcvwhere tcv.table_id = 603and exists (select 1from T_COLUMN_STRING tcswhere tcs.batch_id = tcv.batch_idand tcs.column_id = 3930and tcs.column_value = '申请表、申请书') order by create_date desc, BATCH_ID asc) temp1where rownum <= 10) temp2where 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;

　　报告如下：