Query to Find RMAN backup details

 Query to Find RMAN backup details:

            set lines 200 pages 999
            col OUTPUT_BYTES_DISPLAY for a20;
            col INPUT_TYPE for a20;
            col TIME_TAKEN_DISPLAY for a20;
            col START_TIME for a30;
            col END_TIME for a20;
            col status for a30;
            select session_key,
            input_type,
            status,
            to_char(start_time,'yyyy-mm-dd hh24:mi') start_time,
            to_char(end_time,'yyyy-mm-dd hh24:mi')   end_time,
            output_bytes_display,
            time_taken_display
            from v$rman_backup_job_details
            order by session_key asc;