V$GLOBAL_TRANSACTION

V$GLOBAL_TRANSACTION displays information about currently active global transactions. By default, only the system administrator can access this view. Common users can access the view only after being authorized. 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. Not supported. Set it to NULL.
globalid	raw	Global transaction identifier.
branchid	raw	Global transaction branch identifier. 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)	Indicates whether the branch is free (`FREE`), loosely coupled (`LOOSELY COUPLED`), or tightly coupled (TIGHTLY COUPLED). Not supported. Set it to NULL.
con_id	numeric	ID of the container related to data. Not supported. Set it to 0.