Session Longops with ETA.

select opname, sid, serial#, target ,
trunc(sofar/totalwork*100,2) pct_complete , start_time, last_update_time ,
NUMTODSINTERVAL(last_update_time-start_time, 'DAY') elapsed ,
NUMTODSINTERVAL(  (last_update_time-start_time ) / sofar * (totalwork-sofar), 'DAY') remaining ,
last_update_time+ (last_update_time-start_time) / sofar * (totalwork-sofar) eta
from v$SESSION_longops where time_remaining > 0 ;