DB - Monitor session execution

PT  : E a tal query que nao termina ..

EN : And about that query that never ends ...

--
--  General
--

set lines 240
col message form a100
col opname form a50

select * from
(
 select
 round(l.sofar/l.totalwork*100,2) as complete,
 --l.*
 l.sid,
 --l.opname,
 l.message,
 l.start_time,
 l.time_remaining/60 "minuts remaining",
 l.elapsed_seconds
 from
 gv$session_longops l
 where totalwork !=0
)
where complete < 100;

--
--  RMAN Specific
--

select sid, serial#,opname, context, sofar, totalwork,
       round(sofar/totalwork*100,2) "%_complete"
from v$session_longops
where
  lower(opname) like 'rman%'
  and opname not like '%aggregate%'
  and totalwork != 0
  and sofar <> totalwork;

select
   to_char(start_time,'dd-mon-yy hh24:mi') "backup started",
   opname,
   sofar,
   totalwork,
   elapsed_seconds/60 "elapse (min)",
   round(sofar/totalwork*100,2) "complete%"
from v$session_longops
where
  lower(opname) like 'rman%'
  and opname not like '%aggregate%'
  and totalwork != 0
  and sofar <> totalwork;