sql_monitor

SQL Monitor 报告生成指南

最新推荐文章于 2025-09-21 14:07:14 发布

原创最新推荐文章于 2025-09-21 14:07:14 发布 · 501 阅读

0 ·

CC 4.0 BY-SA版权

本文档提供了详细的步骤说明，展示如何使用Oracle DBMS_SQLTUNE包中的report_sql_monitor过程来生成SQL会话和SQL ID相关的监控报告，包括文本和HTML格式。

9q34y6h924jzh

一、sql_monitor
---report_sql_monitor->session_id
-- Place this code in GET_MONITOR_SID.SQL
SET ECHO OFF TERMOUT OFF LINES 32767 PAGES 0 TRIMSPOOL ON VERIFY OFF LONG 1000000 LONGC 1000000
SPOOL monitor.html REPLACE
SELECT DBMS_SQLTUNE.report_sql_monitor (session_id => &sid, TYPE => 'ACTIVE') FROM DUAL;
SPOOL OF

e.g:
SET ECHO OFF TERMOUT OFF LINES 32767 PAGES 0 TRIMSPOOL ON VERIFY OFF LONG 1000000 LONGC 1000000
SPOOL monitor.html REPLACE
SELECT DBMS_SQLTUNE.report_sql_monitor (session_id =>655, TYPE => 'ACTIVE') FROM DUAL;
SPOOL OFF

二、sql_monitor
SET TERMOUT ON
-- Place this code in GET_MONITOR_SQLID.SQL
SET ECHO OFF TERMOUT OFF LINES 32767 PAGES 0 TRIMSPOOL ON VERIFY OFF LONG 1000000 LONGC 1000000
SPOOL monitor.html REPLACE
SELECT DBMS_SQLTUNE.report_sql_monitor (sql_id => '&sql_id',TYPE => 'ACTIVE') FROM DUAL;
SPOOL OFF

SELECT dbms_sqltune.report_sql_monitor(sql_id => '59v4zh1ac3v2a',report_level => 'ALL',type=>'text') comm FROM dual;
SELECT dbms_sqltune.report_sql_monitor(sql_id => '59v4zh1ac3v2a',report_level => 'ALL',type=>'HTML') comm FROM dual;

SET TERMOUT ON
-- Place this code in GET_MONITOR_SQLID.SQL
SET ECHO OFF TERMOUT OFF LINES 32767 PAGES 0 TRIMSPOOL ON VERIFY OFF LONG 1000000 LONGC 1000000
SPOOL monitor.html REPLACE
SELECT DBMS_SQLTUNE.report_sql_monitor (sql_id => '6yq1mvkxpqn9b',TYPE => 'ACTIVE') FROM DUAL;
SPOOL OFF

三、sql_monitor
SET TERMOUT ON PAGES 900 LINES 200
-- Example call to GET_MONITOR_SID.SQL from SQL*Plus
DEFINE SID=123
@GET_MONITOR_SID