GV$DBFILE

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
home |  up  |  mailbox