Oracle 11g Release 2 Performance Tuning Online course

ORACLE 11g Release 2 Performance Tuning Online Class

Topic: Performance Tuning

Duration: 30 Hrs

OS: OEL 6.3

Pre-requisites: OCP knowledge

Contact : 91-8553162006
Email: enquiry@amktechs.com

Syllabus
--------

 1 Performance Tuning Overview

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

 2 Designing and Developing for Performance

 3 Performance Improvement Methods

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

 4 Configuring a Database for Performance

• 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.2 Setting Up ADDM
• 6.3 Diagnosing Database Performance Problems with ADDM
• 6.4 Views with ADDM Information

 7 Configuring and Using Memory

• 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 Managing the Server and Client Result Caches

 8 I/O Configurations and Design

• 8.1 About I/O
• 8.2 I/O Configuration

  9 Managing Operating System Resources

• 9.1 Understanding Operating System Performance Issues
• 9.2 Resolving Operating System Issues
• 9.3 Understanding CPU
• 9.4 Resolving CPU Issues

 10 Instance Tuning Using Performance Views

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

 11 The Query Optimizer

• 11.1 Overview of the Query Optimizer
• 11.2 Overview of Optimizer Access Paths
• 11.4 Reading and Understanding Execution Plans
• 11.5 Controlling Optimizer Behavior

 12 Using EXPLAIN PLAN

• 12.1 Understanding EXPLAIN PLAN
• 12.2 The PLAN_TABLE Output Table
• 12.3 Running EXPLAIN PLAN

 13 Managing Optimizer Statistics

• 13.1 Overview of Optimizer Statistics
• 13.2 Managing Automatic Optimizer Statistics Collection
• 13.3 Gathering Statistics Manually

 14 Using Indexes and Clusters

• 14.1 Understanding Index Performance

 15 Using SQL Plan Management

• 15.1 Overview of SQL Plan Baselines
• 15.2 Managing SQL Plan Baselines
• 15.3 Using SQL Plan Baselines with SQL Tuning Advisor
• 15.4 Using Fixed SQL Plan Baselines
• 15.5 Displaying SQL Plan Baselines
• 15.6 SQL Management Base
• 15.7 Importing and Exporting SQL Plan Baselines
• 15.8 Migrating Stored Outlines to SQL Plan Baselines

 16 SQL Tuning Overview

• 16.1 Introduction to SQL Tuning
• 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 Overview of the Automatic Tuning Optimizer
• 17.2 Managing the Automatic SQL Tuning Advisor
• 17.3 Tuning Reactively with SQL Tuning Advisor
• 17.4 Managing SQL Tuning Sets
• 17.5 Managing SQL Profiles

 18 SQL Access Advisor

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

 19 Using Optimizer Hints

• 19.1 Overview of Optimizer Hints
• 19.2 Specifying Hints
• 19.3 Using Hints with Views

 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

• 21.1 End to End Application Tracing
• 21.2 Using the trcsess Utility
• 21.3 Understanding SQL Trace and TKPROF