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 |