Track RMAN Backup Job

----------------Rman Job done sofar ------------------------------------------
select SID, START_TIME,TOTALWORK, sofar, (sofar/totalwork) * 100 done,
sysdate + TIME_REMAINING/3600/24 end_at
from v$session_longops
where totalwork > sofar
AND opname NOT LIKE '%aggregate%'
AND opname like 'RMAN%';

----------------------- Rman running session------------------------
SELECT s.SID, p.SPID, s.CLIENT_INFO
FROM V$PROCESS p, V$SESSION s
WHERE p.ADDR = s.PADDR
AND CLIENT_INFO LIKE 'rman%';

------------------------ Database Active session --------------------------------
SELECT
/**** session active users ****/
s.sid sid ,
s.serial# serial_id ,
lpad(s.status,9) session_status ,
lpad(s.username,35) oracle_username ,
lpad(s.osuser,12) os_username ,
lpad(p.spid,7) os_pid ,
s.program session_program ,
lpad(s.terminal,10) session_terminal ,
lpad(s.machine,19) session_machine
FROM v$process p ,
v$session s;
WHERE p.addr (+) = s.paddr
AND s.status = 'ACTIVE'
AND s.username IS NOT NULL
ORDER BY sid ;