SELECT
  SID,                                     -- SID NUMBER
  SERIAL#,                                 -- SERIAL# NUMBER
  NAME,                                    -- NAME VARCHAR2(71)
  DBLINK,                                  -- DBLINK VARCHAR2(128)
  STATE,                                   -- STATE VARCHAR2(12)
  XID,                                     -- XID VARCHAR2(22)
  SEQUENCE                                 -- SEQUENCE NUMBER
FROM
  GV$REPLPROP
WHERE
  INST_ID = USERENV('Instance')