long_running_msg

col start format A13
column sid:ser form A10 heading "sid:ser"
column username form A10
column "%" form 99
column message form A90

SELECT TO_CHAR(start_time,'DDMonHH24:MI:SS') AS "start", sid||','||serial# "sid:ser", username, ROUND(sofar*100/DECODE(totalwork,0,1,totalwork)) AS "%", message
FROM v$session_longops
WHERE time_remaining > 0 ORDER BY message;