Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
This view displays the information about all OBServer nodes.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node. |
| ID | bigint(20) | NO | The unique ID allocated by the cluster to the OBServer node. |
| ZONE | varchar(128) | NO | The zone to which the OBServer node belongs. |
| SQL_PORT | bigint(20) | NO | The SQL port of the OBServer node. |
| WITH_ROOTSERVER | varchar(3) | NO | YES: RootService is available on the OBServer node.NO: RootService is unavailable on the OBServer node. |
| STATUS | varchar(64) | NO | ACTIVE: The heartbeat connection between the OBServer node and the RootService server is normal.INACTIVE: The OBServer node lost the heartbeat connection with the RootService server.DELETING: The OBServer node is being deleted. |
| START_SERVICE_TIME | timestamp(6) | NO | The point in time at which the OBServer node started to provide external services after the observer process was started on the node. NULL: The process is not started on the node or the node is unavailable. |
| STOP_TIME | timestamp(6) | NO | The time when the user actively stopped the node service. NULL: The node has not been stopped. |
| BLOCK_MIGRATE_IN_TIME | timestamp(6) | NO | The time when the OBServer node prohibited data migration. NULL: The OBServer does not prohibit data migration. |
| CREATE_TIME | timestamp(6) | YES | The time when the table was created. |
| MODIFY_TIME | timestamp(6) | YES | The time when the OBServer node was last modified. |
| BUILD_VERSION | varchar(256) | NO | The build version of the OBServer node. |
| LAST_OFFLINE_TIME | timestamp(6) | NO | The last time the OBServer node went offline. NULL: The OBServer node has never gone offline.NoteThis field was introduced starting from V4.2.0. |
Sample query
The system tenant views 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-23 15:04:32.216057
STOP_TIME: NULL
BLOCK_MIGRATE_IN_TIME: NULL
CREATE_TIME: 2025-06-23 15:04:28.283860
MODIFY_TIME: 2025-06-23 15:04:33.065350
BUILD_VERSION: 4.3.5.3_200000162025061317-ee7cf795b6b9ef2b39c02cb21b3d112180937158(Jun 13 2025 17:57:16)
LAST_OFFLINE_TIME: NULL
1 row in set