Long Operation Process

COL MINUTES FORMAT 999,990.99
COL HOURS FORMAT 999,990.99
COL MESSAGE FORMAT A22
COL OPNAME FORMAT A20 HEA "O P E R A T I O N"
COL PCT_COMPLETE FORMAT A04 HEA "PCT |DONE" TRUNC JUST RIGHT
COL SERIAL# FORMAT 99999
COL SID FORMAT 9999999
COL STARTED FORMAT A20 HEA "S T A R T T I M E"
COL TARGET FORMAT A16
COL TARGET_DESC FORMAT A16
COL TIME_REMAINING FORMAT 99,999,999
COL UNITS FORMAT A10
COL USERNAME FORMAT A08
SET ECHO OFF
SET ECHO ON
SELECT SID
,SERIAL#
,USERNAME
,OPNAME
,TO_CHAR(START_TIME,'DD-MON-YYYY HH24 MI SS') STARTED
,SOFAR/TOTALWORK*100||'%' PCT_COMPLETE
,ELAPSED_SECONDS/60 MINUTES
,TOTALWORK
,UNITS
,TIME_REMAINING/60 REMAINING
FROM V$SESSION_LONGOPS
WHERE USERNAME != 'PATROL'
AND USERNAME != 'SYS'
and sofar != totalwork
ORDER BY ELAPSED_SECONDS DESC
;