Note
This view is available starting with V4.2.1.
Overview
The GV$OB_TRANSACTION_SCHEDULERS view is used to query the transaction scheduler information of all servers.
Columns
Column |
Type |
Nullable |
Note |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| SVR_IP | varchar(46) | NO | IP Address of the Server Where the Replica Resides |
| SVR_PORT | bigint(20) | NO | Server Port of Replica |
| SESSION_ID | bigint(20) | NO | For V4.2.x versions:
|
| TX_ID | bigint(20) | NO | Transaction ID |
| STATE | varchar(18) | NO | Transaction Status |
| CLUSTER_ID | bigint(20) | NO | Unique cluster ID |
| COORDINATOR | bigint(20) | NO | Log Stream ID of the Coordinator |
| PARTICIPANTS | varchar(1024) | YES | Transaction participant information |
| ISOLATION_LEVEL | varchar(16) | NO | Isolation Level |
| SNAPSHOT_VERSION | bigint(20) unsigned | YES | Snapshot version for the RR or SERIAL isolation level. If not enabled, the value is -1. |
| ACCESS_MODE | varchar(10) | NO | Access mode (read-only or read/write) |
| TX_OP_SN | bigint(20) | NO | Transaction-level operation sequence number |
| ACTIVE_TIME | timestamp(6) | YES | Explicit or Implicit Start of Transaction Timestamp |
| EXPIRE_TIME | timestamp(6) | YES | Transaction Expiration Timestamp |
| CAN_EARLY_LOCK_RELEASE | varchar(7) | NO | Whether row locks can be released in advance |
| FORMATID | bigint(20) | NO | Format Identifier of Global Transactions |
| GLOBALID | varchar(257) | YES | Global Transaction Unique Identifier |
| BRANCHID | varchar(257) | YES | Unique identifier of a branch transaction |
Sample query
Query the transaction scheduler information of all servers.
obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_TRANSACTION_SCHEDULERS;