GV$MAP_FILE

select
inst_id,                 -- INST_ID NUMBER
file_idx,                -- FILE_MAP_IDX NUMBER
file_cfgid,              -- FILE_CFGID VARCHAR2(256)
decode                   -- FILE_STATUS VARCHAR2(7)
  (file_status, 1, 'VALID', 2, 'INVALID'),
file_name,               -- FILE_NAME VARCHAR2(256)
decode                   -- FILE_TYPE VARCHAR2(11)
  (file_type, 1, 'DATAFILE', 2, 'SPFILE', 3, 'TEMPFILE', 4, 'CONTROLFILE', 5, 'LOGFILE', 6, 'ARCHIVEFILE'),
decode                   -- FILE_STRUCTURE VARCHAR2(9)
  (file_struct, 1, 'FILE', 2, 'RAWVOLUME', 3, 'RAWDEVICE', 4, 'NONE'),
file_size,               -- FILE_SIZE NUMBER
file_nexts,              -- FILE_NEXTS NUMBER
to_number                -- LIB_IDX NUMBER
  (decode (lib_idx, 4294967295, NULL, lib_idx)) 
from
x$ksfmfile
home |  up  |  mailbox