V$BACKUP_SPFILE_DETAILS

select
unique                   -- SESSION_KEY NUMBER
  b.session_recid session_key,
b.session_recid,         -- SESSION_RECID NUMBER
b.session_stamp,         -- SESSION_STAMP NUMBER
b.recid bs_key,          -- BS_KEY NUMBER
a.set_stamp,             -- SET_STAMP NUMBER
b.set_count,             -- SET_COUNT NUMBER
modification_time,       -- MODIFICATION_TIME DATE
a.bytes,                 -- FILESIZE NUMBER
sys.dbms_rcvman.num2displaysize -- FILESIZE_DISPLAY VARCHAR2(4000)
  (a.bytes) filesize_display 
from
v$backup_spfile a,
v$backup_set_details b 
where
a.set_stamp = b.set_stamp and a.set_count = b.set_count
home |  up  |  mailbox