After you create resource pools in a cluster, you can view information about them in the cluster.
Procedure
Log in to the
systenant of the cluster as therootuser.View the information about the resource pools in the cluster:
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_RESOURCE_POOLS\G *************************** 1. row *************************** RESOURCE_POOL_ID: 1 NAME: sys_pool TENANT_ID: 1 CREATE_TIME: 2026-07-30 22:46:33.405708 MODIFY_TIME: 2026-07-30 22:46:33.405708 UNIT_COUNT: 1 UNIT_CONFIG_ID: 1 ZONE_LIST: zone1 REPLICA_TYPE: FULL *************************** 2. row *************************** RESOURCE_POOL_ID: 1001 NAME: pool_mysql123_zone1_oom TENANT_ID: 1002 CREATE_TIME: 2026-07-30 22:53:38.189401 MODIFY_TIME: 2026-07-30 22:53:38.426859 UNIT_COUNT: 1 UNIT_CONFIG_ID: 1001 ZONE_LIST: zone1 REPLICA_TYPE: FULL 2 rows in setwhere:
RESOURCE_POOL_ID: indicates the ID of a resource pool, which uniquely identifies a resource pool.TENANT_ID: indicates the ID of the tenant to which the resource pool belongs, which uniquely identifies a tenant. The ID of thesystenant is1. For instructions on viewing detailed information about the current tenant, see View tenant and resource information.If the value of
TENANT_IDisNULL, the resource pool is not bound to any tenant. You can allocate the resource pool to a tenant. For instructions on allocating a resource pool to a tenant, see Allocate a resource pool to a tenant.UNIT_COUNT: indicates the number of resource units in the resource pool.UNIT_CONFIG_ID: indicates the ID of a resource unit config (namely, a resource unit configuration) in the resource pool, which uniquely identifies a resource unit config.For instructions on viewing resource unit configs, see View resource specifications.
ZONE_LIST: indicates which zones are using the resources in the resource pool.