9.9 Editing the Resource Plan for Oracle Database QoS Management
You can perform limited editing of the Resource Manager plans used by Oracle Database Quality of Service Management.
Oracle Database QoS Management activates a resource plan named APPQOS_PLAN
, which is a complex, multilevel resource plan. Oracle Database QoS Management also creates consumer groups that represent Performance Classes and resource plan directives for each consumer group.
You can modify some of the sections of the APPQOS_PLAN
, or ORA$QOS_PLAN
and ORA$QOS_CDB_PLAN
for Multitenant databases, but only as specified in the following table:
Plan Component | Modifiable? | Description |
---|---|---|
General |
DO NOT EDIT |
This section must not be edited as it is key to the QoS Management modeling and recommendation engine. If you modify this section, the change will be detected. In that case, Oracle Enterprise Manager Cloud Control reports a database error on the QoS Management dashboard. |
Parallelism |
Limited edits allowed |
This section can be edited however all values set for the |
Thresholds |
Limited edits allowed |
This section can be edited however all values set for the |
Idle Time |
Limited edits allowed |
This section can be edited however all values set for the |