Table of Contents
- List of Figures
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Database Quality of Service Management
- 1
Introduction to Oracle Database QoS Management
- 1.1 What Is Oracle Database QoS Management?
- 1.2 Benefits of Using Oracle Database QoS Management
- 1.3
Overview of Oracle Database QoS Management
- 1.3.1 How Does Oracle Database QoS Management Work?
- 1.3.2 Overview of Policy Sets
- 1.3.3 Overview of Server Pools
- 1.3.4 How Server Pools Are Used by Oracle Database QoS Management
- 1.3.5 Overview of Performance Classes
- 1.3.6 Overview of Performance Policies and Performance Objectives
- 1.3.7 How Oracle Database QoS Management Collects and Analyzes Performance Data
- 1.3.8 Overview of Recommendations
- 1.4 What Does Oracle Database QoS Management Manage?
- 1.5 Overview of Metrics
- 2
Supported Workloads and Strategies
- 2.1 Supported Configurations for Oracle Database QoS Management
- 2.2 Strategies for Creating Classifiers for Performance Classes
- 2.3 Configuration Strategies for Effective Resource Management
- 2.4 Sample Implementation of Oracle Database QoS Management
- 2.5 Creating Oracle Database QoS Management Performance Policies for the Demo System
- 2.6 Managing Service Levels with Oracle Database QoS Management
- 3
Installing and Enabling Oracle Database QoS Management
- 3.1
Configuring Oracle Database QoS Management to Manage Oracle Database Workloads
- 3.1.1 Installing and Configuring Oracle Grid Infrastructure for a Cluster
- 3.1.2 Creating and Configuring Server Pools
- 3.1.3 Creating and Configuring an Oracle RAC Database
- 3.1.4 Creating Oracle Database QoS Management Administrator Accounts
- 3.1.5 Enabling Oracle Database QoS Management
- 3.1.6 About Multi-CPU Binding on Solaris and Quality of Service Management
- 3.1
Configuring Oracle Database QoS Management to Manage Oracle Database Workloads
- 4
Administering the Oracle Database QoS Management System
- 4.1 Determining If Oracle Database QoS Management is Enabled
- 4.2 Monitoring Performance with Oracle Database QoS Management
- 4.3
Using the Oracle Database QoS Management Dashboard
- 4.3.1 Accessing the Oracle Database QoS Management Dashboard
- 4.3.2 Enabling Oracle Database QoS Management for a Cluster
- 4.3.3 Disabling Oracle Database QoS Management for a Cluster
- 4.3.4 Interpreting the Performance Overview Graphs
- 4.3.5 Viewing Recommendations
- 4.3.6 Viewing Recommendation Details
- 4.3.7 Implementing Recommendations
- 4.4 Administering the Policy Set
- 4.5 Managing Performance Classes
- 4.6
Managing Performance Policies
- 4.6.1 Creating a Performance Policy and Specifying Performance Objectives
- 4.6.2 Editing an Existing Performance Policy
- 4.6.3 Copying a Performance Policy
- 4.6.4 Setting the Current Performance Policy
- 4.6.5 Deleting a Performance Policy
- 4.6.6 Automatically Implementing Recommendations for a Performance Policy
- 4.6.7 Setting Server Pool Directive Overrides
- 4.7 Reviewing Performance Metrics
- 4.8 Creating Administrative Users for Oracle Database QoS Management
- 4.9 Editing the Resource Plan for Oracle Database QoS Management
- 5
Troubleshooting Oracle Database QoS Management
- 5.1
Common Problems
- 5.1.1 Cannot Enable Oracle Database Quality of Service Management
- 5.1.2 Cannot Enable Oracle Database QoS Management for a Database
- 5.1.3 Oracle Database Resource Manager Not Enabled and Resource Plan Errors
- 5.1.4 Do Not Have Access to a Server Pool
- 5.1.5 Server Pool Is Marked As Unmanageable
- 5.1.6 Metrics Are Missing For a Performance Class
- 5.1.7 Oracle Database QoS Management is not Generating Recommendations
- 5.1.8 Recently Added Server was Placed in the Wrong Server Pool
- 5.1.9 RMI Port Conflict Detected
- 5.2 Locating Log or Trace Files
- 5.3 Enabling Tracing
- 5.1
Common Problems
- Glossary
- Index