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
Scripting on this page enhances content navigation, but does not change the content in any way.