Skip Headers
Oracle® Database Quality of Service Management User's Guide
11
g
Release 2 (11.2)
Part Number E24611-02
Home
Book List
Index
Master Index
Contact Us
Next
PDF
·
Mobi
·
ePub
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
Scripting on this page enhances content navigation, but does not change the content in any way.