V$MAP_FILE_IO_STACK definition in Oracle Database 11.2
V$MAP_FILE_IO_STACK

select
  FILE_MAP_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
  ELEM_OFFSET,                             -- ELEM_OFFSET NUMBER
  FILE_OFFSET,                             -- FILE_OFFSET NUMBER
  DATA_TYPE,                               -- DATA_TYPE VARCHAR2(15)
  PARITY_POS,                              -- PARITY_POS NUMBER
  PARITY_PERIOD,                           -- PARITY_PERIOD NUMBER
  ID,                                      -- ID NUMBER
  PARENT_ID                                -- PARENT_ID NUMBER
from
  gv$map_file_io_stack
where
  inst_id = USERENV('Instance')

home |  up