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 specified, the default value is default_region. Valid values: NULL indicates that the column value is invalid. This invalid value may briefly appear 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: FULL |
Sample query
The sys tenant queries the unit information of all OBServer nodes where user tenants reside.
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: 1
TENANT_ID: 1
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: 7516192768
LOG_DISK_IN_USE: 0
DATA_DISK_SIZE: 10737418240
DATA_DISK_IN_USE: 10737418240
STATUS: NORMAL
CREATE_TIME: 2026-07-21 16:39:01.636145
REPLICA_TYPE: FULL
*************************** 2. row ***************************
SVR_IP: 6.xx.xxx.xxx
SVR_PORT: 2882
UNIT_ID: 1001
TENANT_ID: 1001
ZONE: zone1
ZONE_TYPE: ReadWrite
REGION: OCP_META_REGION
MAX_CPU: NULL
MIN_CPU: NULL
MEMORY_SIZE: 1073741824
MAX_IOPS: NULL
MIN_IOPS: NULL
IOPS_WEIGHT: NULL
MAX_NET_BANDWIDTH: NULL
NET_BANDWIDTH_WEIGHT: NULL
LOG_DISK_SIZE: 644245094
LOG_DISK_IN_USE: 0
DATA_DISK_SIZE: 1288490188
DATA_DISK_IN_USE: 3663974400
STATUS: NORMAL
CREATE_TIME: 2026-07-21 17:44:16.218311
REPLICA_TYPE: FULL
*************************** 3. 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
3 rows 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.