GV$GLOBAL_TRANSACTION

select
inst_id,                 -- INST_ID NUMBER
K2GTIFMT,                -- FORMATID NUMBER
K2GTITID_EXT,            -- GLOBALID RAW(64)
K2GTIBID,                -- BRANCHID RAW(64)
K2GTECNT,                -- BRANCHES NUMBER
K2GTERCT,                -- REFCOUNT NUMBER
K2GTDPCT,                -- PREPARECOUNT NUMBER
decode                   -- STATE VARCHAR2(18)
  (K2GTDFLG, 0, 'ACTIVE', 1, 'COLLECTING', 2, 'FINALIZED', 4, 'FAILED', 8, 'RECOVERING', 16, 'UNASSOCIATED', 32, 'FORGOTTEN', 64, 'READY FOR RECOVERY', 'COMBINATION'),
K2GTDFLG,                -- FLAGS NUMBER
decode                   -- COUPLING VARCHAR2(15)
  (K2GTETYP, 0, 'FREE', 1, 'LOOSELY COUPLED', 2, 'TIGHTLY COUPLED') 
from
X$K2GTE2
home |  up  |  mailbox