select
ELEM_NAME, -- ELEM_NAME VARCHAR2(256)
ELEM_IDX, -- ELEM_IDX NUMBER
ELEM_CFGID, -- ELEM_CFGID VARCHAR2(256)
ELEM_TYPE, -- ELEM_TYPE VARCHAR2(12)
ELEM_SIZE, -- ELEM_SIZE NUMBER
ELEM_NSUBELEM, -- ELEM_NSUBELEM NUMBER
ELEM_DESCR, -- ELEM_DESCR VARCHAR2(256)
STRIPE_SIZE, -- STRIPE_SIZE NUMBER
LIB_IDX -- LIB_IDX NUMBER
from
gv$map_element
where
inst_id = USERENV('Instance')