select
  DB_LINK,                                 -- DB_LINK VARCHAR2(128)
  OWNER_ID,                                -- OWNER_ID NUMBER
  LOGGED_ON,                               -- LOGGED_ON VARCHAR2(3)
  HETEROGENEOUS,                           -- HETEROGENEOUS VARCHAR2(3)
  PROTOCOL,                                -- PROTOCOL VARCHAR2(6)
  OPEN_CURSORS,                            -- OPEN_CURSORS NUMBER
  IN_TRANSACTION,                          -- IN_TRANSACTION VARCHAR2(3)
  UPDATE_SENT,                             -- UPDATE_SENT VARCHAR2(3)
  COMMIT_POINT_STRENGTH                    -- COMMIT_POINT_STRENGTH NUMBER
from
  GV$DBLINK
where
  inst_id = USERENV('Instance')