set lines 190
col sid for 9999 
col "serial#" for 99999 
col message for a80 
comp sum of "% COMPLETE" on report 
break on report 
 
SELECT SID,
       SERIAL#,
       MESSAGE,
       ROUND(SOFAR / TOTALWORK * 100, 2 / count(*)) "% COMPLETE"
  FROM V$SESSION_LONGOPS WHERE  OPNAME NOT LIKE '%aggregate%' AND TOTALWORK != 0 AND SOFAR <> TOTALWORK
 GROUP BY SID, SERIAL#, ROUND, ROUND(SOFAR / TOTALWORK * 100, 2) /