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-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 resides. |
| SVR_PORT | NUMBER(38) | NO | The port number of the node where the transaction scheduler resides. |
| COORD_LS_ID | NUMBER(38) | YES | The ID of the log stream 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. |