1
sess_longops
emcs
48次下载
541次浏览
2019-07-24
4.5

脚本内容

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;

评论

贡献排行榜