Note
This view is introduced in V4.2.1.
Purpose
The GV$OB_TRANSACTION_SCHEDULERS view is used to query the transaction scheduler information on all servers.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| SVR_IP | varchar(46) | NO | The IP address of the server where the replica is located. |
| SVR_PORT | bigint(20) | NO | The server port where the replica resides. |
| SESSION_ID | bigint(20) | NO | For V4.2.x:
|
| TX_ID | bigint(20) | NO | Transaction ID |
| STATE | varchar(18) | NO | Transaction status |
| CLUSTER_ID | bigint(20) | NO | The unique ID of the cluster. |
| COORDINATOR | bigint(20) | NO | The log stream ID where the coordinator resides. |
| PARTICIPANTS | varchar(1024) | YES | The participants of the transaction. |
| ISOLATION_LEVEL | varchar(16) | NO | Isolation level |
| SNAPSHOT_VERSION | bigint(20) unsigned | YES | The snapshot version when read-only or serializable isolation level is enabled. The value is -1 if not enabled. |
| ACCESS_MODE | varchar(10) | NO | The access mode (read-only or read/write). |
| TX_OP_SN | bigint(20) | NO | The operation sequence number at the transaction level. |
| ACTIVE_TIME | timestamp(6) | YES | The timestamp when the transaction is explicitly or implicitly started. |
| EXPIRE_TIME | timestamp(6) | YES | The transaction expiration timestamp. |
| CAN_EARLY_LOCK_RELEASE | varchar(7) | NO | Whether early lock release is supported |
| FORMATID | bigint(20) | NO | The format identifier of the global transaction. |
| GLOBALID | varchar(257) | YES | The global transaction unique identifier. |
| BRANCHID | varchar(257) | YES | A unique identifier of the branch transaction. |
Examples
obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_TRANSACTION_SCHEDULERS;