Purpose
The GV$OB_GLOBAL_TRANSACTION view provides information about all XA transactions in the cluster.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the 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. |