Note
This view is available starting with V4.0.0.
Purpose
This view displays information about all OBServer nodes.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the server. |
| SVR_PORT | bigint(20) | NO | The port number of the server. |
| ID | bigint(20) | NO | The unique ID assigned to the cluster. |
| ZONE | varchar(128) | NO | The zone to which the OBServer node belongs. |
| SQL_PORT | bigint(20) | NO | The port used by the OBServer node to service SQL requests. |
| WITH_ROOTSERVER | varchar(3) | NO |
|
| STATUS | varchar(64) | NO |
|
| START_SERVICE_TIME | timestamp(6) | NO | The time when the node can start to provide services after the node process is started:
|
| STOP_TIME | timestamp(6) | NO | The time when the user manually stops the node service:
|
| BLOCK_MIGRATE_IN_TIME | timestamp(6) | NO | The time when the OBServer node is prohibited from migrating in data:
|
| CREATE_TIME | timestamp(6) | YES | The creation time of the table. |
| MODIFY_TIME | timestamp(6) | YES | The last modification time of the task. |
| BUILD_VERSION | varchar(256) | NO | The binary build version of the OBServer node. |
| LAST_OFFLINE_TIME | timestamp(6) | NO | The last offline time of the OBServer node:
NoteThis column is available starting with V4.2.0. |
Sample query
Query the information about all OBServer nodes in the cluster as the sys tenant.
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