V$MAP_ELEMENT

V$MAP_ELEMENT displays 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 the 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

  • 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