Purpose
This view displays information about all XA transactions with the current node as the original Scheduler.
Applicability
This view is available starting with OceanBase Database.
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 | 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. |