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(1024)
  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(cap_other,0,'N',1,'Y')            -- MAP_SYNC VARCHAR2(1)
from
  x$ksfmlib