Note
This view was introduced in OceanBase Database V4.3.4.
Purpose
This view displays the resource configuration parameters of the current tenant in the Resource Manager.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| PLAN | VARCHAR2(128) | NO | The name of the resource plan to which the resource plan content belongs. |
| GROUP_OR_SUBPLAN | VARCHAR2(128) | NO | The name of the resource group controlled by the resource plan content. |
| COMMENTS | VARCHAR2(2000) | YES | The comment for the resource plan content. |
| MGMT_P1 | NUMBER(38) | NO | The maximum percentage of CPU resources that can be used when the system is fully loaded. The default value is 100. |
| UTILIZATION_LIMIT | NUMBER(38) | NO | The maximum percentage of CPU resources that can be 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 CPU resources of the tenant. |
| MIN_IOPS | NUMBER(38) | NO | The number of IOPS reserved for the resource group when I/O contention occurs. The total value of the MIN_IOPS values specified for all resource groups cannot exceed 100. The default value is 0. |
| MAX_IOPS | NUMBER(38) | NO | The maximum number of IOPS that the resource group can use. The total value of the MAX_IOPS values specified for all resource groups can exceed 100. The default value is 100. |
| WEIGHT_IOPS | NUMBER(38) | NO | The weight value of IOPS when I/O contention occurs. The total value of the WEIGHT_IOPS values specified for all resource groups can exceed 100. I/O resources are allocated based on the normalized weight values, provided that the MIN_IOPS and MAX_IOPS values are set. The default value is 0. |
| MAX_NET_BANDWIDTH | NUMBER(38) | NO | The upper limit on the network bandwidth used by the resource group. The total value of the MAX_NET_BANDWIDTH values specified for all resource groups can exceed 100. The default value is 100. |
| NET_BANDWIDTH_WEIGHT | NUMBER(38) | NO | The weight value of network bandwidth when network resource contention occurs. The total value of the NET_BANDWIDTH_WEIGHT values specified for all resource groups can exceed 100. Network bandwidth resources are allocated based on the normalized weight values, provided that the MAX_NET_BANDWIDTH value is set. The default value is 0. |
Sample query
The following example shows how to query the resource configuration parameters of the current tenant in the Resource Manager in SN (Shared-Nothing) mode.
obclient [SYS]> SELECT * FROM SYS.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 |
+--------+------------------+-----------+---------+-------------------+----------+----------+-------------+-------------------+----------------------+
| PLAN_A | BIG_GROUP | new | 40 | 60 | 20 | 100 | 10 | 60 | 60 |
| PLAN_A | SMALL_GROUP | AP first | 100 | 100 | 10 | 90 | 30 | 100 | 0 |
+--------+------------------+-----------+---------+-------------------+----------+----------+-------------+-------------------+----------------------+
2 rows in set