Note
This view is available starting with V4.0.0.
Purpose
This view displays the information about units of all tenants.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| UNIT_ID | bigint(20) | NO | The ID of the unit. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant to which the unit belongs.
|
| STATUS | varchar(128) | NO |
|
| RESOURCE_POOL_ID | bigint(20) | NO | The ID of the resource pool to which the unit belongs. |
| UNIT_GROUP_ID | bigint(20) | NO | The ID of the unit group to which the unit belongs. |
| CREATE_TIME | timestamp(6) | YES | The time when the unit was created. |
| MODIFY_TIME | timestamp(6) | YES | The time when the unit was last modified. |
| ZONE | varchar(128) | NO | The name of the zone. |
| SVR_IP | varchar(46) | NO | The IP address of the OBServer to which the unit belongs. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer to which the unit belongs. |
| MIGRATE_FROM_SVR_IP | varchar(46) | NO |
|
| MIGRATE_FROM_SVR_PORT | bigint(20) | NO |
|
| MANUAL_MIGRATE | varchar(3) | NO |
|
| UNIT_CONFIG_ID | bigint(20) | NO | The ID of the unit specification. |
| MAX_CPU | double | NO | The upper limit of the CPU specification. |
| MIN_CPU | double | NO | The lower limit of the CPU specification. |
| MEMORY_SIZE | bigint(20) | NO | The size of the memory, in bytes. |
| LOG_DISK_SIZE | bigint(20) | NO | The size of the log disk, in bytes. |
| DATA_DISK_SIZE | bigint(20) | NO | The size of the local cache available to the unit, in bytes. The value of this field is NULL, indicating that it is undefined and the unit can compete for disk space of other tenants.
NoteThis parameter is available starting with V4.3.4. |
| MAX_IOPS | bigint(20) | NO | The upper limit of the disk IOPS specification. |
| MIN_IOPS | bigint(20) | NO | The lower limit of the disk IOPS specification. |
| IOPS_WEIGHT | bigint(20) | NO | The IOPS weight. |
| MAX_NET_BANDWIDTH | bigint(20) | NO | The maximum network bandwidth of the unit, in bytes.
NoteThis parameter is available starting with V4.3.4. |
| NET_BANDWIDTH_WEIGHT | bigint(20) | NO | The weight of the network bandwidth of the unit.
NoteThis parameter is available starting with V4.3.4. |
| REPLICA_TYPE | varchar(7) | NO | The type of replica. The default value is FULL.
Note
|
Sample query
Query the information about units of all tenants.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_UNITS\G
The query result is as follows:
*************************** 1. row ***************************
UNIT_ID: 1
TENANT_ID: 1
STATUS: ACTIVE
RESOURCE_POOL_ID: 1
UNIT_GROUP_ID: 1
CREATE_TIME: 2025-06-23 15:04:26.853917
MODIFY_TIME: 2025-06-23 15:04:26.853917
ZONE: zone1
SVR_IP: 172.xx.xxx.xxx
SVR_PORT: 2882
MIGRATE_FROM_SVR_IP: NULL
MIGRATE_FROM_SVR_PORT: NULL
MANUAL_MIGRATE: NULL
UNIT_CONFIG_ID: 1
MAX_CPU: 4
MIN_CPU: 4
MEMORY_SIZE: 5368709120
LOG_DISK_SIZE: 17448304640
DATA_DISK_SIZE: NULL
MAX_IOPS: 9223372036854775807
MIN_IOPS: 9223372036854775807
IOPS_WEIGHT: 4
MAX_NET_BANDWIDTH: 9223372036854775807
NET_BANDWIDTH_WEIGHT: 4
REPLICA_TYPE: FULL
*************************** 2. row ***************************
UNIT_ID: 1001
TENANT_ID: 1002
STATUS: ACTIVE
RESOURCE_POOL_ID: 1001
UNIT_GROUP_ID: 1001
CREATE_TIME: 2025-06-23 15:16:09.087075
MODIFY_TIME: 2025-06-23 15:16:18.624919
ZONE: zone1
SVR_IP: 172.xx.xxx.xxx
SVR_PORT: 2882
MIGRATE_FROM_SVR_IP: NULL
MIGRATE_FROM_SVR_PORT: NULL
MANUAL_MIGRATE: NULL
UNIT_CONFIG_ID: 1001
MAX_CPU: 2
MIN_CPU: 2
MEMORY_SIZE: 6442450944
LOG_DISK_SIZE: 19327352832
DATA_DISK_SIZE: NULL
MAX_IOPS: 9223372036854775807
MIN_IOPS: 9223372036854775807
IOPS_WEIGHT: 2
MAX_NET_BANDWIDTH: 9223372036854775807
NET_BANDWIDTH_WEIGHT: 2
REPLICA_TYPE: FULL
*************************** 3. row ***************************
UNIT_ID: 1002
TENANT_ID: 1004
STATUS: ACTIVE
RESOURCE_POOL_ID: 1002
UNIT_GROUP_ID: 1002
CREATE_TIME: 2025-06-23 15:16:12.956789
MODIFY_TIME: 2025-06-23 15:17:14.677111
ZONE: zone1
SVR_IP: 172.xx.xxx.xxx
SVR_PORT: 2882
MIGRATE_FROM_SVR_IP: NULL
MIGRATE_FROM_SVR_PORT: NULL
MANUAL_MIGRATE: NULL
UNIT_CONFIG_ID: 1001
MAX_CPU: 2
MIN_CPU: 2
MEMORY_SIZE: 6442450944
LOG_DISK_SIZE: 19327352832
DATA_DISK_SIZE: NULL
MAX_IOPS: 9223372036854775807
MIN_IOPS: 9223372036854775807
IOPS_WEIGHT: 2
MAX_NET_BANDWIDTH: 9223372036854775807
NET_BANDWIDTH_WEIGHT: 2
REPLICA_TYPE: FULL
3 rows in set