Note
This view is available starting with V2.2.77.
Purpose
This view displays information about active global transactions on the current node.
Applicability
This view is applicable only to OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| FORMATID | NUMBER(38) | NO | The format identifier of the global transaction. |
| GLOBALID | VARCHAR2(256) | NO | The IP address of the server. |
| BRANCHID | VARCHAR2(256) | NO | The port number of the server. |
| BRANCHES | NUMBER(38) | NO | The identifier of the global transaction. |
| REFCOUNT | NUMBER(38) | NO | The number of branches of the global transaction. |
| PREPARECOUNT | NUMBER | NO | The total number of branches in the global transaction. |
| STATE | CHAR(6) | NO | The number of global transaction branches, which must be the same as the number of branches. |
| FLAGS | NUMBER | NO | The number of prepared global transaction branches. |
| COUPLING | CHAR(15) | NO | The status of the global transaction branch:
|
| CON_ID | VARCHAR2(256) | NO | The numeric representation of the status. |