Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
This view displays information about all units.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| UNIT_ID | bigint(20) | NO | Unit ID |
| TENANT_ID | bigint(20) | NO | ID of the tenant to which the unit belongs. NULL: The unit does not belong to any tenant. |
| STATUS | varchar(128) | NO | ACTIVE: Normal statusDELETING: Status of deletion |
| RESOURCE_POOL_ID | bigint(20) | NO | ID of the resource pool to which the unit belongs. |
| UNIT_GROUP_ID | bigint(20) | NO | ID of the unit group to which the unit belongs. |
| CREATE_TIME | timestamp(6) | YES | Creation time of the unit. |
| MODIFY_TIME | timestamp(6) | YES | Modification time of the unit. |
| ZONE | varchar(128) | NO | Zone name |
| SVR_IP | varchar(46) | NO | IP address of the OBServer to which the unit belongs. |
| SVR_PORT | bigint(20) | NO | Port of the OBServer to which the unit belongs. |
| MIGRATE_FROM_SVR_IP | varchar(46) | NO | NULL: The unit is not being migrated. |
| MIGRATE_FROM_SVR_PORT | bigint(20) | NO | NULL: The unit is not being migrated. |
| MANUAL_MIGRATE | varchar(3) | NO | NULL: The unit is not being migrated.YES: Unit migration initiated manuallyNO: Unit migration initiated automatically |
| UNIT_CONFIG_ID | bigint(20) | NO | ID of the unit specification. |
| MAX_CPU | double | NO | Upper limit of the CPU specification. |
| MIN_CPU | double | NO | Lower limit of the CPU specification. |
| MEMORY_SIZE | bigint(20) | NO | Memory specification in bytes. |
| LOG_DISK_SIZE | bigint(20) | NO | Log disk specification in bytes. |
| DATA_DISK_SIZE | bigint(20) | NO | Size of local cache available to the unit in bytes. This field applies only to shared storage (Shared-Storage, or SS) mode. In shared-nothing (Shared-Nothing, or SN) mode, the value of this field is NULL, indicating that the field is undefined and the unit is allowed to compete for disk space with other tenants.
NoteThis field was introduced in V4.3.4. |
| MAX_IOPS | bigint(20) | NO | Upper limit of the disk IOPS specification. |
| MIN_IOPS | bigint(20) | NO | Lower limit of the disk IOPS specification. |
| IOPS_WEIGHT | bigint(20) | NO | IOPS weight. |
| MAX_NET_BANDWIDTH | bigint(20) | NO | Maximum network bandwidth of the unit in bytes.
NoteThis field was introduced in V4.3.4. |
| NET_BANDWIDTH_WEIGHT | bigint(20) | NO | Weight of the network bandwidth of the unit.
NoteThis field was introduced in V4.3.4. |
Sample query
View the unit information 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
*************************** 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
*************************** 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
3 rows in set