GV$MAP_FILE_IO_STACK definition in Oracle Database 11.2
GV$MAP_FILE_IO_STACK

select
  inst_id,                                 -- INST_ID NUMBER
  file_idx,                                -- FILE_MAP_IDX NUMBER
  depth,                                   -- DEPTH NUMBER
  elem_idx,                                -- ELEM_IDX NUMBER
  cu_size,                                 -- CU_SIZE NUMBER
  stride,                                  -- STRIDE NUMBER
  num_cu,                                  -- NUM_CU NUMBER
  dev_offset,                              -- ELEM_OFFSET NUMBER
  to_number(                               -- FILE_OFFSET NUMBER
    decode(file_offset,4294967295,NULL,file_offset)),
  decode(                                  -- DATA_TYPE VARCHAR2(15)
    data_type,1,'DATA',2,'PARITY',3,'DATA AND PARITY'),
  parity_pos,                              -- PARITY_POS NUMBER
  parity_perd,                             -- PARITY_PERIOD NUMBER
  row_id,                                  -- ID NUMBER
  prow_id                                  -- PARENT_ID NUMBER
from
  x$ksfmiost

home |  up