How to Check RMAN Session Wait for Media in Oracle Database

DBA scripts to query RMAN Session Wait for Media in Oracle Database:

SELECT sw.sid ,p.SPID, s.EVENT, s.SECONDS_IN_WAIT AS SEC_WAIT,
  sw.STATE, s.CLIENT_INFO
  FROM V$SESSION_WAIT sw, V$SESSION s, V$PROCESS p
  WHERE sw.EVENT LIKE '%MML%'
  AND s.SID=sw.SID
  AND s.PADDR=p.ADDR;