Purpose
The V$OB_GLOBAL_TRANSACTION view provides information about all XA transactions whose original scheduler is the current OBServer node.
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) | NO | 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. |