GV$MAP_ELEMENT
select inst_id, -- INST_ID NUMBER elem_name, -- ELEM_NAME VARCHAR2(256) elem_idx, -- ELEM_IDX NUMBER elem_cfgid, -- ELEM_CFGID VARCHAR2(256) decode -- ELEM_TYPE VARCHAR2(12) (elem_type, 1, 'MIRROR', 2, 'STRIPE', 3, 'RAID5', 4, 'CONCATENATED', 5, 'PARTITION', 6, 'DISK', 7, 'NONE'), to_number -- ELEM_SIZE NUMBER (decode (elem_size, 4294967295, NULL, elem_size)), elem_nsubelem, -- ELEM_NSUBELEM NUMBER elem_descr, -- ELEM_DESCR VARCHAR2(256) stripe_size, -- STRIPE_SIZE NUMBER to_number -- LIB_IDX NUMBER (decode (lib_idx, 4294967295, NULL, lib_idx)) from x$ksfmelem

home |  up  |  mailbox