DBMS_SQLTUNE 系统包兼容Oracle 的DBMS_SQLTUNE 包的部分功能，提供一系列对实时SQL监控的方法。
当SQL监控功能开启后，DBMS_SQLTUNE 包可以实时监控SQL执行过程中的信息，包括：执行时间、执行代价、执行用户、统计信息等情况。使用DBMS_SQLTUNE 也需要将DM.INI 参数ENABLE_MONITOR、MONITOR_TIME、MONITOR_SQL_EXEC设置为1。
使用DBMS_SQLTUNE.REPORT_SQL_MONITOR 方法可以查看上述执行号为2411 的执行计划信息。
22:28:49 sysdba@DAMENG:5236 SQL> set long 100000 22:28:51 sysdba@DAMENG:5236 SQL> SELECT DBMS_SQLTUNE.REPORT_SQL_MONITOR(SQL_EXEC_ID=>2410);
以看到此方法获取的执行计划比ET 函数更详细。
DBMS_SQLTUNE.REPORT_SQL_MONITOR(SQL_EXEC_ID=>2410) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ SQL Monitoring Report SQL Text ------------------------------ select e.EMPLOYEE_NAME,d.DEPARTMENT_NAME from dmhr.EMPLOYEE e join dmhr.DEPARTMENT d on e.DEPARTMENT_ID=d.DEPARTMENT_ID where e.EMPLOYEE_ID=1001; Global Information ------------------------------ Status : DONE (ALL ROWS) Session : SYSDBA (139682470123080:14) SQL ID : 1067 SQL Execution ID : 2410 Execution Started : 2025-12-25 22:26:45 Duration : 0.000226s Program : disql Global Stats ========================================================= | Affected | Bytes | Bytes | Physical | Logical | | Rows | Allocate | Free | Read(page) | Read(page) | ========================================================= | 0 | 0 | 0 | 0 | 5 | ========================================================= SQL Plan Monitoring Details ======================================================================================================================== | Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Activity | Activity Detail | | | | | (Estim) | | Active(s) | Active | | (Actual) | (%) | (# samples) | ======================================================================================================================== | 0 | DLCK | | | | 0.000004 | +0.000214 | 2 | | 2.92 | | | 1 | NSET2 | | 1 | 1 | 0.000093 | +0.000125 | 3 | 1 | 67.88 | | | 2 | PRJT2 | | 1 | 1 | 0.000001 | +0.000124 | 4 | 1 | 0.73 | | | 3 | HI3 | | 1 | 1 | 0.000002 | +0.000124 | 4 | | 1.46 | | | 4 | IJI2 | | 1 | 1 | 0.000002 | +0.000124 | 6 | 1 | 1.46 | | | 5 | ACTRL | | 1 | 1 | 0.000001 | +0.000124 | 4 | 1 | 0.73 | | | 6 | BLKUP2 | EMPLOYEE | 1 | 1 | 0.000011 | +0.000124 | 4 | 1 | 8.03 | | | 7 | SSEK2 | EMPLOYEE | 1 | 1 | 0.000013 | +0.000124 | 2 | 1 | 9.49 | | | 8 | BLKUP2 | DEPARTMENT | 1 | 1 | 0.000005 | +0.000123 | 4 | 1 | 3.65 | | | 9 | SSEK2 | DEPARTMENT | 1 | 1 | 0.000005 | +0.000123 | 2 | 1 | 3.65 | | ======================================================================================================================== 已用时间: 424.383(毫秒). 执行号:2412.欢迎访问达梦技术分享社区 ECO
https://eco.dameng.com
