Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
This view displays information about the specifications of all units.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| UNIT_CONFIG_ID | bigint(20) | NO | Unit specification ID. |
| NAME | varchar(128) | NO | Unit specification name. |
| CREATE_TIME | timestamp(6) | YES | Time when the unit specification was created. |
| MODIFY_TIME | timestamp(6) | YES | Time when the information was last updated. |
| MAX_CPU | double | NO | Upper limit on the CPU specification. |
| MIN_CPU | double | NO | Lower limit on 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 | Local cache size available to the unit in bytes. The value of this field is valid only in shared storage (Shared-Storage, SS) mode. In shared-nothing (Shared-Nothing, SN) mode, the value of this field is NULL, indicating that the value 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 on the IOPS specification. |
| MIN_IOPS | bigint(20) | NO | Lower limit on the IOPS specification. |
| IOPS_WEIGHT | bigint(20) | NO | IOPS weight. |
| MAX_NET_BANDWIDTH | bigint(20) | NO | Maximum network bandwidth available to the unit in bytes.
NoteThis field was introduced in V4.3.4. |
| NET_BANDWIDTH_WEIGHT | bigint(20) | NO | Weight value of the network bandwidth available to the unit.
NoteThis field was introduced in 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