9.1 What Does Oracle Database Quality of Service (QoS) Management Manage?

Oracle Database Quality of Service (QoS) Management works with Oracle Real Application Clusters (Oracle RAC) and Oracle Clusterware. Oracle Database QoS Management operates over an entire Oracle RAC cluster, which can support various applications.

Oracle Database QoS Management manages the CPU resource for a cluster. Oracle Database QoS Management does not manage I/O resources. Therefore, Oracle Database QoS Management does not effectively manage I/O intensive applications. Oracle Database QoS Management integrates with the Oracle RAC database through the following technologies to manage resources within a cluster:

• Database Services

• Oracle Database Resource Manager

• Oracle Clusterware

• Run-time Connection Load Balancing

Oracle Database QoS Management periodically evaluates the resource wait times for all used resources. If the average response time for the work requests in a Performance Class is greater than the value specified in its Performance Objective, then Oracle Database QoS Management uses the collected metrics to find the bottlenecked resource. If possible, Oracle Database QoS Management provides recommendations for adjusting the size of the server pools or altering the consumer group mappings in the resource plan used by Oracle Database Resource Manager.

Note:

Oracle Database QoS Management supports only OLTP workloads. The following types of workloads (or database requests) are not supported:

• Batch workloads

• Workloads that require more than one second to complete

• Workloads that use parallel data manipulation language (DML)

• Workloads that query GV$ views at a signification utilization level