Note
This view is available starting with V4.2.1.
Purpose
GV$OB_TRANSACTION_SCHEDULERS is used to query the transaction scheduler information of all servers.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The tenant ID. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server where the replica is located. |
| SVR_PORT | NUMBER(38) | NO | The port of the server where the replica is located. |
| SESSION_ID | NUMBER(38) | NO | For V4.2.x:
|
| TX_ID | NUMBER(38) | NO | The transaction ID. |
| STATE | VARCHAR2(18) | NO | The transaction state. |
| CLUSTER_ID | NUMBER(38) | NO | The unique ID of the cluster. |
| COORDINATOR | NUMBER(38) | NO | The log stream ID of the coordinator. |
| PARTICIPANTS | VARCHAR2(1024) | YES | The information about the participants of the transaction. |
| ISOLATION_LEVEL | VARCHAR2(16) | NO | The isolation level. |
| SNAPSHOT_VERSION | NUMBER(38) | YES | The snapshot version when the RR or SERIAL isolation level is enabled. -1 is returned if the RR or SERIAL isolation level is not enabled. |
| ACCESS_MODE | VARCHAR2(10) | NO | The access mode (read-only or read/write). |
| TX_OP_SN | NUMBER(38) | NO | The operation sequence number at the transaction level. |
| ACTIVE_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | YES | The timestamp when the transaction is explicitly or implicitly started. |
| EXPIRE_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | YES | The timestamp when the transaction expires. |
| CAN_EARLY_LOCK_RELEASE | VARCHAR2(7) | NO | Indicates whether row locks can be released early. |
| FORMATID | NUMBER(38) | NO | The format identifier of the global transaction. |
| GLOBALID | VARCHAR2(256) | YES | The unique identifier of the global transaction. |
| BRANCHID | VARCHAR2(256) | YES | The unique identifier of the branch transaction. |
Sample query
obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_TRANSACTION_SCHEDULERS;