Feature
This view displays 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 MySQL mode.
Fields
| Field | 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) | 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 state of the branch. |
| FLAG | NUMBER(38) | NO | The numeric representation of the state of the branch. |