9 Monitoring and Managing Database Workload Performance

Oracle Database Quality of Service (QoS) Management is an automated, policy-based product that monitors the workload requests for an entire system.

This chapter contains the following sections:

• 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.
• How Does Oracle Database Quality of Service (QoS) Management Work?
  Oracle Database Quality of Service (QoS) Management uses a resource management plan and user-specific performance objectives to allocate resources to defined workloads.
• Overview of Metrics
  Oracle Database Quality of Service (QoS) Management bases its decisions on observations of how long work requests spend waiting for resources.
• Benefits of Using Oracle Database Quality of Service (QoS) Management
  Oracle Database QoS Management helps manage the resources shared by databases and their services in a cluster.