Note
This view is available starting with V4.3.4.
Purpose
This view displays configuration parameters related to resource management in the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| PLAN | VARCHAR2(128) | NO | The name of the resource plan to which the plan belongs. |
| GROUP_OR_SUBPLAN | VARCHAR2(128) | NO | The name of the resource group controlled by the resource plan content. |
| COMMENTS | VARCHAR2(2000) | YES | Corresponds to comments of the resource plan. |
| MGMT_P1 | NUMBER(38) | NO | The maximum CPU utilization rate in the fully loaded system. The default value is 100. |
| UTILIZATION_LIMIT | NUMBER(38) | NO | The maximum percentage of CPU resources in a tenant's total CPU resources that can be used by the resource group. The default value is 100, meaning that the tenant can use all its CPU resources. |
| MIN_IOPS | NUMBER(38) | NO | The number of IOPS resources reserved for the resource group during an I/O contention. The total value of the MIN_IOPS of all resource groups cannot exceed 100. The default value is 0. |
| MAX_IOPS | NUMBER(38) | NO | The maximum IOPS of a resource group, and the total of all MAX_IOPS values of resource groups can exceed 100. The default value is 100. |
| WEIGHT_IOPS | NUMBER(38) | NO | The weight of IOPS in case of I/O resource contention. The sum of the WEIGHT_IOPS specified for all resource groups can exceed 100, provided that the MIN_IOPS and MAX_IOPS parameters are set. By default, this value is 0. |
| MAX_NET_BANDWIDTH | NUMBER(38) | NO | The maximum network bandwidth for the resource group. The total of MAX_NET_BANDWIDTH across all resource groups can exceed 100. The default value is 100. |
| NET_BANDWIDTH_WEIGHT | NUMBER(38) | NO | The weight of network bandwidth. When network resource contention occurs, network bandwidth resources are distributed to resource groups based on their weight. The total weight of all resource groups must not exceed 100. The default value is 0. |
Sample query
Under a Shared-Nothing mode, a user tenant can query resource configurations of this tenant in Resource Manager.
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 priority | 100 | 100 | 10 | 90 | 30 | 100 | 0 |
+--------+------------------+-----------+---------+-------------------+----------+----------+-------------+-------------------+----------------------+
2 rows in set
References
View all resource configuration parameters for different types of resource groups in all tenants on the Resource Manager: CDB_OB_RSRC_DIRECTIVES
For more information about resource isolation, see the following topics: