Note
This view is available starting with V4.1.0.
Purpose
This view displays the I/O resource configuration 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 comments of the resource plan. |
| MIN_IOPS | NUMBER(38) | NO | The reserved IOPS value, which ranges from 0 to 100. |
| MAX_IOPS | NUMBER(38) | NO | The upper limit of IOPS, which ranges from 0 to 100. |
| WEIGHT_IOPS | NUMBER(38) | NO | The shared IOPS value, which ranges from 0 to 100. |
Sample query
Query the I/O resource configuration in the Resource Manager of the user tenant.
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