GV$DBLINK definition in Oracle 8i / www.oracledba.ru
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