Oracle 预测处理结束时间SQL
-- 查看所有
select * from GV$SESSION_LONGOPS;
-- 指定SQLID
!bind set sql_id = 'xxxxxxxxx'
select
t1.*
, t1.TIME_REMAINING / 60 / 60 as 終了予測時間
, t1.ELAPSED_SECONDS / 60 / 60 as 実行時間
, t1.SOFAR / t1.TOTALWORK * 100 as 進捗率
from GV$SESSION_LONGOPS t1
where t1.SQL_ID = :sql_id