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

查建索引进程