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
CON_ID NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data