Overview
Displays information about all OBServer nodes.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | Server IP Address |
| SVR_PORT | bigint(20) | NO | Server Port Number |
| ID | bigint(20) | NO | The unique ID assigned to the cluster. |
| ZONE | varchar(128) | NO | Zone to which the OBServer node belongs |
| SQL_PORT | bigint(20) | NO | Port for serving SQL requests on the OBServer node |
| WITH_ROOTSERVER | varchar(3) | NO |
|
| STATUS | varchar(64) | NO |
|
| START_SERVICE_TIME | timestamp(6) | NO | The point in time after the node process starts when it can provide services:
|
| STOP_TIME | timestamp(6) | NO | Time point when the user actively stopped the node service:
|
| BLOCK_MIGRATE_IN_TIME | timestamp(6) | NO | The time when data migration to an OBServer node is prohibited:
|
| CREATE_TIME | timestamp(6) | YES | Table creation time |
| MODIFY_TIME | timestamp(6) | YES | Last Modified Time |
| BUILD_VERSION | varchar(256) | NO | OBServer Binaries Build Version |
| LAST_OFFLINE_TIME | timestamp(6) | NO | Last Offline Time of OBServer Node:
|
Sample query
The sys tenant is used to view information about all OBServer nodes in the cluster.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_SERVERS\G
The query result is as follows:
*************************** 1. row ***************************
SVR_IP: 172.xx.xxx.xxx
SVR_PORT: 2882
ID: 1
ZONE: zone1
SQL_PORT: 2881
WITH_ROOTSERVER: YES
STATUS: ACTIVE
START_SERVICE_TIME: 2025-06-12 10:58:33.584700
STOP_TIME: NULL
BLOCK_MIGRATE_IN_TIME: NULL
CREATE_TIME: 2025-06-12 10:58:29.417593
MODIFY_TIME: 2025-06-12 10:58:34.823378
BUILD_VERSION: 4.4.0.0_200000232025061114-da15b87011f3abfb9a97171856495976845347da(Jun 11 2025 15:04:57)
LAST_OFFLINE_TIME: NULL
1 row in set