Oracle Performance Tuning Training
Oracle Performance Tuning Training is an online course designed to make you an expert in various Oracle database performance issues and learn about different locations to check for the performance information along with tuning approach.
Oracle Performance Tuning Training Curriculum
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
curriculum_moduleMemory 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