Note
This view is available starting with V4.0.0.
Purpose
This view displays the participant information of active transactions in the current tenant on the current OBServer node.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| SVR_IP | varchar(46) | NO | The IP address of the server. |
| SVR_PORT | bigint(20) | NO | The port number of the server. |
| SESSION_ID | bigint(20) | NO | For V4.2.x:
|
| SCHEDULER_ADDR | varchar(64) | NO | The IP address of the node where the scheduler is located. |
| TX_TYPE | varchar(11) | NO | The transaction type. |
| TX_ID | bigint(20) | NO | The transaction ID. |
| LS_ID | bigint(20) | NO | The ID of the log stream to which the transaction belongs. |
| PARTICIPANTS | varchar(1024) | NO | The participant list. |
| CTX_CREATE_TIME | timestamp(6) | NO | The time when the context was created. |
| TX_EXPIRED_TIME | timestamp(6) | NO | The time when the transaction expires. |
| STATE | varchar(13) | NO | The context submission status. |
| ACTION | varchar(10) | NO | The last executed action. |
| PENDING_LOG_SIZE | bigint(20) | NO | The size of data to be persisted. |
| FLUSHED_LOG_SIZE | bigint(20) | NO | The size of data that has been persisted. |
| ROLE | varchar(8) | NO | The context role. |
| COORD | bigint(20) | NO | The IS ID of the corresponding coordinator (effective only after entering the commit phase). |
| LAST_REQUEST_TIME | timestamp(6) | NO | The time when the last external request was received. |
| FORMATID | bigint(20) | NO | The xid format type. |
| GLOBALID | varchar(257) | NO | The global identifier of the XA transaction. |
| BRANCHID | varchar(257) | NO | The branch qualifier of the XA transaction. |
Sample query
In the user tenant, query the participant information of active transactions in the tenant on all nodes.
obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_TRANSACTION_PARTICIPANTS\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1002
SVR_IP: 11.xxx.xxx.xxx
SVR_PORT: 28825
SESSION_ID: 3221639466
SCHEDULER_ADDR: "11.xxx.xxx.xxx:28825"
TX_TYPE: UNDECIDED
TX_ID: 1765306
LS_ID: 1001
PARTICIPANTS: NULL
CTX_CREATE_TIME: 2025-03-26 15:16:28.584257
TX_EXPIRED_TIME: 2025-03-27 15:14:53.970599
STATE: ACTIVE
ACTION: START
PENDING_LOG_SIZE: 86
FLUSHED_LOG_SIZE: 0
ROLE: LEADER
COORD: -1
LAST_REQUEST_TIME: 2025-03-26 15:16:28.584257
FORMATID: -1
GLOBALID: NULL
BRANCHID: NULL
1 row in set