Monitoring Long Running Operations

set lines 1000
set pages 1000
COLUMN OP_NAME FORMAT a40
select * from (
SELECT
SID,
OPNAME OP_Name,
  TO_CHAR(start_time,'DD-MON-YYYY HH:MI:SS') START_TIME,
  TO_CHAR(start_time + (round(TIME_REMAINING/60)/1440 +round(ELAPSED_SECONDS/60)/1440),'DD-MON-YYYY HH:MI:SS') "Expected_End_Time",
  round(TIME_REMAINING/60) "Remaining_Minuts",
  round(ELAPSED_SECONDS/60) "Elapsed_Minuts",
   round(((TIME_REMAINING/(TIME_REMAINING+ELAPSED_SECONDS))*100),2) "% Remaining",
 round(((ELAPSED_SECONDS/(TIME_REMAINING+ELAPSED_SECONDS))*100),2) "% Completed"
FROM
  V$SESSION_LONGOPS
WHERE
  TIME_REMAINING>0) order by 4 desc;