-
select sid,opname,serial#,context,sofar as 已导入记录,totalwork as 全部记录,round(sofar/totalwork*100,4) as 进度
-
from v$session_longops
-
where /*opname like 'RMAN%'
-
and*/ opname not like '%aggregate%'
-
and totalwork != 0
-
and sofar <> totalwork
-
order by 进度 desc
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/28878983/viewspace-2134553/
,如需转载,请注明出处,否则将追究法律责任。