Now is time to play with some more advanced RMAN scenarios.
Have a look at the following command:
SQL> ALTER SESSION SET nls_date_format= 'DD-MON-YYYY:HH24:MI:SS'; SQL> SELECT /*+ RULE */ session_key, session_recid, start_time, end_time, output_bytes, elapsed_seconds, optimized 2 FROM v$rman_backup_job_details 3 WHERE start_time >= sysdate-180 4 AND status='COMPLETED' 5 AND input_type='DB FULL';
A summary of the active session history might help (make sure you are licensed to use it by acquiring the Oracle Diagnostic Pack!). Have a look at the following command:
SQL> SELECT sid, serial#, program 2 FROM v$session 3 WHERE lower(program) like '%rman%'; ...