select sid, serial#, username, sofar, TOTALWORK, message
from v$session_longops where sofar < totalwork
and exists (select sid from v$session s where s.username = username
and status = 'ACTIVE')
order by 1
/
