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 is available only for OceanBase Database in Oracle-compatible 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 log stream ID of the coordinator. |
| 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 branch state. |