Global Information
------------------------------
Status : DONE (ALL ROWS)
Instance ID : 1
Session : SYS (1837:1553)
SQL ID : 5k014mmtyr7qw
SQL Execution ID : 16777216
Execution Started : 10/17/2016 22:02:26
First Refresh Time : 10/17/2016 22:02:32
Last Refresh Time : 10/17/2016 22:02:55
Duration : 29s
Module/Action : DBMS_SCHEDULER/ORA$AT_OS_OPT_SY_1
Service : SYS$USERS
Program : oracle@sjjh (J001)
Fetch Calls : 1
Global Stats
=================================================
| Elapsed | Cpu | Other | Fetch | Buffer |
| Time(s) | Time(s) | Waits(s) | Calls | Gets |
=================================================
| 28 | 28 | 0.09 | 1 | 307K |
=================================================
SQL Plan Monitoring Details (Plan Hash Value=3367417341)
======================================================================================== ===========================================
| Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Activity | Activity Detail |
| | | | (Estim) | | Active(s) | Active | | (Actual) | (%) | (# samples) |
======================================================================================== ===========================================
| 0 | SELECT STATEMENT | | | | 24 | +6 | 1 | 1 | | |
| 1 | SORT AGGREGATE | | 1 | | 28 | +2 | 1 | 1 | 34.48 | Cpu (10) |
| 2 | APPROXIMATE NDV AGGREGATE | | 29M | 89482 | 29 | +1 | 1 | 27M | 55.17 | Cpu (16) |
| 3 | TABLE ACCESS FULL | AB13 | 29M | 89482 | 25 | +5 | 1 | 29M | 10.34 | Cpu (3) |
======================================================================================== ===========================================
dbms_sqltune.report_sql_monitor过程接受几种输入参数来指定执行，报告的详细级别与报告类型 ('TEXT','HTML'或'XML')。缺省情况下，如果没有指定参数将会对最后所监控的到SQL生成文本类型 的SQL监控报告。
SQL> desc dbms_sqltune.report_sql_monitor
Parameter Type Mode Default?
------------------- -------- ---- --------
(RESULT) CLOB
SQL_ID VARCHAR2 IN Y
SESSION_ID NUMBER IN Y
SESSION_SERIAL NUMBER IN Y
SQL_EXEC_START DATE IN Y
SQL_EXEC_ID NUMBER IN Y
INST_ID NUMBER IN Y
START_TIME_FILTER DATE IN Y
END_TIME_FILTER DATE IN Y
INSTANCE_ID_FILTER NUMBER IN Y
PARALLEL_FILTER VARCHAR2 IN Y
PLAN_LINE_FILTER NUMBER IN Y
EVENT_DETAIL VARCHAR2 IN Y
BUCKET_MAX_COUNT NUMBER IN Y
BUCKET_INTERVAL NUMBER IN Y
BASE_PATH VARCHAR2 IN Y
LAST_REFRESH_TIME DATE IN Y
REPORT_LEVEL VARCHAR2 IN Y
TYPE VARCHAR2 IN Y
SQL_PLAN_HASH_VALUE NUMBER IN Y