V$PROXY_ARCHIVELOG_DETAILS

select
a.*,                     -- SESSION_KEY NUMBER
sys.dbms_rcvman.num2displaysize -- SESSION_RECID NUMBER
  (output_bytes) output_bytes_display 
from
(
select
b.session_recid session_key,
b.session_recid,
b.session_stamp,
a.recid copy_key,
a.thread#,
a.sequence#,
a.resetlogs_change#,
a.resetlogs_time,
a.handle,
a.media,
a.media_pool,
a.tag,
a.first_change#,
a.next_change#,
a.first_time,
a.next_time,
(a.blocks+1) *a.block_size output_bytes,
a.completion_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)) a
home |  up  |  mailbox