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')