Note
This view is available starting with V4.0.0.
Purpose
This view displays the unit specifications of all tenants.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| UNIT_CONFIG_ID | bigint(20) | NO | The ID of the unit specification. |
| NAME | varchar(128) | NO | The name of the unit specification. |
| CREATE_TIME | timestamp(6) | YES | The time when the unit specification was created. |
| MODIFY_TIME | timestamp(6) | YES | The time when the information was updated. |
| 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 memory specification, in bytes. |
| LOG_DISK_SIZE | bigint(20) | NO | The log disk specification, in bytes. |
| DATA_DISK_SIZE | bigint(20) | NO | The value of this column is NULL, indicating that the value is undefined. The unit can compete for the disk space of other tenants.
NoteThis parameter is available starting with V4.3.4. |
| MAX_IOPS | bigint(20) | NO | The upper limit of the IOPS specification. |
| MIN_IOPS | bigint(20) | NO | The lower limit of the 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. |
Sample query
Query the unit specifications of all tenants in the sys tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_UNIT_CONFIGS;
The query result is as follows:
+----------------+-----------------+----------------------------+----------------------------+---------+---------+-------------+---------------+----------------+---------------------+---------------------+-------------+---------------------+----------------------+
| UNIT_CONFIG_ID | NAME | CREATE_TIME | MODIFY_TIME | MAX_CPU | MIN_CPU | MEMORY_SIZE | LOG_DISK_SIZE | DATA_DISK_SIZE | MAX_IOPS | MIN_IOPS | IOPS_WEIGHT | MAX_NET_BANDWIDTH | NET_BANDWIDTH_WEIGHT |
+----------------+-----------------+----------------------------+----------------------------+---------+---------+-------------+---------------+----------------+---------------------+---------------------+-------------+---------------------+----------------------+
| 1 | sys_unit_config | 2025-06-23 15:04:26.845106 | 2025-06-23 15:04:26.845106 | 4 | 4 | 5368709120 | 17448304640 | NULL | 9223372036854775807 | 9223372036854775807 | 4 | 9223372036854775807 | 4 |
| 1001 | unit001 | 2025-06-23 15:16:05.453176 | 2025-06-23 15:16:05.453176 | 2 | 2 | 6442450944 | 19327352832 | NULL | 9223372036854775807 | 9223372036854775807 | 2 | 9223372036854775807 | 2 |
+----------------+-----------------+----------------------------+----------------------------+---------+---------+-------------+---------------+----------------+---------------------+---------------------+-------------+---------------------+----------------------+
2 rows in set