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 | Name of the resource plan that contains the resource plan content |
| GROUP_OR_SUBPLAN | VARCHAR2(128) | NO | The name of the resource group controlled by the resource plan. |
| COMMENTS | VARCHAR2(2000) | YES | Comment content of the resource plan |
| MGMT_P1 | NUMBER(38) | NO | Indicates the maximum relative CPU usage under the system load, default value is 100 |
| UTILIZATION_LIMIT | NUMBER(38) | NO | Specifies the upper bound of the percentage of the CPU resources consumed by a resource group relative to the total CPU resources available for the tenant. The default value is 100, which means the resource group can consume all CPU resources. |
| MIN_IOPS | NUMBER(38) | NO | This value specifies the guaranteed IOPS allocated to the resource group when I/O contention occurs. The total of all MIN_IOPS values across all resource groups must be less than or equal to 100. The default value is 0. |
| MAX_IOPS | NUMBER(38) | NO | The maximum IOPS resources available for the resource group. The sum of all MAX_IOPS values specified for the resource groups can exceed 100. The default value is 100 |
| WEIGHT_IOPS | NUMBER(38) | NO | The IOPS weight value in case of I/O resource contention. The sum of all WEIGHT_IOPS specified in each resource group can exceed 100. IO resources will be allocated based on the normalized values of these weights, provided that the MIN_IOPS and MAX_IOPS settings are met. The default value is 0 |
| MAX_NET_BANDWIDTH | NUMBER(38) | NO | The maximum network bandwidth available to the resource group. The sum of the values specified for all resource groups must be greater than 100. The default value is 100. |
| NET_BANDWIDTH_WEIGHT | NUMBER(38) | NO | The weight of bandwidth for resource groups in case of contention. The total of NET_BANDWIDTH_WEIGHT specified for all resource groups can exceed 100. Network bandwidth is distributed among resource groups based on the normalized values of the weights of resource groups, provided that MAX_NET_BANDWIDTH is set. The default value is 0. |
Sample query
In SN (Shared-Nothing) mode, a user tenant can view configuration parameters of its own resources 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 first | 100 | 100 | 10 | 90 | 30 | 100 | 0 |
+--------+------------------+-----------+---------+-------------------+----------+----------+-------------+-------------------+----------------------+
2 rows in set