7.246 V$GLOBAL_TRANSACTION

V$GLOBAL_TRANSACTION displays information on the currently active global transactions.

Column	Datatype	Description
FORMATID	NUMBER	Format identifier of the global transaction
GLOBALID	RAW(64)	Global transaction identifier of the global transaction
BRANCHID	RAW(64)	Branch qualifier of the global transaction
BRANCHES	NUMBER	Total number of branches in the global transaction
REFCOUNT	NUMBER	Number of siblings for the global transaction (must be the same as branches)
PREPARECOUNT	NUMBER	Number of branches of the global transaction that have prepared
STATE	VARCHAR2(38)	State of the branch of the global transaction: ACTIVE COLLECTING FINALIZED FAILED RECOVERING UNASSOCIATED FORGOTTEN READY FOR RECOVERY NO-READONLY FAILED SIBLING INFO WRITTEN [ORACLE COORDINATED]ACTIVE [ORACLE COORDINATED]COLLECTING [ORACLE COORDINATED]FINALIZED [ORACLE COORDINATED]FAILED [ORACLE COORDINATED]RECOVERING [ORACLE COORDINATED]UNASSOCIATED [ORACLE COORDINATED]FORGOTTEN [ORACLE COORDINATED]READY FOR RECOVERY [ORACLE COORDINATED]NO-READONLY FAILED [MULTINODE]ACTIVE [MULTINODE]COLLECTING [MULTINODE]FINALIZED [MULTINODE]FAILED [MULTINODE]RECOVERING [MULTINODE]UNASSOCIATED [MULTINODE]FORGOTTEN [MULTINODE]READY FOR RECOVERY [MULTINODE]NO-READONLY FAILED [MULTINODE]SIBLING INFO WRITTEN COMBINATION
FLAGS	NUMBER	The numeric representation of the state
COUPLING	VARCHAR2(15)	Indicates whether the branches are free (FREE), loosely coupled (LOOSELY COUPLED), or tightly coupled (TIGHTLY COUPLED)
CON_ID	NUMBER	The ID of the container to which the data pertains. Possible values include: 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. 1: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data