select sid,OPNAME,target,TARGET_DESC,sofar,TOTALWORK,trunc(sofar/totalwork*100,2)||‘%‘ as perwork
from v$session_longops where sofar!=totalwork;
本文出自 “麦地坞” 博客，请务必保留此出处http://yunlongzheng.blog.51cto.com/788996/1845995
原文：http://yunlongzheng.blog.51cto.com/788996/1845995