1/12

Contents

List of Figures

Title and Copyright Information

Preface

• Audience
• Related Documents
• Conventions

Changes in This Release for Oracle Database Quality of Service Management

• Changes in Oracle Database QoS Management 12c Release 1 (12.1.0.2)
  • New Features
• Changes in Oracle Database QoS Management 12c Release 1 (12.1.0.1)
  • New Features
  • Deprecated Features
  • Desupported Features
  • Other Changes

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?
  • Overview of Policy Sets
  • Overview of Server Pools
  • How Server Pools Are Used by Oracle Database QoS Management
  • Overview of Performance Classes
  • Overview of Performance Policies and Performance Objectives
  • How Oracle Database QoS Management Collects and Analyzes Performance Data
  • Overview of Recommendations
• What Does Oracle Database QoS Management Manage?
  • Managing Database Resources to Meet Service Levels
  • 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
  • Creating Oracle Database QoS Management Administrator Accounts
  • Enabling Oracle Database QoS Management

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
• Monitoring Performance with Oracle Database QoS Management
• Using the Oracle Database QoS Management Dashboard
  • Accessing the Oracle Database QoS Management Dashboard
  • Enabling Oracle Database QoS Management for a Cluster
  • Disabling Oracle Database QoS Management for a Cluster
  • 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
  • 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
  • Specifying Authorized Actions for 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
  • Configuring Alerts for Quality of Service Management Events
  • Viewing the Resource Wait Times Breakdown
• Creating Administrative Users for Oracle Database QoS Management
  • QOSCTL Utility Reference
• Editing the Resource Plan for Oracle Database QoS Management

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