Overview
Displays the unit information of the OBServer node where the tenant is located. The sys tenant can view the unit information of all OBServer nodes in the cluster.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | Server IP Address |
| SVR_PORT | bigint(20) | NO | Server Port Number |
| UNIT_ID | bigint(20) | NO | Unit ID |
| TENANT_ID | bigint(20) | NO | Tenant ID of the unit |
| ZONE | varchar(128) | NO | Zone Name |
| ZONE_TYPE | varchar(128) | NO | The zone type of the unit's zone. Valid values:
|
| REGION | varchar(128) | NO | The name of the region to which the zone where the unit is located belongs. If not set, the default is default_region. Valid values: NULL indicates that the column value is invalid. This can occur briefly after an OBServer node restarts. |
| MAX_CPU | double | NO | Maximum CPU Specification |
| MIN_CPU | double | NO | Minimum CPU Specification |
| MEMORY_SIZE | bigint(20) | NO | Memory size, in bytes |
| MAX_IOPS | bigint(20) | NO | Maximum Disk IOPS Specification |
| MIN_IOPS | bigint(20) | NO | Minimum Disk IOPS Specification |
| IOPS_WEIGHT | bigint(20) | NO | IOPS Weight |
| MAX_NET_BANDWIDTH | bigint(20) | YES | Maximum network bandwidth of the unit, in bytes |
| NET_BANDWIDTH_WEIGHT | bigint(20) | YES | Weight value of unit's network bandwidth |
| LOG_DISK_SIZE | bigint(20) | NO | Log disk size, in bytes |
| LOG_DISK_IN_USE | bigint(20) | NO | Used log disk space, in bytes |
| DATA_DISK_SIZE | bigint(20) | YES | Indicates the size of the local cache available to the unit, in bytes. |
| DATA_DISK_IN_USE | bigint(20) | NO | Indicates the size of the local cache used by the unit, in bytes. |
| STATUS | varchar(64) | NO | Unit status:
|
| CREATE_TIME | timestamp(6) | NO | Creation Time of Unit on OBServer Node |
| REPLICA_TYPE | varchar(7) | NO | Replica type. Default value: FULL |
Sample query
View the unit information of all OBServer nodes where the current tenant resides.
obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_UNITS\G
The query result is as follows:
*************************** 1. row ***************************
SVR_IP: 6.xx.xxx.xxx
SVR_PORT: 2882
UNIT_ID: 1001
TENANT_ID: 1002
ZONE: zone1
ZONE_TYPE: ReadWrite
REGION: OCP_META_REGION
MAX_CPU: 1
MIN_CPU: 1
MEMORY_SIZE: 5368709120
MAX_IOPS: 9223372036854775807
MIN_IOPS: 9223372036854775807
IOPS_WEIGHT: 1
MAX_NET_BANDWIDTH: 9223372036854775807
NET_BANDWIDTH_WEIGHT: 1
LOG_DISK_SIZE: 5798205850
LOG_DISK_IN_USE: 0
DATA_DISK_SIZE: 11596411700
DATA_DISK_IN_USE: 69246976
STATUS: NORMAL
CREATE_TIME: 2026-07-21 17:44:16.218311
REPLICA_TYPE: FULL
1 row in set
References
View unit information on the current node: V$OB_UNITS
For more information about tenant resources, see View tenant and resource information.