select fn.addr, fn.indx, fn.inst_id, fn.con_id, fn.fnnum, fn.fntyp, -- 4 = data file? fn.fnfno, -- File number, join with sys.file$.file# or x$kcvfh.hxfil fn.fnfwd, fn.fnbwd, fn.fnflg, fn.fnnam, fn.fnonm, fn.fnbof, -- Block size? fn.fnunn, fn.bytes from x$kccfn fn;