SQL>select start_time,end_time,status,input_type,
2input_bytes_display,output_bytes_display,input_bytes_per_sec_display,output_bytes_per_sec_display,time_taken_display
3from v$rman_backup_job_details where start_time >= trunc (sysdate) - 8 order by start_time;
START_TIME
END_TIME
STATUS
INPUT_TYPEINPUT_BYTES_ OUTPUT_BYTES INPUT_BYTE OUTPUT_BYT TIME_TAKEN
------------------- ------------------- ----------------------- ------------- ------------ ------------ ---------- ---------- ----------
2009-02-16 23:00:07 2009-02-16 23:02:19 COMPLETED
ARCHIVELOG2.28G758.47M 17.70M5.75M00:02:12
2009-02-17 06:00:08 2009-02-17 08:33:28 COMPLETED
DB INCR 374.02G 71.25G 41.63M7.93M02:33:20
|