GV$MAP_SUBELEMENT

select
inst_id,                 -- INST_ID NUMBER
child_idx,               -- CHILD_IDX NUMBER
parent_idx,              -- PARENT_IDX NUMBER
sub_num,                 -- SUB_NUM NUMBER
to_number                -- SUB_SIZE NUMBER
  (decode (sub_size, 4294967295, NULL, sub_size)),
to_number                -- ELEM_OFFSET NUMBER
  (decode (elem_offset, 4294967295, NULL, elem_offset)),
sub_flags                -- SUB_FLAGS NUMBER
from
x$ksfmsubelem 
where
child_idx != 4294967295
home |  up  |  mailbox