Purpose
The GV$OB_GLOBAL_TRANSACTION view displays information about all XA transactions in the current 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 ID of the transaction. |
| 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. |