Note
This view is available starting with V4.0.0.
Purpose
This view displays information about all XA transactions in the cluster.
Applicability
This view applies only to OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The tenant ID. |
| FORMATID | NUMBER(38) | NO | The transaction identifier format type. |
| GLOBALID | VARCHAR2(256) | NO | The global transaction identifier. |
| 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 node where the transaction scheduler is located. |
| SVR_PORT | NUMBER(38) | NO | The port number of the node where the transaction scheduler is located. |
| COORD_LS_ID | NUMBER(38) | YES | The ID of the coordinator log stream. |
| IS_READONLY | VARCHAR2(5) | NO | Whether the transaction is read-only. |
| STATE | VARCHAR2(12) | NO | The status of the branch. |
| FLAG | NUMBER(38) | NO | The numeric representation of the branch status. |