V$MAP_SUBELEMENT contains 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 child element |
PARENT_IDX |
NUMBER |
Index in V$MAP_ELEMENT corresponding to parent element |
SUB_NUM |
NUMBER |
Subelement number |
SUB_SIZE |
NUMBER |
Subelement size in HKB |
ELEM_OFFSET |
NUMBER |
Offset in HKB on child element |
SUB_FLAGS |
NUMBER |
Subelement flags (currently unused) |