select
FILE_MAP_IDX, -- FILE_MAP_IDX NUMBER
FILE_CFGID, -- FILE_CFGID VARCHAR2(256)
FILE_STATUS, -- FILE_STATUS VARCHAR2(7)
FILE_NAME, -- FILE_NAME VARCHAR2(256)
FILE_TYPE, -- FILE_TYPE VARCHAR2(11)
FILE_STRUCTURE, -- FILE_STRUCTURE VARCHAR2(9)
FILE_SIZE, -- FILE_SIZE NUMBER
FILE_NEXTS, -- FILE_NEXTS NUMBER
LIB_IDX -- LIB_IDX NUMBER
from
gv$map_file
where
inst_id = USERENV('Instance')