SQL> set lines 132 pages 100
col KEY for 9,999
col INPUT_TYPE for a12
col STATUS for a10
col JOB_TIME for a8
col RATIO for 999
col INPUT_SEC for a10
col OUTPUT_SEC for a10
select SESSION_KEY KEY, INPUT_TYPE, STATUS, to_char(START_TIME,'mm/dd/yy hh24:mi') start_time, to_char(END_TIME,'mm/dd/yy hh24:mi') end_time, TIME_TAKEN_DISPLAY job_time, OPTIMIZED, round(COMPRESSION_RATIO, 0) Ratio, INPUT_BYTES_PER_SEC_DISPLAY Input_Sec, OUTPUT_BYTES_PER_SEC_DISPLAY Output_Sec
from V_$RMAN_BACKUP_JOB_DETAILS
order by 1
/
KEY INPUT_TYPE STATUS START_TIME END_TIME JOB_TIME OPT RATIO INPUT_SEC OUTPUT_SEC
------ ------------ ---------- -------------- -------------- -------- --- ----- ---------- ----------
3 DB FULL COMPLETED 12/13/19 00:49 12/13/19 00:49 00:00:10 NO 1 85.63M 72.28M
Devops Engineer