Go to Top

Home

Oracle Performance Tuning Training Course Syllabus

Performance Tuning Overview
  • • Introduction to Performance Tuning
  • • Introduction to Performance Tuning Features and Tools
Designing and Developing for Performance
  • • Oracle Methodology
  • • Understanding Investment Options
  • • Understanding Scalability
  • • System Architecture
  • • Application Design Principles
  • • Workload Testing, Modeling, and Implementation
  • • Deploying New Applications
Performance Improvement Methods
  • • The Oracle Performance Improvement Method
  • • Emergency Performance Methods
Configuring a Database for Performance
  • • Performance Considerations for Initial Instance Configuration
  • • Creating and Maintaining Tables for Good Performance
  • • Performance Considerations for Shared Servers
Automatic Performance Statistics
  • • Overview of Data Gathering
  • • Automatic Workload Repository
Automatic Performance Diagnostics
  • • Introduction to Database Diagnostic Monitoring
  • • Automatic Database Diagnostic Monitor
Memory Configuration and Use
  • • Understanding Memory Allocation Issues
  • • Configuring and Using the Buffer Cache
  • • Configuring and Using the Shared Pool and Large Pool
  • • Configuring and Using the Redo Log Buffer
  • • PGA Memory Management
I/O Configuration and Design
  • • Understanding I/O
  • • Basic I/O Configuration
Understanding Operating System Resources
  • • Understanding Operating System Performance Issues
  • • Solving Operating System Problems
  • • Understanding CPU
  • • Finding System CPU Utilization
Instance Tuning Using Performance Views
  • • Instance Tuning Steps
  • • Interpreting Oracle Statistics
  • • Wait Events Statistics
  • • Idle Wait Events
SQL Tuning Overview
  • • Introduction to SQL Tuning
  • • Goals for Tuning
  • • Identifying High-Load SQL
  • • Automatic SQL Tuning Features
  • • Developing Efficient SQL Statements

Automatic SQL Tuning
  • • Automatic SQL Tuning Overview
  • • SQL Tuning Advisor
  • • Managing SQL Profiles with APIs
  • • SQL Tuning Sets
  • • SQL Tuning Information Views
The Query Optimizer
  • • Optimizer Operations
  • • Choosing an Optimizer Goal
  • • Enabling and Controlling Query Optimizer Features
  • • Understanding the Query Optimizer
  • • Understanding Access Paths for the Query Optimizer
  • • Understanding Joins
Managing Optimizer Statistics
  • • Understanding Statistics
  • • Automatic Statistics Gathering
  • • Manual Statistics Gathering
  • • System Statistics
  • • Managing Statistics
  • • Viewing Statistics
Using Indexes and Clusters
  • • Understanding Index Performance
  • • Using Function-based Indexes for Performance
  • • Using Partitioned Indexes for Performance
  • • Using Index-Organized Tables for Performance
  • • Using Bitmap Indexes for Performance
  • • Using Bitmap Join Indexes for Performance
  • • Using Domain Indexes for Performance
  • • Using Clusters for Performance
  • • Using Hash Clusters for Performance
Optimizer Hints
  • • Understanding Optimizer Hints
  • • Using Optimizer Hints
Using Plan Stability
  • • Using Plan Stability to Preserve Execution Plans
  • • Using Plan Stability with Query Optimizer Upgrades
Using EXPLAIN PLAN
  • • Understanding EXPLAIN PLAN
  • • The PLAN_TABLE Output Table
  • • Running EXPLAIN PLAN
  • • Displaying PLAN_TABLE Output
  • • Reading EXPLAIN PLAN Output
  • • Viewing Parallel Execution with EXPLAIN PLAN
  • • Viewing Bitmap Indexes with EXPLAIN PLAN
  • • Viewing Partitioned Objects with EXPLAIN PLAN
Using Application Tracing Tools
  • • End to End Application Tracing
  • • Using the trcsess Utility
  • • Understanding SQL Trace and TKPROF
  • • Using the SQL Trace Facility and TKPROF
  • • Avoiding Pitfalls in TKPROF Interpretation
  • • Sample TKPROF Output

 

Our Clients