user::f158fe25-5652-4bc3-b247-b1c0f1c371b4

미분류

dbms_sql_monitor 사용법

명품관 2020-02-12 10:43:21 36

dbms_sqltune

dbms_sql_monitor

 

 

dbms_sql_monitor

 

set long 250000
set longchunksize 65536
 
set linesize 254
set pagesize 100
set trimspool on
 
set heading off
 
column text_line format a254
 
spool report_sql_monitor
 
select
        dbms_sqltune.report_sql_monitor_list(
                active_since_date       => sysdate - 30 / (24*60),
                type                    => 'TEXT'
        ) text_line
from    dual
;
 
select
        dbms_sqltune.report_sql_monitor(
--              sql_id                  => '&m_sql_id',
--              start_time_filter       => sysdate - 30/(24 * 60),
--              sql_exec_id             => &m_exec_id,
                type                    =>'TEXT'
        ) text_line
from    dual
;
 
spool off