Note
This view is available starting with V4.2.1.
Purpose
V$OB_TRANSACTION_SCHEDULERS is used to query the transaction scheduler information of all servers.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| SVR_IP | varchar(46) | NO | The IP address of the server where the replica is located. |
| SVR_PORT | bigint(20) | NO | The port of the server where the replica is located. |
| SESSION_ID | bigint(20) | NO | For V4.3.x:
|
| TX_ID | bigint(20) | NO | The transaction ID. |
| STATE | varchar(18) | NO | The transaction state. |
| CLUSTER_ID | bigint(20) | NO | The unique ID of the cluster. |
| COORDINATOR | bigint(20) | NO | The log stream ID of the coordinator. |
| PARTICIPANTS | varchar(1024) | NO | The information about the participants of the transaction. |
| ISOLATION_LEVEL | varchar(16) | NO | The isolation level. |
| SNAPSHOT_VERSION | bigint(20) unsigned | NO | The snapshot version when the RR or SERIAL isolation level is enabled. -1 is returned when the isolation level is 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) | NO | The timestamp when the transaction was explicitly or implicitly started. |
| EXPIRE_TIME | timestamp(6) | NO | The timestamp when the transaction expires. |
| CAN_EARLY_LOCK_RELEASE | varchar(7) | NO | Indicates whether row locks can be released early. |
| FORMATID | bigint(20) | NO | The global transaction format identifier. |
| GLOBALID | varchar(257) | NO | The unique identifier of the global transaction. |
| BRANCHID | varchar(257) | NO | The unique identifier of the branch transaction. |
Sample query
obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_TRANSACTION_SCHEDULERS;