Note
This view is available starting with V4.0.0.
Purpose
This view displays information about all XA transactions with the current node as the original Scheduler.
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) | NO | The ID of the coordinator log stream. |
| IS_READONLY | VARCHAR2(5) | NO | Whether the transaction is a read-only transaction. |
| STATE | VARCHAR2(12) | NO | The status of the branch. |
| FLAG | NUMBER(38) | NO | The numeric representation of the branch status. |