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