Purpose
The oceanbase.DBA_OB_ACCESS_POINT view displays the list of servers for accessing the current tenant.
Note
This view is introduced since OceanBase Database V4.2.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. Valid values:
|
| TENANT_NAME | varchar(128) | NO | The name of the tenant. |
| SVR_IP | varchar(46) | NO | The IP address of the server where the log stream replica resides. |
| SQL_PORT | bigint(20) | NO | The SQL port of the server where the log stream replica resides. |
Example
obclient [oceanbase]>select svr_ip, sql_port from DBA_OB_ACCESS_POINT;
+-------------+----------+
| svr_ip | sql_port |
+-------------+----------+
| xxx.xxx.xxx.20 | 17860 |
+-------------+----------+
1 row in set (0.05 sec)