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