Note
This view is introduced since OceanBase Database V4.3.1.
Purpose
The V$OB_NIC_INFO view displays the NIC information on the current OBServer nodes of all tenants, primarily the NIC speed.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | bigint(20) | NO | The RPC port number of the OBServer node. |
| DEVNAME | varchar(128) | NO | The name of the NIC on the server where the OBServer node resides. |
| SPEED_MBPS | bigint(20) | NO | The NIC speed, in Mbit/s. |
Sample query
Query the NIC information of the current OBServer node.
obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_NIC_INFO;
The query result is as follows:
+----------------+----------+---------+------------+
| SVR_IP | SVR_PORT | DEVNAME | SPEED_MBPS |
+----------------+----------+---------+------------+
| xx.xx.xx.xx | 2882 | eth0 | 10000 |
+----------------+----------+---------+------------+