Menu

Oracle Performance Tuning Training

By Choosing this Oracle Performance Tuning Training and Certification Course at Upshot, you'll get Knowledgeable and Skillful with industry designed course syllabus. Whether Online/ Classroom Training, you get advanced guidance to become an expert.


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

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

Oracle Performance Tuning Online Training Locations in Other Cities - Indore, Gurgaon, Kolkata, Marathahalli, Ahmedabad, Bhubaneswar, Chandigarh, Coimbatore, Delhi, Electronic City, Hebbal, Hyderabad, Indira Nagar, Jaipur, Kalyan Nagar, Mumbai, Noida, Pune, Rajaji Nagar, Visakhapatnam, Chennai, Kochi.