Note
This view is introduced since OceanBase Database V4.3.1.
Purpose
The GV$OB_NIC_INFO view displays the NIC information on all OBServer nodes of the current tenant, 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 on all OBServer nodes of the current tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_NIC_INFO;
The query result is as follows:
+----------------+----------+---------+------------+
| SVR_IP | SVR_PORT | DEVNAME | SPEED_MBPS |
+----------------+----------+---------+------------+
| xx.xx.xx.xx | 2882 | eth0 | 10000 |
| xx.xx.xx.xx | 2884 | bond0 | 10000 |
| xx.xx.xx.xx | 2886 | bond0 | 10000 |
+----------------+----------+---------+------------+