Overview
Displays the resource pool information for all tenants.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| RESOURCE_POOL_ID | bigint(20) | NO | Unique ID of the resource pool. |
| NAME | varchar(128) | NO | Resource Pool Name |
| TENANT_ID | bigint(20) | NO | Tenant ID:
|
| CREATE_TIME | timestamp(6) | YES | Creation Time |
| MODIFY_TIME | timestamp(6) | YES | Last Modified At |
| UNIT_COUNT | bigint(20) | NO | Number of Units |
| UNIT_CONFIG_ID | bigint(20) | NO | Resource Specification ID of the Resource Pool |
| ZONE_LIST | varchar(8192) | NO | Zone list of the resource pool |
| REPLICA_TYPE | varchar(7) | NO | Replica types supported by the resource pool:
|
Sample query
The system tenant can view the resource pool information of all tenants in the cluster.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_RESOURCE_POOLS;
The query result is as follows:
+------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-----------+--------------+
| RESOURCE_POOL_ID | NAME | TENANT_ID | CREATE_TIME | MODIFY_TIME | UNIT_COUNT | UNIT_CONFIG_ID | ZONE_LIST | REPLICA_TYPE |
+------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-----------+--------------+
| 1 | sys_pool | 1 | 2025-01-06 16:31:31.411103 | 2025-01-06 16:31:31.418511 | 1 | 1 | zone1 | FULL |
| 1001 | pool001 | 1002 | 2025-01-06 16:33:13.945560 | 2025-01-06 16:33:21.839760 | 1 | 1001 | zone1 | FULL |
| 1002 | pool002 | 1004 | 2025-01-06 16:33:16.585144 | 2025-01-06 16:34:46.512889 | 1 | 1001 | zone1 | FULL |
| 1004 | rptest | 1016 | 2025-01-08 13:45:31.797226 | 2025-01-08 16:53:08.952362 | 1 | 1001 | zone1 | FULL |
| 1005 | pool003 | 1010 | 2025-01-08 13:51:54.415741 | 2025-01-08 13:52:25.680109 | 1 | 1001 | zone1 | FULL |
+------------------+----------+-----------+----------------------------+----------------------------+------------+----------------+-----------+--------------+
5 rows in set