mon.sql
SQLモニターを表示する
■使用法
SQL> @mon <SQL_ID> <INST>
code:SQL
define SQLID=&1
define INST=&2
set trim on
set timing off
set verify off
set pages 10000
set lines 1000
set long 1000000
set longchunksize 1000000
col ESTIMATE_ROWS for 999,999,999,990 heading "Estimate Rows"
col ACTUAL_ROWS for 999,999,999,990 heading "Actual Rows"
col PROGRESS for 99990.0 heading "Progress%"
col MIN_REMAIN for 999,999,990.0 heading "Min Remain"
set heading off
set feed off
select DBMS_SQLTUNE.REPORT_SQL_MONITOR(sql_id => '&SQLID',inst_id => '&INST',report_level => 'ALL +SQL_TEXT') from dual;
set heading on
--set feed on
-- 実行順実行計画表示
--@monpln '&SQLID' '&INST'
-- 進捗表示
--@monela '&SQLID' '&INST'
undefine 1 SQLID
undefine 2 INST
@default_settings