Purpose
The oceanbase.DBA_OB_SERVERS view displays the information about all OBServer nodes.
Note
This view is introduced since OceanBase Database V4.0.0.
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 point in time when the node was stopped. NULL: The node is not 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. |
| LAST_OFFLINE_TIME | timestamp(6) | NO | The time when the OBServer node became offline the last time. NULL: The OBServer node never becomes offline.This column is introduced since OceanBase Database V4.2.0. |
| 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. |