Whats Running? 

SELECT s.sid, s.serial#, s.username, s.osuser, s.machine, s.program,

       q.sql_text

FROM   v$session s

JOIN   v$sql q ON s.sql_id = q.sql_id

WHERE  s.type = 'USER'

AND    s.status = 'ACTIVE';

SELECT sid, serial#, context, sofar, totalwork,

       ROUND((sofar/totalwork)*100,2) "%_COMPLETE"

FROM v$session_longops

WHERE opname LIKE 'REFRESH MATERIALIZED VIEW%'

AND totalwork != sofar;