Notices
This view is available starting with V4.1.0.
- For the current version, we recommend that you use the DBA_OB_RSRC_DIRECTIVES view to query configuration parameters of Resource Manager for a tenant.
Purpose
This view displays the IO resource settings of the Resource Manager.
Columns
| Column | Type | Nullable | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Column | Type | Nullable | Description | --- | --- | --- | --- | PLAN | VARCHAR2(128) | NO | The name of the resource plan to which the instruction belongs. | ||
| GROUP_OR_SUBPLAN | VARCHAR2(128) | NO | The name of a resource group or subplan controlled by instructions | ||||||||||
| COMMENTS | VARCHAR2(2000) | YES | Remarks on resource plans | ||||||||||
| MIN_IOPS | NUMBER(38) | NO | The IOPS reserved for the resource group when I/O contention occurs. The sum of all resource groups' MIN_IOPS values cannot exceed 100. The default value is 0. |
||||||||||
| MAX_IOPS | NUMBER(38) | NO | The maximum IOPS of a resource group. The sum of the MAX_IOPS values specified for all resource groups can exceed 100. The default value is 100. |
||||||||||
| WEIGHT_IOPS | NUMBER(38) | NO | The IOPS weight for resource contention. The sum of the WEIGHT_IOPS values specified for all resource groups can exceed 100. During IOPS resource allocation, the IOPS resource will be distributed based on the weight normalized values. The default value is 0. |
Sample query
You can query the IO resource configuration of the Resource Manager in your tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_RSRC_IO_DIRECTIVES;
Purpose This view displays information about the system processes.
+--------+------------------+-----------+----------+----------+-------------+
| PLAN | GROUP_OR_SUBPLAN | COMMENTS | MIN_IOPS | MAX_IOPS | WEIGHT_IOPS |
+--------+------------------+-----------+----------+----------+-------------+
| PLAN_A | BIG_GROUP | TP preferred | 20 | 100 | 20 |
+--------+------------------+-----------+----------+----------+-------------+
1 row in set
References
You can query the RESOURCE_DIRECTIVES view to obtain information about the resources that are specified in a tenant in the Resource Manager. For more information, see DBA_OB_RSRC_DIRECTIVES.