一、sql monitor介绍

1>用于SQL 语句执行性能相关问题的深入分析
2>系统内置
3>捕获每一次执行的数据
4>包括仍在运行的SQL

二、sql monitor和ash视图的优势：

1>sql monitor 可以查看每次执行时传入的绑定变量值
2>sql monitor 里可以查看执行计划每一步的估算行数和实际行数

三、哪些SQL 会被捕获

1>所有的并行执行SQL
2>执行时长超过5秒的串行执行SQL
3>指定/*+ monitor */ hint

四、支持以下格式

1>Text
2>HTML
3>Active-HTML 建议用这种格式
4>JET now

五、命令行生成

SET LONG 1000000
SET LONGCHUNKSIZE 1000000
SET LINESIZE 1000
SET PAGESIZE 0
SET TRIM ON
SET TRIMSPOOL ON
SET ECHO OFF
SET FEEDBACK OFF
spool gxvvscy9mycy3.txt
SELECT DBMS_SQLTUNE.REPORT_SQL_MONITOR(SQL_ID=>'817kj79rr9qn5',SQL_EXEC_ID=>16831026,TYPE=>'active',REPORT_LEVEL=>'ALL') AS REPORT FROM dual;
spool off


--完整语法：

FUNCTION REPORT_SQL_MONITOR RETURNS CLOB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SQL_ID VARCHAR2 IN DEFAULT
SESSION_ID NUMBER IN DEFAULT
SESSION_SERIAL NUMBER IN DEFAULT
SQL_EXEC_START DATE IN DEFAULT
SQL_EXEC_ID NUMBER IN DEFAULT
INST_ID NUMBER IN DEFAULT
START_TIME_FILTER DATE IN DEFAULT
END_TIME_FILTER DATE IN DEFAULT
INSTANCE_ID_FILTER NUMBER IN DEFAULT
PARALLEL_FILTER VARCHAR2 IN DEFAULT
PLAN_LINE_FILTER NUMBER IN DEFAULT
EVENT_DETAIL VARCHAR2 IN DEFAULT
BUCKET_MAX_COUNT NUMBER IN DEFAULT
BUCKET_INTERVAL NUMBER IN DEFAULT
BASE_PATH VARCHAR2 IN DEFAULT
LAST_REFRESH_TIME DATE IN DEFAULT
REPORT_LEVEL VARCHAR2 IN DEFAULT
TYPE VARCHAR2 IN DEFAULT
SQL_PLAN_HASH_VALUE NUMBER IN DEFAULT
CON_NAME VARCHAR2 IN DEFAULT
REPORT_ID NUMBER IN DEFAULT
DBOP_NAME VARCHAR2 IN DEFAULT
DBOP_EXEC_ID NUMBER IN DEFAULT