Overview
The V$OB_TRANSACTION_PARTICIPANTS view displays information about transaction participants on all OBServer nodes.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| SVR_IP | varchar(46) | NO | Server IP Address |
| SVR_PORT | bigint(20) | NO | Server Port Number |
| SESSION_ID | bigint(20) | NO |
|
| SCHEDULER_ADDR | varchar(64) | NO | Node Address of the Scheduler |
| TX_TYPE | varchar(11) | NO | Transaction type |
| TX_ID | bigint(20) | NO | Transaction ID |
| LS_ID | bigint(20) | NO | Log Stream ID |
| PARTICIPANTS | varchar(1024) | NO | Participants |
| CTX_CREATE_TIME | timestamp(6) | NO | Context Creation Time |
| TX_EXPIRED_TIME | timestamp(6) | NO | Transaction Timeout Point |
| STATE | varchar(13) | NO | Context Commit Status |
| ACTION | varchar(10) | NO | Previous Action |
| PENDING_LOG_SIZE | bigint(20) | NO | Size of data to be persisted, in bytes |
| FLUSHED_LOG_SIZE | bigint(20) | NO | Size of persisted data, in bytes |
| ROLE | varchar(8) | NO | Context role |
| COORD | bigint(20) | NO | Corresponding coordinator IS ID (effective only after entering the commit phase) |
| LAST_REQUEST_TIME | timestamp(6) | NO | Last Time External Request Received |
| FORMATID | bigint(20) | NO | XID Format |
| GLOBALID | varchar(257) | NO | Global XA Transaction Identifier |
| BRANCHID | varchar(257) | NO | XA Transaction Branch Identifier |
Sample query
Query transaction participant information on all OBServer nodes.
obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_TRANSACTION_PARTICIPANTS LIMIT 1\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1
SVR_IP: xx.xx.xx.xx
SVR_PORT: 2882
SESSION_ID: 1
SCHEDULER_ADDR: "xx.xx.xx.xx:2882"
TX_TYPE: LOCAL
TX_ID: 4054554
LS_ID: 1
PARTICIPANTS: [{id:1}]
CTX_CREATE_TIME: 2025-04-27 15:31:49.437256
TX_EXPIRED_TIME: 2025-04-27 15:32:19.437243
STATE: ACTIVE
ACTION: COMMIT
PENDING_LOG_SIZE: 0
FLUSHED_LOG_SIZE: 77
ROLE: LEADER
COORD: 1
LAST_REQUEST_TIME: 2025-04-27 15:31:49.437256
FORMATID: -1
GLOBALID: NULL
BRANCHID: NULL