RMAN

SET lines 200 pages 2000
col STATUS format a25
col dev format a10
col START_TIME format a16
col END_TIME format a16
col hrs format 99.99
col INBYTES format a10
col OUTBYTES format a10
SELECT SESSION_KEY, INPUT_TYPE, STATUS, output_device_type DEV,
TO_CHAR(START_TIME,'mm/dd/yy hh24:mi') start_time,
TO_CHAR(END_TIME,'mm/dd/yy hh24:mi') end_time,
elapsed_seconds/3600 hrs,
input_bytes_display inbytes, output_bytes_display outbytes
FROM V$RMAN_BACKUP_JOB_DETAILS
WHERE status='RUNNING'
ORDER BY session_key;