Syllabus of Oracle Performance Tuning Course
Here is the syllabus of our Oracle® Performance Tuning Training which was designed as per the corporate needs.
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
Tuning Networks
- Understanding Connection Models
- Detecting Network Problems
- Solving Network Problems
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
