GV$MAP_FILE_EXTENT definition in Oracle Database 11.2
GV$MAP_FILE_EXTENT

select
  inst_id,                                 -- INST_ID NUMBER
  file_idx,                                -- FILE_MAP_IDX NUMBER
  ext_num,                                 -- EXT_NUM NUMBER
  ext_dev_off,                             -- EXT_ELEM_OFF NUMBER
  ext_size,                                -- EXT_SIZE NUMBER
  ext_file_off,                            -- EXT_FILE_OFF NUMBER
  decode(                                  -- EXT_TYPE VARCHAR2(6)
    ext_type,1,'DATA', 2,'PARITY',3,'NONE'),
  elem_idx                                 -- ELEM_IDX NUMBER
from
  x$ksfmfileext
where
  elem_idx != 4294967295

home |  up