Before you create a resource pool, it is necessary to query the details of existing unit configs to select a suitable unit config as a template.
Procedure
A resource unit serves as a template for utilizing server resources. By querying the view such as oceanbase.DBA_OB_UNIT_CONFIGS, you can obtain the configuration information of the existing resource units in the current cluster.
To query unit configs, perform the following steps:
Log in to the
systenant of the cluster using therootuser.Query all unit configs in the cluster:
obclient> SELECT * FROM oceanbase.DBA_OB_UNIT_CONFIGS\GQuery result:
*************************** 1. row *************************** UNIT_CONFIG_ID: 1 NAME: sys_unit_config CREATE_TIME: 2026-03-16 16:30:17.372372 MODIFY_TIME: 2026-03-16 16:30:17.372372 MAX_CPU: 4 MIN_CPU: 4 MEMORY_SIZE: 5368709120 LOG_DISK_SIZE: 9663676416 DATA_DISK_SIZE: NULL MAX_IOPS: 9223372036854775807 MIN_IOPS: 9223372036854775807 IOPS_WEIGHT: 4 MAX_NET_BANDWIDTH: 9223372036854775807 NET_BANDWIDTH_WEIGHT: 4 *************************** 2. row *************************** UNIT_CONFIG_ID: 1001 NAME: unit001 CREATE_TIME: 2026-03-16 16:31:47.795384 MODIFY_TIME: 2026-03-16 16:31:47.795384 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 2 rows in set