select
  num_files_backed,                        -- NUM_FILES_BACKED NUMBER
  num_distinct_files_backed,               -- NUM_DISTINCT_FILES_BACKED NUMBER
  min_modification_time,                   -- MIN_MODIFICATION_TIME DATE
  max_modification_time,                   -- MAX_MODIFICATION_TIME DATE
  input_bytes,                             -- INPUT_BYTES NUMBER
  sys.dbms_rcvman.num2displaysize(input_bytes) input_bytes_display -- INPUT_BYTES_DISPLAY VARCHAR2(4000)
from
  (
  select
    count(*) num_files_backed,
    min(modification_time)min_modification_time,
    max(modification_time) max_modification_time,
    sum(bytes) input_bytes
  from
    v$backup_spfile
  where
    (set_stamp, set_count) in (
    select
      set_stamp,
      set_count
    from
      v$backup_set_details)), (
  select
    count(*) num_distinct_files_backed
  from
    (
    select
      unique modification_time
    from
      v$backup_spfile
    where
      (set_stamp, set_count) in (
      select
        set_stamp,
        set_count
      from
        v$backup_set_details)))