select sid,OPNAME,target,TARGET_DESC,sofar,TOTALWORK,trunc(sofar/totalwork*100,2)||'%' as perwork
from v$session_longops where sofar!=totalwork;
转载于:https://blog.51cto.com/yunlongzheng/1845995
select sid,OPNAME,target,TARGET_DESC,sofar,TOTALWORK,trunc(sofar/totalwork*100,2)||'%' as perwork
from v$session_longops where sofar!=totalwork;
转载于:https://blog.51cto.com/yunlongzheng/1845995