Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction to Oracle Database QoS Management

• What Is Oracle Database QoS Management?
• Benefits of Using Oracle Database QoS Management
• Overview of Oracle Database QoS Management
  • How Does Oracle Database QoS Management Work?
    • Oracle Database QoS Management and Server Pools
    • Oracle Database QoS Management and Instance Caging
    • Oracle Database QoS Management and Services
  • Overview of Policy Sets
  • Overview of Server Pools
  • How Server Pools Are Used by Oracle Database QoS Management
  • Overview of Performance Classes
    • Performance Class Tags
    • Applying Classifiers to Work Requests
    • Using Additional Filters for Classifying Work Requests
    • Deciding to Create New Performance Classes
  • Overview of Performance Policies and Performance Objectives
    • Overview of Performance Objectives
    • Overview of Server Pool Directive Overrides
    • Overview of Performance Class Ranks
  • How Oracle Database QoS Management Collects and Analyzes Performance Data
  • Overview of Recommendations
    • How Oracle Database QoS Management Generates Recommendations
    • Types of Recommendations
    • Choosing the Best Recommendation
    • Contents of a Recommendation
    • Overview of Implementing Recommendations
    • Example: How Recommendations Are Generated
• What Does Oracle Database QoS Management Manage?
  • Managing Database Resources to Meet Service Levels
    • Database Services
    • Oracle Database Resource Manager
    • Oracle Clusterware
    • Run-time Connection Load Balancing
  • Managing Memory Pressure for Database Servers
  • High Availability Management and Oracle Database QoS Management
• Overview of Metrics
  • Performance Metrics
  • Resource Metrics
  • Performance Satisfaction Metrics
  • Using Metrics to Identify Performance Issues

2 Supported Workloads and Strategies

• Supported Configurations for Oracle Database QoS Management
  • Supported Server Pool Configurations
  • Supported Database Configurations
  • Supported Service Configurations
  • Supported Workload and Objective Types
• Strategies for Creating Classifiers for Performance Classes
• Configuration Strategies for Effective Resource Management
  • About Resource Bottlenecks
  • CPU Resource Bottlenecks
  • Configuration Recommendations for Global Cache Resource Bottlenecks
  • Configuration Recommendations for I/O Resource Bottlenecks
  • Configuration Recommendations for Other Types of Bottlenecks
• Sample Implementation of Oracle Database QoS Management
  • Description of the Demo System
  • Description of the System Workload
  • Initial Oracle Database QoS Management Configuration
• Creating Oracle Database QoS Management Performance Policies for the Demo System
• Managing Service Levels with Oracle Database QoS Management

3 Installing and Enabling Oracle Database QoS Management

• Configuring Oracle Database QoS Management to Manage Oracle Database Workloads
  • Installing and Configuring Oracle Grid Infrastructure for a Cluster
  • Creating and Configuring Server Pools
  • Creating and Configuring an Oracle RAC Database
    • Modifying Database Initialization Parameters
    • Creating Database Services
  • Creating Oracle Database QoS Management Administrator Accounts
  • Enabling Oracle Database QoS Management
    • Enable Oracle QoS Management at the Database Level
    • Create an Initial Policy Set
    • Enable Oracle QoS Management at the Cluster Level

4 Administering the Oracle Database QoS Management System

• Determining If Oracle Database QoS Management is Enabled
  • Checking the Enabled Status for a Database
  • Checking the Enabled Status for the Cluster
• Using Oracle Database QoS Management in Measure-Only Mode
• Using the Oracle Database QoS Management Dashboard
  • Accessing the Oracle Database QoS Management Dashboard
  • Enabling and Disabling Oracle Database QoS Management for a Cluster
  • Changing the Active Performance Policy
  • Interpreting the Performance Overview Graphs
  • Viewing Recommendations
  • Viewing Recommendation Details
  • Implementing Recommendations
• Administering the Policy Set
  • Editing a Policy Set
  • Adding Server Pools to a Policy Set
  • Modifying Server Pool Settings
  • Adding Database Services to a Policy Set
  • Updating a Policy Set to Include a New Database
• Managing Performance Classes
  • Creating a Performance Class
  • Deleting a Performance Class
  • Renaming a Performance Class
  • Editing an Existing Performance Class
    • Adding Classifiers
    • Changing Classifiers
    • Deleting Classifiers
  • Specifying the Evaluation Order of the Classifiers
• Managing Performance Policies
  • Creating a Performance Policy and Specifying Performance Objectives
  • Editing an Existing Performance Policy
  • Copying a Performance Policy
  • Setting the Current Performance Policy
  • Deleting a Performance Policy
  • Setting Server Pool Directive Overrides
• Reviewing Performance Metrics
  • Viewing Performance Metrics for All Performance Classes
  • Viewing Performance Metrics for Individual Performance Classes
  • Viewing the Resource Wait Times Breakdown
• Creating Administrative Users for Oracle Database QoS Management
  • QOSCTL Syntax and Commands

5 Troubleshooting Oracle Database QoS Management

• Common Problems
  • Cannot Enable Oracle Database Quality of Service Management
  • Cannot Enable Oracle Database QoS Management for a Database
  • Oracle Database Resource Manager Not Enabled and Resource Plan Errors
  • Do Not Have Access to a Server Pool
  • Server Pool Is Marked As Unmanageable
  • Metrics Are Missing For a Performance Class
  • Oracle Database QoS Management is not Generating Recommendations
  • Recently Added Server was Placed in the Wrong Server Pool
  • RMI Port Conflict Detected
• Locating Log or Trace Files
• Enabling Tracing

Glossary

Index