Note
This view is available starting with V4.0.0.
Purpose
This view displays the resource pool information of all tenants.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| RESOURCE_POOL_ID | bigint(20) | NO | The unique ID of the resource pool. |
| NAME | varchar(128) | NO | The name of the resource pool. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant. NULL: Indicates that the resource pool does not belong to any tenant. |
| CREATE_TIME | timestamp(6) | YES | The time when the resource pool was created. |
| MODIFY_TIME | timestamp(6) | YES | The last modification time. |
| UNIT_COUNT | bigint(20) | NO | The number of resource units. |
| UNIT_CONFIG_ID | bigint(20) | NO | The ID of the resource specification of the resource pool. |
| ZONE_LIST | varchar(8192) | NO | The list of zones in the resource pool. |
| REPLICA_TYPE | varchar(18) | NO | The replica type supported by the resource pool. FULL: Supports all replica types, including full-featured replicas.LOGONLY: Supports only log replicas.READONLY: Supports only read-only replicas.ENCRYPTION_LOGONLY: Supports only encrypted log replicas.NULL: Unknown replica type. |
Sample query
The sys tenant queries 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