V$BACKUP_SET_SUMMARY

select
a.*,                     -- NUM_BACKUPSETS NUMBER
case                     -- OLDEST_BACKUP_TIME DATE
  when original_input_bytes/decode (output_bytes, 0, null, output_bytes) > 1 then original_input_bytes/decode (output_bytes, 0, null, output_bytes) else 1 end compression_ratio,
sys.dbms_rcvman.num2displaysize -- NEWEST_BACKUP_TIME DATE
  (original_input_bytes) original_input_bytes_display,
sys.dbms_rcvman.num2displaysize -- OUTPUT_BYTES NUMBER
  (output_bytes) output_bytes_display,
sys.dbms_rcvman.num2displaysize -- ORIGINAL_INPUT_BYTES NUMBER
  (original_inprate_bytes) original_inprate_bytes_display,
sys.dbms_rcvman.num2displaysize -- ORIGINAL_INPRATE_BYTES NUMBER
  (output_rate_bytes) output_rate_bytes_display 
from
(
select
count (*) num_backupsets,
min (start_time) oldest_backup_time,
max (start_time) newest_backup_time,
sum (output_bytes) output_bytes,
sum (original_input_bytes) original_input_bytes,
avg (original_inprate_bytes) original_inprate_bytes,
avg (output_rate_bytes) output_rate_bytes 
from
(
select
unique set_stamp,
set_count,
start_time,
output_bytes,
original_input_bytes,
original_inprate_bytes,
output_rate_bytes,
compression_ratio 
from
v$backup_set_details)) a
home |  up  |  mailbox