select
  CHILD_IDX,                               -- CHILD_IDX NUMBER
  PARENT_IDX,                              -- PARENT_IDX NUMBER
  SUB_NUM,                                 -- SUB_NUM NUMBER
  SUB_SIZE,                                -- SUB_SIZE NUMBER
  ELEM_OFFSET,                             -- ELEM_OFFSET NUMBER
  SUB_FLAGS                                -- SUB_FLAGS NUMBER
from
  gv$map_subelement
where
  inst_id = USERENV('Instance')