Note
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 view the various resource parameters configured for the tenant in the Resource Manager.
Purpose
This view displays I/O resource configurations in the Resource Manager.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| PLAN | VARCHAR2(128) | NO | 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 | Remarks for the resource plan. |
| MIN_IOPS | NUMBER(38) | NO | The number of IOPS reserved for the resource group when I/O contention occurs. The sum of MIN_IOPS of all resource groups cannot exceed 100. Default: 0. |
| MAX_IOPS | NUMBER(38) | NO | The maximum IOPS allowed for the resource group. The sum of MAX_IOPS of all resource groups can exceed 100. Default: 100. |
| WEIGHT_IOPS | NUMBER(38) | NO | The IOPS weight when I/O resource contention occurs. The sum of WEIGHT_IOPS of all resource groups can exceed 100, provided that MIN_IOPS and MAX_IOPS are satisfied. Default: 0. |
Sample query
This topic describes how to view I/O resources in a user's tenant of the ResourceManager.
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