Note
This view is available starting with V4.3.1.
Purpose
The V$OB_NIC_INFO view displays the NIC information of the current OBServer node, including 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 of the OBServer node. |
| DEVNAME | varchar(128) | NO | The name of the NIC of the machine where the OBServer node is located. |
| SPEED_MBPS | bigint(20) | NO | The NIC speed, in Mbps. |
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 |
+----------------+----------+---------+------------+