GV$MAP_LIBRARY definition in Oracle Database 10.2 / www.oracledba.ru
GV$MAP_LIBRARY
select
inst_id, -- INST_ID NUMBER
lib_idx, -- LIB_IDX NUMBER
lib_name, -- LIB_NAME VARCHAR2(256)
vendor_name, -- VENDOR_NAME VARCHAR2(64)
protocol_num, -- PROTOCOL_NUM NUMBER
version_num, -- VERSION_NUM VARCHAR2(32)
path_name, -- PATH_NAME VARCHAR2(4000)
decode -- MAP_FILE VARCHAR2(1)
(bitand (cap_file, 1), 0, 'N', 1, 'Y'),
decode -- FILE_CFGID VARCHAR2(13)
(bitand (cap_file, 6), 0, 'NONE', 6, 'PERSISTENT', 2, 'NONPERSISTENT'),
decode -- MAP_ELEM VARCHAR2(1)
(bitand (cap_elem, 1), 0, 'N', 1, 'Y'),
decode -- ELEM_CFGID VARCHAR2(13)
(bitand (cap_elem, 6), 0, 'NONE', 6, 'PERSISTENT', 4, 'NONPERSISTENT'),
decode -- MAP_SYNC VARCHAR2(1)
(cap_other, 0, 'N', 1, 'Y')
from
x$ksfmlib