Note
- This view was introduced in V4.1.0.
- In the current version, we recommend that you use the DBA_OB_RSRC_DIRECTIVES view to view the resource configuration parameters of a tenant in the Resource Manager.
Purpose
This view displays the IO resource configurations in the Resource Manager.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| PLAN | VARCHAR2(128) | NO | The name of the resource plan to which the directive belongs. |
| GROUP_OR_SUBPLAN | VARCHAR2(128) | NO | The name of the resource group or subplan controlled by the directive. |
| COMMENTS | VARCHAR2(2000) | YES | The remarks for the resource plan. |
| MIN_IOPS | NUMBER(38) | NO | The number of IOPS reserved for the resource group when IO contention occurs. The sum of all MIN_IOPS values specified for 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 sum of all MAX_IOPS values specified for resource groups can exceed 100. The default value is 100. |
| WEIGHT_IOPS | NUMBER(38) | NO | The weight value of IOPS when IO contention occurs. The sum of all WEIGHT_IOPS values specified for 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 values are set. The default value is 0. |