GV$DBLINK

select
inst_id,                 -- INST_ID NUMBER
nconam,                  -- DB_LINK VARCHAR2(128)
ncouid,                  -- OWNER_ID NUMBER
decode                   -- LOGGED_ON VARCHAR2(3)
  (bitand (hstflg, 32), 0, 'NO', 'YES'),
decode                   -- HETEROGENEOUS VARCHAR2(3)
  (bitand (hstflg, 8), 0, 'NO', 'YES'),
decode                   -- PROTOCOL VARCHAR2(6)
  (hstpro, 1, 'V5', 2, 'V6', 3, 'V6_NLS', 4, 'V7', 'UNKN'),
ncouct,                  -- OPEN_CURSORS NUMBER
decode                   -- IN_TRANSACTION VARCHAR2(3)
  (bitand (ncoflg, 2), 0, 'NO', 'YES'),
decode                   -- UPDATE_SENT VARCHAR2(3)
  (bitand (ncoflg, 8), 0, 'NO', 'YES'),
nco2pstr                 -- COMMIT_POINT_STRENGTH NUMBER
from
x$uganco 
where
bitand (hstflg, 1) != 0
home |  up  |  mailbox