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
home |  up  |  mailbox