Oracle Database Quality of Service (QoS) Management uses a resource management plan and user-specific performance objectives to allocate resources to defined workloads.

With Oracle Database, use services to manage the workload on your system by starting services on groups of servers that are dedicated to particular workloads. At the database tier, for example, you could dedicate one group of servers to online transaction processing (OLTP), dedicate another group of servers to application testing, and dedicate a third group of servers for internal applications. The system administrator can allocate resources to specific workloads by manually changing the number of servers on which a database service is allowed to run.

Using groups of servers in this way isolates the workloads from each other to prevent demand surges, failures, and other problems in one workload from affecting the other workloads. However, in this type of deployment, you must separately provision the servers to each group to satisfy the peak demand of each workload because resources are not shared.

Oracle Database QoS Management performs the following actions:

1. Uses a policy created by the Oracle Database QoS Management administrator to do the following:

   • Assign each work request to a Performance Class by using the attributes of the incoming work requests, such as the database service to which the application connects.

   • Determine the target response times (Performance Objectives) for each Performance Class.

   • Determine which Performance Classes are the most critical to your business.

2. Monitors the resource usage and resource wait times for all the Performance Classes.

3. Analyzes the average response time for a Performance Class against the Performance Objective in effect for that Performance Class.

4. Produces recommendations for reallocating resources to improve the performance of a Performance Class that is exceeding its target response time.

5. Provides an analysis of the predicted impact to performance levels for each Performance Class if that recommendation is implemented.

6. Implements the actions listed in the recommendation when directed to by the Oracle Database QoS Management administrator.

7. Evaluates the system to verify that each Performance Class is meeting its Performance Objective after the resources have been reallocated.