column opname format a20
select username,opname,target,round(((totalwork-sofar)/totalwork),4)*100 "PCT_REMINING",round(time_remaining/60,2) "Min"
from v$session_longops
where time_remaining>0
/