Feature
DBA_OB_RSRC_IO_DIRECTIVES displays the I/O resource configuration in Resource Manager.
Fields
| Field | 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 the resource group controlled by the instruction. |
| COMMENTS | VARCHAR2(2000) | YES | Comments for the resource plan. |
| MIN_IOPS | NUMBER(38) | NO | The reserved IOPS. Value range: 0-100. |
| MAX_IOPS | NUMBER(38) | NO | The maximum IOPS. Value range: 0-100. |
| WEIGHT_IOPS | NUMBER(38) | NO | The shared IOPS. Value range:0-100. |