select
  FORMATID,                                -- FORMATID NUMBER
  GLOBALID,                                -- GLOBALID RAW(64)
  BRANCHID,                                -- BRANCHID RAW(64)
  BRANCHES,                                -- BRANCHES NUMBER
  REFCOUNT,                                -- REFCOUNT NUMBER
  PREPARECOUNT,                            -- PREPARECOUNT NUMBER
  STATE,                                   -- STATE VARCHAR2(38)
  FLAGS,                                   -- FLAGS NUMBER
  COUPLING                                 -- COUPLING VARCHAR2(15)
from
  GV$GLOBAL_TRANSACTION
where
  INST_ID = USERENV('Instance')