一 sql monitor介绍
二 用命令行方式生成sql monitor报告
set long 1000000
set longchunksize 100000
set linesize 1000
set pagesize 0
set trim on
set trimspool on
set echo off
set feedback off
spool report_sql_monitor.html
select dbms_sqltune.report_sql_monitor(sql_id=>'&&SQLID',type=>'ACTIVE',report_level=>'ALL') as report from dual;
这里要输入sql_id的值
spool off
示例：
activity活动这里显示时间大多花在了哪里。
![IDEA[Debug]<span style='color:red;'>简单</span><span style='color:red;'>说明</span>](https://img-blog.csdnimg.cn/direct/53e84e61ed534922b2a94047bf3c6b43.png)
