Note
- This view is available starting with 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 I/O resource configuration information 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 controlled by the directive. |
| COMMENTS | VARCHAR2(2000) | YES | The remarks of the resource plan. |
| MIN_IOPS | NUMBER(38) | NO | The reserved IOPS resources for the resource group when I/O contention occurs. The sum of the MIN_IOPS values specified for all resource groups cannot exceed 100. The default value is 0. |
| MAX_IOPS | NUMBER(38) | NO | The maximum IOPS resources that can be used by the 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 weight of IOPS when I/O contention occurs. The sum of the WEIGHT_IOPS values specified for all resource groups can exceed 100. I/O resources are allocated based on the normalized weight values, provided that the MIN_IOPS and MAX_IOPS settings are met. The default value is 0. |
Sample query
Query the I/O resource configuration information of the current user tenant in the Resource Manager.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_RSRC_IO_DIRECTIVES;
The query result is as follows:
+--------+------------------+-----------+----------+----------+-------------+
| PLAN | GROUP_OR_SUBPLAN | COMMENTS | MIN_IOPS | MAX_IOPS | WEIGHT_IOPS |
+--------+------------------+-----------+----------+----------+-------------+
| PLAN_A | BIG_GROUP | TP priority | 20 | 100 | 20 |
+--------+------------------+-----------+----------+----------+-------------+
1 row in set
References
To view the resource configuration parameters of a tenant in the Resource Manager, see DBA_OB_RSRC_DIRECTIVES.