Oracle 11g Performance Tuning 2 Student Guide

Title and Copyright Information

Preface

The goal of RMAN performance tuning is to identify the bottleneck for a given job and use RMAN commands, initialization parameters, or adjustments to physical media to improve performance. Install google chrome latest version for free. How to adjust macbook pro camera settings. Before diving into a hands-on diagnosis of performance bottlenecks, it is helpful to first understand. The other recipes provide valuable ideas that may help performance of your composites. Chapter 12 promises 'High Performance Configuration'. Usb fax modem cxfu02 driver for mac. Format a usb drive for wii homebrew mac. Three of the recipes on creating a cluster, configuring an HTTP plug in and setting up distributed queues are covered better in the Oracle documentation, particularly the Enterprise Deployment Guide. New holland tx68 manual.

What's New in Oracle Performance?

Part I Performance Tuning

Oracle Client 11g

1 Performance Tuning Overview

• 1.1 Introduction to Performance Tuning
• 1.2 Introduction to Performance Tuning Features and Tools

Part II Performance Planning

2 Designing and Developing for Performance

• 2.3 Understanding Scalability
• 2.4 System Architecture
• 2.5 Application Design Principles
• 2.6 Workload Testing, Modeling, and Implementation
• 2.7 Deploying New Applications

3 Performance Improvement Methods

• 3.1 The Oracle Performance Improvement Method
• 3.2 Emergency Performance Methods

Part III Optimizing Instance Performance

4 Configuring a Database for Performance

Oracle Performance Tuning Scenarios

• 4.1 Performance Considerations for Initial Instance Configuration
• 4.2 Creating and Maintaining Tables for Optimal Performance
• 4.3 Performance Considerations for Shared Servers

5 Automatic Performance Statistics

• 5.1 Overview of Data Gathering
• 5.2 Overview of the Automatic Workload Repository
• 5.3 Managing the Automatic Workload Repository

6 Automatic Performance Diagnostics

• 6.1 Overview of the Automatic Database Diagnostic Monitor
• 6.3 Diagnosing Database Performance Problems with ADDM

7 Memory Configuration and Use

Preface

The goal of RMAN performance tuning is to identify the bottleneck for a given job and use RMAN commands, initialization parameters, or adjustments to physical media to improve performance. Install google chrome latest version for free. How to adjust macbook pro camera settings. Before diving into a hands-on diagnosis of performance bottlenecks, it is helpful to first understand. The other recipes provide valuable ideas that may help performance of your composites. Chapter 12 promises 'High Performance Configuration'. Usb fax modem cxfu02 driver for mac. Format a usb drive for wii homebrew mac. Three of the recipes on creating a cluster, configuring an HTTP plug in and setting up distributed queues are covered better in the Oracle documentation, particularly the Enterprise Deployment Guide. New holland tx68 manual.

What's New in Oracle Performance?

Part I Performance Tuning

Oracle Client 11g

1 Performance Tuning Overview

• 1.1 Introduction to Performance Tuning
• 1.2 Introduction to Performance Tuning Features and Tools

Part II Performance Planning

2 Designing and Developing for Performance

• 2.3 Understanding Scalability
• 2.4 System Architecture
• 2.5 Application Design Principles
• 2.6 Workload Testing, Modeling, and Implementation
• 2.7 Deploying New Applications

3 Performance Improvement Methods

• 3.1 The Oracle Performance Improvement Method
• 3.2 Emergency Performance Methods

Part III Optimizing Instance Performance

4 Configuring a Database for Performance

Oracle Performance Tuning Scenarios

• 4.1 Performance Considerations for Initial Instance Configuration
• 4.2 Creating and Maintaining Tables for Optimal Performance
• 4.3 Performance Considerations for Shared Servers

5 Automatic Performance Statistics

• 5.1 Overview of Data Gathering
• 5.2 Overview of the Automatic Workload Repository
• 5.3 Managing the Automatic Workload Repository

6 Automatic Performance Diagnostics

• 6.1 Overview of the Automatic Database Diagnostic Monitor
• 6.3 Diagnosing Database Performance Problems with ADDM

7 Memory Configuration and Use

• 7.1 Understanding Memory Allocation Issues
• 7.2 Configuring and Using the Buffer Cache
• 7.3 Configuring and Using the Shared Pool and Large Pool
• 7.4 Configuring and Using the Redo Log Buffer
• 7.5 PGA Memory Management
• 7.6 Using the Client Query Result Cache

8 I/O Configuration and Design

• 8.2 I/O Calibration
• 8.3 I/O Configuration

9 Understanding Operating System Resources

• 9.1 Understanding Operating System Performance Issues
• 9.2 Solving Operating System Problems
• 9.4 Finding System CPU Utilization

10 Instance Tuning Using Performance Views

• 10.1 Instance Tuning Steps
• 10.2 Interpreting Oracle Statistics
• 10.3 Wait Events Statistics
• 10.4 Real-Time SQL Monitoring
• 10.5 Tuning Instance Recovery Performance: Fast-Start Fault Recovery

Part IV Optimizing SQL Statements

11 The Query Optimizer

• 11.2 Choosing an Optimizer Goal
• 11.3 Enabling and Controlling Query Optimizer Features
• 11.4 Understanding the Query Optimizer
• 11.5 Understanding Access Paths for the Query Optimizer
• 11.6 Understanding Joins

12 Using EXPLAIN PLAN

• 12.1 Understanding EXPLAIN PLAN
• 12.3 Running EXPLAIN PLAN
• 12.4 Displaying PLAN_TABLE Output
• 12.6 Viewing Parallel Execution with EXPLAIN PLAN
• 12.9 Viewing Partitioned Objects with EXPLAIN PLAN

13 Managing Optimizer Statistics

• 13.2 Automatic Optimizer Statistics Collection
• 13.3 Manual Statistics Gathering
• 13.4 System Statistics
• 13.5 Managing Statistics
• 13.6 Viewing Statistics

14 Using Indexes and Clusters

• 14.1 Understanding Index Performance

15 Using SQL Plan Management

• 15.1 Managing SQL Plan Baselines
• 15.5 SQL Management Base

16 SQL Tuning Overview

• 16.2 Goals for Tuning
• 16.3 Identifying High-Load SQL
• 16.4 Automatic SQL Tuning Features
• 16.5 Developing Efficient SQL Statements
• 16.6 Building SQL Test Cases

17 Automatic SQL Tuning

• 17.1 Automatic Tuning Optimizer
• 17.3 Automatic SQL Tuning Advisor
• 17.4 Reactive Tuning Using the SQL Tuning Advisor
• 17.5 SQL Tuning Sets
• 17.6 SQL Profiles

18 SQL Access Advisor

• 18.1 Overview of the SQL Access Advisor
• 18.2 Using the SQL Access Advisor
• 18.3 Tuning Materialized Views for Fast Refresh and Query Rewrite

19 Using Optimizer Hints

• 19.1 Understanding Optimizer Hints
• 19.2 Specifying Hints
• 19.3 Using Hints with Views

Oracle Performance Tuning Tips

20 Using Plan Stability

• 20.1 Using Plan Stability to Preserve Execution Plans
• 20.2 Using Plan Stability with Query Optimizer Upgrades

21 Using Application Tracing Tools

Oracle 11g Performance Tuning 2 Student Guide Pdf

• 21.1 End to End Application Tracing
• 21.2 Using the trcsess Utility
• 21.3 Understanding SQL Trace and TKPROF
• 21.4 Using the SQL Trace Facility and TKPROF
• 21.5 Avoiding Pitfalls in TKPROF Interpretation
• 21.6 Sample TKPROF Output

Glossary

Index