|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
prompt RMAN Backup Information prompt _______________________________________________________ prompt col CONF# for 999999 col name for a40 col value for a10 select * from GV$RMAN_CONFIGURATION / prompt prompt prompt RMAN Backup Information (30 Days) prompt _______________________________________________________ prompt col SESSION_KEY for 9,99999 col INPUT_TYPE for a15 col STATUS for a10 col JOB_TIME for a8 col COMP_RATIO for 999 col INPUT_SEC for a10 col OUTPUT_SEC for a10 col start_time for a15 col end_time for a15 select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,'yy/mm/dd hh24:mi') start_time, to_char(END_TIME,'yy/mm/dd hh24:mi') end_time, TIME_TAKEN_DISPLAY job_time, OPTIMIZED, round(COMPRESSION_RATIO, 0) COMP_RATIO, INPUT_BYTES_PER_SEC_DISPLAY Input_Sec, OUTPUT_BYTES_PER_SEC_DISPLAY Output_Sec from V$RMAN_BACKUP_JOB_DETAILS where start_time >= trunc(sysdate-31) order by 1 / |