V$MAP_ELEMENT contains a list of all element mapping structures in the SGA of the instance.
| Column | Datatype | Description |
|---|---|---|
ELEM_NAME |
VARCHAR2(256) |
Element name |
ELEM_IDX |
NUMBER |
Index corresponding to element |
ELEM_CFGID |
VARCHAR2(256) |
Configuration ID: N/A if configuration ID is not supported |
ELEM_TYPE |
VARCHAR2(12) |
Element type (MIRROR, STRIPE, RAID5, CONCATENATED, PARTITION, DISK, or NONE) |
ELEM_SIZE |
NUMBER |
Element Size in HKB |
ELEM_NSUBELEM |
NUMBER |
Number of Subelements |
ELEM_DESCR |
VARCHAR2(256) |
Element Description |
STRIPE_SIZE |
NUMBER |
Stripe Size in HKB for RAID-5 and STRIPE elements, 0 for the remaining types |
LIB_IDX |
NUMBER |
Index of the library which claims ownership of the element |