Purpose
The GV$OB_GLOBAL_TRANSACTION view displays information about all XA transactions in the cluster.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The ID of the tenant. |
| FORMATID | NUMBER(38) | NO | The format type of the transaction identifier. |
| GLOBALID | VARCHAR2(256) | NO | The transaction identifier of the global transaction. |
| BRANCHID | VARCHAR2(256) | NO | The branch qualifier. |
| TX_ID | NUMBER(38) | NO | The transaction ID. |
| SVR_IP | VARCHAR2(128) | NO | The IP address of the OBServer node that hosts the transaction scheduler. |
| SVR_PORT | NUMBER(38) | NO | The port number of the OBServer node that hosts the transaction scheduler. |
| COORD_LS_ID | NUMBER(38) | YES | The ID of the coordinator log stream. |
| IS_READONLY | VARCHAR2(5) | NO | Indicates whether the transaction is read-only. |
| STATE | VARCHAR2(12) | NO | The status of the branch. |
| FLAG | NUMBER(38) | NO | The numeric representation of the status of the branch. |