V$BLOCK_CHANGE_TRACKING

select
decode                   -- STATUS VARCHAR2(10)
  (di2ctst, 0, 'DISABLED', 1, 'TRANSITION', 2, 'ENABLED', 'ERROR'),
fnnam,                   -- FILENAME VARCHAR2(513)
fh.bytes                 -- BYTES NUMBER
from
x$kccdi2,
x$kccfn,
(
select
max (fhfsz*fhbsz) bytes 
from
x$krcfh) fh 
where
fnnum (+) =di2ctfn and fntyp (+) =200
home |  up  |  mailbox