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 both PG_CATALOG and SYS schema.

**Table 1** V$GLOBAL_TRANSACTION columns
Name	Type	Description
formatid	numeric	Global transaction format identifier. Not supported. Its value is NULL.
globalid	raw	Global transaction identifier.
branchid	raw	Global transaction branch identifier. Not supported. Its value is 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). Not supported. Its value is NULL.
con_id	numeric	ID of the container related to data. Not supported. Its value is 0.