Note
This view is available starting with V2.2.77.
Functions
This view displays information about the current active global transactions.
Applicability
This view is available only in OceanBase Database Oracle mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| FORMATID | NUMBER(38) | NO | The format identifier of the global transaction. |
| GLOBALID | VARCHAR2(256) | NO | The IP address of the server. |
| BRANCHID | VARCHAR2(256) | NO | The port number of the server. |
| BRANCHES | NUMBER(38) | NO | The identifier of the global transaction. |
| REFCOUNT | NUMBER(38) | NO | The number of branches of the global transaction. |
| PREPARECOUNT | NUMBER | NO | The total number of branches in the global transaction. |
| STATE | CHAR(6) | NO | The number of siblings in the global transaction. Must be the same as the number of branches. |
| FLAGS | NUMBER | NO | The number of prepared branches in the global transaction. |
| COUPLING | CHAR(15) | NO | The status of the global transaction branch: |
| CON_ID | VARCHAR2(256) | NO | The numeric representation of the status. |