V$PROXY_ARCHIVELOG_SUMMARY definition in Oracle Database 11.2
V$PROXY_ARCHIVELOG_SUMMARY
select
nvl(num_files_backed, 0), -- NUM_FILES_BACKED NUMBER
distinct_files_backed, -- NUM_DISTINCT_FILES_BACKED NUMBER
min_first_change#, -- MIN_FIRST_CHANGE# NUMBER
max_next_change#, -- MAX_NEXT_CHANGE# NUMBER
min_first_time, -- MIN_FIRST_TIME DATE
max_next_time, -- MAX_NEXT_TIME DATE
output_bytes, -- OUTPUT_BYTES NUMBER
sys.dbms_rcvman.num2displaysize(output_bytes) output_bytes_display -- OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
from
(
select
count(*) num_files_backed,
min(first_change#)min_first_change#,
max(next_change#) max_next_change#,
min(first_time)min_first_time,
max(next_time) max_next_time,
sum((blocks+1)*block_size) output_bytes
from
v$proxy_archivedlog a,
v$rman_status b,
(
select
/*+ no_merge */ sys.dbms_rcvman.sv_getsessionkey skey
from
dual)c, (
select
/*+ no_merge */ sys.dbms_rcvman.sv_getsessionfromTimeRange fTime
from
dual) d, (
select
/*+ no_merge */ sys.dbms_rcvman.sv_getsessionuntilTimeRange uTime
from
dual) e
where
a.status = 'A' and a.rman_status_recid = b.recid (+) and a.rman_status_stamp = b.stamp (+) and (c.skey is null or c.skey = b.session_recid) and (d.fTime is null or d.fTime <= b.start_time) and (e.uTime is null or e.uTime >= b.end_time)), (
select
count(*) distinct_files_backed
from
(
select
unique thread#,
sequence#,
resetlogs_change#,
resetlogs_time
from
v$proxy_archivedlog a,
v$rman_status b,
(
select
/*+ no_merge */ sys.dbms_rcvman.sv_getsessionkey skey
from
dual)c, (
select
/*+ no_merge */ sys.dbms_rcvman.sv_getsessionfromTimeRange fTime
from
dual) d, (
select
/*+ no_merge */ sys.dbms_rcvman.sv_getsessionuntilTimeRange uTime
from
dual) e
where
a.status = 'A' and a.rman_status_recid = b.recid (+) and a.rman_status_stamp = b.stamp (+) and (c.skey is null or c.skey = b.session_recid) and (d.fTime is null or d.fTime <= b.start_time) and (e.uTime is null or e.uTime >= b.end_time)))