Note
This view was introduced in OceanBase Database V4.3.4.
Purpose
This view displays the resource configuration parameters of the current tenant in Resource Manager.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| PLAN | varchar(128) | NO | The name of the resource plan to which the resource plan content belongs. |
| GROUP_OR_SUBPLAN | varchar(128) | NO | The name of the resource group or subplan controlled by the resource plan content. |
| COMMENTS | varchar(2000) | YES | The comments on the resource plan content. |
| MGMT_P1 | bigint(20) | NO | The maximum CPU percentage available when the system is fully loaded. The default value is 100. |
| UTILIZATION_LIMIT | bigint(20) | NO | The maximum percentage of CPU resources used by the resource group out of the total CPU resources of the tenant. The default value is 100, indicating that the resource group can use all the CPU resources of the tenant. |
| MIN_IOPS | bigint(20) | NO | The IOPS resources reserved for the resource group when I/O contention occurs. The total MIN_IOPS values specified for all resource groups cannot exceed 100. The default value is 0. |
| MAX_IOPS | bigint(20) | NO | The maximum IOPS resources that the resource group can use. The total MAX_IOPS values specified for all resource groups can exceed 100. The default value is 100. |
| WEIGHT_IOPS | bigint(20) | NO | The weight value of IOPS when I/O contention occurs. The total WEIGHT_IOPS values specified for all resource groups can exceed 100. The I/O resources are allocated based on the normalized weight values, provided that the MIN_IOPS and MAX_IOPS are set. The default value is 0. |
| MAX_NET_BANDWIDTH | bigint(20) | NO | The maximum network bandwidth used by the resource group. The total MAX_NET_BANDWIDTH values specified for all resource groups can exceed 100. The default value is 100. |
| NET_BANDWIDTH_WEIGHT | bigint(20) | NO | The weight value of bandwidth when network contention occurs. The total NET_BANDWIDTH_WEIGHT values specified for all resource groups can exceed 100. The network bandwidth resources are allocated based on the normalized weight values, provided that the MAX_NET_BANDWIDTH is set. The default value is 0. |
Sample query
In SN (Shared-Nothing) mode, a user tenant queries the resource configuration parameters of the tenant in Resource Manager.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_RSRC_DIRECTIVES;
The query result is as follows:
+---------+-------------------+----------+---------+-------------------+----------+----------+-------------+-------------------+----------------------+
| PLAN | GROUP_OR_SUBPLAN | COMMENTS | MGMT_P1 | UTILIZATION_LIMIT | MIN_IOPS | MAX_IOPS | WEIGHT_IOPS | MAX_NET_BANDWIDTH | NET_BANDWIDTH_WEIGHT |
+---------+-------------------+----------+---------+-------------------+----------+----------+-------------+-------------------+----------------------+
| daytime | batch_group | | 100 | 40 | 40 | 80 | 70 | 100 | 0 |
| daytime | interactive_group | new | 40 | 60 | 40 | 80 | 70 | 30 | 30 |
+---------+-------------------+----------+---------+-------------------+----------+----------+-------------+-------------------+----------------------+
2 rows in set