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