| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
V$MAP_SUBELEMENT displays a list of all subelement mapping structures in the shared memory of the instance.
| Column | Datatype | Description | 
|---|---|---|
CHILD_IDX | 
NUMBER | 
Index in V$MAP_ELEMENT corresponding to the child element | 
PARENT_IDX | 
NUMBER | 
Index in V$MAP_ELEMENT corresponding to the parent element | 
SUB_NUM | 
NUMBER | 
Subelement number | 
SUB_SIZE | 
NUMBER | 
Subelement size in HKB | 
ELEM_OFFSET | 
NUMBER | 
Offset in HKB on the child element | 
SUB_FLAGS | 
NUMBER | 
Subelement flags (currently unused) |