select
  inst_id,                                 -- INST_ID NUMBER
  fnfno,                                   -- FILE# NUMBER
  fnnam                                    -- NAME VARCHAR2(513)
from
  x$kccfn
where
  fnnam is not null and bitand(fnflg, 4) != 4 and fntyp=4