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(38)
    K2GTDFLG, 0, 'ACTIVE', 1, 'COLLECTING', 2, 'FINALIZED', 4, 'FAILED', 8, 'RECOVERING', 16, 'UNASSOCIATED', 32, 'FORGOTTEN', 64, 'READY FOR RECOVERY', 128, 'NO-READONLY FAILED', 256, 'SIBLING INFO WRITTEN', 512, '[ORACLE COORDINATED]ACTIVE', 512+1, '[ORACLE COORDINATED]COLLECTING', 512+2, '[ORACLE COORDINATED]FINALIZED', 512+4, '[ORACLE COORDINATED]FAILED', 512+8, '[ORACLE COORDINATED]RECOVERING', 512+16, '[ORACLE COORDINATED]UNASSOCIATED', 512+32, '[ORACLE COORDINATED]FORGOTTEN', 512+64, '[ORACLE COORDINATED]READY FOR RECOVERY', 512+128, '[ORACLE COORDINATED]NO-READONLY FAILED', 1024, '[MULTINODE]ACTIVE', 1024+1, '[MULTINODE]COLLECTING', 1024+2, '[MULTINODE]FINALIZED', 1024+4, '[MULTINODE]FAILED', 1024+8, '[MULTINODE]RECOVERING', 1024+16, '[MULTINODE]UNASSOCIATED', 1024+32, '[MULTINODE]FORGOTTEN', 1024+64, '[MULTINODE]READY FOR RECOVERY', 1024+128, '[MULTINODE]NO-READONLY FAILED', 1024+256, '[MULTINODE]SIBLING INFO WRITTEN', 'COMBINATION'),
  K2GTDFLG,                                -- FLAGS NUMBER
  decode (                                 -- COUPLING VARCHAR2(15)
    K2GTETYP, 0, 'FREE', 1, 'LOOSELY COUPLED', 2, 'TIGHTLY COUPLED') 
from
  X$K2GTE2