Note
This view is available starting with V4.0.0.
Purpose
This view displays the information about active transaction participants of the current tenant on all OBServer nodes.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The tenant ID. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server. |
| SESSION_ID | NUMBER(38) | NO | For V4.2.x:
|
| SCHEDULER_ADDR | VARCHAR2(64) | NO | The IP address of the scheduler node. |
| TX_TYPE | VARCHAR2(11) | NO | The type of the transaction. |
| TX_ID | NUMBER(38) | NO | The transaction ID. |
| LS_ID | NUMBER(38) | NO | The ID of the log stream to which the transaction belongs. |
| PARTICIPANTS | VARCHAR2(1024) | NO | The list of participants. |
| CTX_CREATE_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | YES | The time when the context was created. |
| TX_EXPIRED_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | YES | The time when the transaction expired. |
| STATE | VARCHAR2(9) | NO | The context submission status. |
| ACTION | VARCHAR2(10) | NO | The last executed action. |
| PENDING_LOG_SIZE | NUMBER(38) | NO | The size of data to be persisted. |
| FLUSHED_LOG_SIZE | NUMBER(38) | NO | The size of data that has been persisted. |
| IS_EXITING | VARCHAR2(3) | NO | Indicates whether the context is exiting. |
| ROLE | VARCHAR2(8) | NO | The context role. |
| COORD | NUMBER(38) | NO | The ID of the corresponding coordinator (effective only after the transaction enters the commit phase). |
| LAST_REQUEST_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | YES | The time when the last external request was received. |
| FORMATID | NUMBER(38) | NO | The format type of the xid. |
| GLOBALID | VARCHAR2(256) | NO | The global identifier of the XA transaction. |
| BRANCHID | VARCHAR2(256) | NO | The branch qualifier of the XA transaction. |
Sample query
Query the information about active transaction participants of the current tenant on all nodes.
obclient [SYS]> SELECT * FROM SYS.GV$OB_TRANSACTION_PARTICIPANTS\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1004
SVR_IP: 11.xxx.xxx.xxx
SVR_PORT: 28825
SESSION_ID: 3221613842
SCHEDULER_ADDR: "11.xxx.xxx.xxx:28825"
TX_TYPE: UNDECIDED
TX_ID: 1928779
LS_ID: 1001
PARTICIPANTS: NULL
CTX_CREATE_TIME: 26-MAR-25 03.26.35.414104 PM
TX_EXPIRED_TIME: 27-MAR-25 03.26.35.414104 PM
STATE: ACTIVE
ACTION: START
PENDING_LOG_SIZE: 57
FLUSHED_LOG_SIZE: 0
ROLE: LEADER
COORD: -1
LAST_REQUEST_TIME: 26-MAR-25 03.26.35.414104 PM
FORMATID: -1
GLOBALID: NULL
BRANCHID: NULL
1 row in set