Note
This view is available starting with 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 that the resource plan content manages. |
| COMMENTS | VARCHAR2(2000) | YES | Comment for resource plans. |
| MGMT_P1 | NUMBER(38) | NO | The maximum CPU usage as a percentage, which is relative to the system's full load. The default value is 100. |
| UTILIZATION_LIMIT | NUMBER(38) | NO | This column specifies the upper limit of the percentage of CPU resources used by the resource group relative to the total CPU resources of the tenant, with a default value of 100, indicating that the resource group can utilize up to 100% of the tenant's CPU resources. |
| MIN_IOPS | NUMBER(38) | NO | The number of reserved IOPS of the resource group for resolving I/O contention, which must be greater than or equal to 0. The sum of the MIN_IOPS values of all resource groups cannot exceed 100. |
| MAX_IOPS | NUMBER(38) | NO | The maximum IOPS that can be used by the resource group. The sum of MAX_IOPS for all resource groups can exceed 100. The default value is 100. |
| WEIGHT_IOPS | NUMBER(38) | NO | The IOPS weight value when an I/O resource is contended. The total of all the WEIGHT_IOPS values specified for all resource groups can be greater than 100, and I/O resources will be allocated based on the normalized value of the weight. The default value is 0. |
| MAX_NET_BANDWIDTH | NUMBER(38) | NO | The maximum network bandwidth used by the resource group. The total 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 for network bandwidth allocation when network resources are in contention. The sum of NET_BANDWIDTH_WEIGHT values across all resource groups can exceed 100. Network bandwidth is allocated based on normalized weight values within the limits set by MAX_NET_BANDWIDTH. Default value is 0. |
Sample query
In the Shared-Nothing mode, you can view the configuration parameters of various resources in the Resource Manager for your user tenant.
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 the resource-related configuration parameters of all tenants in Resource Manager: CDB_OB_RSRC_DIRECTIVES.
For detailed configuration operations on resource isolation, see the following documents: