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')