Note
This view is available starting with V4.0.0.
Purpose
This view displays information about all XA transactions whose original scheduler is the current node.
Applicability
This view is applicable 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 type of the transaction identifier format. |
| 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) | 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. |