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.
|
| 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. |
Sample query
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)