List RMAN Jobs
--
-- List RMAN Jobs.
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
 
COL compression_ratio for 99999 head Cmprsn|Ratio
COL elapsed for 9999.99 head Elapsed|Mins
COL end_time for a18 head "End Time"
COL hrs for 999,999
COL input_type head "Input Type"
COL session_key for 9999999 head Session|Key
COL start_time for a18 Head "Start Time"
COL status for a23 head "Job Status"
 
select session_key,input_type,status,
        to_char(start_time,'dd/mm/yy hh24:mi:ss') start_time,
        to_char(end_time,'dd/mm/yy hh24:mi:ss') end_time,
        (elapsed_seconds/60) elapsed,COMPRESSION_RATIO
from v$rman_backup_job_details
order by session_key
/

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License