Oracle查看会话剩余时间

set lines 9999SELECT s.sid,s.serial#,s.machine,sl.opname,sl.target,sl.message,s.program,sl.sql_hash_value,TRUNC(sl.elapsed_seconds/60) || ':' || MOD(sl.elapsed_seconds,60) elapsed,TRUNC(sl.time_remaining/60) || ':' || MOD(sl.time_remaining,60) remaining,ROUND(sl.sofar/sl.totalwork*100, 2) progress_pctFROM v$session s,v$session_longops slWHERE s.sid = sl.sidAND s.serial# = sl.serial#AND sl.totalwork>0AND sl.sofar<>sl.totalwork;SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"FROM V$SESSION_LONGOPSWHERE OPNAME LIKE 'RMAN%'AND OPNAME NOT LIKE '%aggregate%'AND TOTALWORK != 0AND SOFAR <> TOTALWORK;