sql_monitor

最新推荐文章于 2024-07-08 09:08:34 发布

xiaoxiao树

最新推荐文章于 2024-07-08 09:08:34 发布

阅读量459

点赞数

本文链接：https://blog.csdn.net/u010719917/article/details/52002661

版权

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