V$GLOBAL_TRANSACTION

V$GLOBAL_TRANSACTION displays information about currently active global transactions. By default, only the system administrator can access the system view. Common users must be authorized to access the system view. This view exists in the PG_CATALOG and SYS schemas.

**Table 1** V$GLOBAL_TRANSACTION columns
Name	Type	Description
formatid	numeric	Global transaction format identifier. If this parameter is not supported, set it to NULL.
globalid	raw	Global transaction identifier.
branchid	raw	Global transaction branch identifier. If this parameter is not supported, set it to NULL. Each individual transaction of a global transaction is called a branch.
branches	numeric	Total number of global transaction branches.
refcount	numeric	Number of siblings for the global transaction (must be the same as branches).
preparecount	numeric	Number of prepared global transaction branches. If the value of system_view_version is greater than 0 and no prepared global transaction branch exists, the value is 0. Otherwise, the value is NULL.
state	character varying(38)	Status of the global transaction branch.
flags	numeric	Numeric representation of the status.
coupling	character varying(15)	Specifies whether the branch is free (`FREE`), loosely coupled (`LOOSELY COUPLED`), or tightly coupled (TIGHTLY COUPLED). If this parameter is not supported, set it to NULL.
con_id	numeric	ID of the container related to data. If this parameter is not supported, set it to 0.