脚本内容
set linesize 180 col opname format a20 col target format a45 col units format a10 col time_remaining format 99990 heading Remaining[s] col bps format 9990.99 heading [Units/s] col fertig format 90.99 heading "complete[%]" select sid, opname, target, sofar, totalwork, units, (totalwork-sofar)/time_remaining bps, time_remaining, sofar/totalwork*100 fertig from v$session_longops where time_remaining > 0;
评论
贡献排行榜