Script to Determine if a Materialized View is Being Refreshed

   SELECT s.sql , s.serial# , s.sql_id , s.status , s.event , s.last_call_et
     FROM v$lock l, dba_objects o, v$session s
    WHERE o.object_id = l.id1
      AND l.TYPE = 'JI'
      AND l.lmode = 6
      AND s.SID = l.SID
      AND o.object_type = 'TABLE'
      AND o.owner = &owner
      AND o.object_name = &mview_name