Oracle SQL Tuning Training

Live Online & Classroom Enterprise Training

Are you looking to upgrade your skills on RDBM performance tuning? Specifically in Oracle database server? Then this course is what you should look at. Our training course covers aspects related to SQL tuning, optimizations, analyzing execution plans, optimizer statistics, advisor and performance management.

Looking for a private batch ?

REQUEST A CALLBACK
Key Features
  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

  • 100% Money Back Guarantee

PDP BG 1
SpringPeople Logo

What is Oracle SQL Tuning training about?

Oracle SQL Tuning training covers the need for SQL Tuning internals on Query Optimizer and optimizing performance by modifying a SQL statement to perform at its best - for example using different possible methods of accessing data including different join methods.

What are the objectives of Oracle SQL Tuning training?

  • Understand the need for SQL Tuning
  • Understand how the Query Optimizer makes decisions about how to access data
  • Define how optimizer statistics affect the performance of SQL
  • List the possible methods of accessing data, including different join methods
  • Modify a SQL statement to perform at its best
Available Training Modes

Live Online Training

Classroom Training

 

PDP BG 2

Who is Oracle SQL Tuning training for?

  • Anyone who wants to add Oracle SQL Tuning skills to their profile
  • Teams getting started on Oracle SQL Tuning projects
  • What are the prerequisites for Oracle SQL Tuning training?

    Working knowledge of SQL on Oracle.

    Course Outline

    • Why Oracle Performance Tuning ?
      • Tuning Challenges
      • Performance Metrics
      • Management and Advisory Framework
      • ADDM and AWR
      • SQL Tuning Privileges
    • Understanding the Oracle Database Architecture
      • Introduction to Oracle Database Server Architecture
      • Introduction to Oracle Database Memory Structures
      • Database Storage Architecture, Logical and Physical Database Structures
      • Segments, Extents, and Blocks & SYSTEM and SYSAUX Tablespaces
    • Introduction to SQL Tuning
      • Reason for Inefficient SQL Performance
      • Performance Monitoring Solutions
      • CPU and Wait Time Tuning Dimensions
      • Scalability with Application Design, Implementation, and Configuration
      • Common Mistakes on Customer systems & Proactive Tuning Methodology
      • Simplicity in Application Design
    • Introduction to the Optimizer
      • Structured Query Language
      • SQL Statement Parsing: Overview
      • Why Do You Need an Optimizer?
      • Optimization During Hard Parse Operation
      • Transformer & Estimator
      • Cost-Based Optimizer
      • Plan Generator
      • Controlling the Behavior of the Optimizer, Optimizer Features and Oracle Database Releases
    • Understanding The Optimizer
      • Optimization Methods
      • Optimization Goals
      • Optimizer related parameters
      • Optimizer Components
      • Execution Plan Operations
    • Interpreting Execution Plans
      • What Is an Execution Plan? Where To Find Execution Plans and Viewing Execution Plans
      • Plan Table & AUTOTRACE
      • Using the V$SQL_PLAN View
      • Interpreting an Execution Plan
      • Reading More Complex Execution Plans and Reviewing the Execution Plan
      • Looking Beyond Execution Plans
      • Collecting Performance Statistics
      • Real-Time SQL Monitoring
    • Execution Plan Methods and Operations
      • Table Access Methods
      • Join Methods
      • Index Operations
      • Data Operations
    • Application Tracing
      • End-to-End Application Tracing Challenge
      • Location for Diagnostic Traces
      • What is a Service? Use Services with Client Applications & Tracing Services
      • Session Level Tracing
      • The trcsess Utility and SQL Trace File Contents
      • Invoking the tkprof Utility and Output of the tkprof Command
    • Optimizer: Table and Index Operations
      • Row Source Operations, Main Structures and Access Paths
      • Full Table Scan
      • Indexes: Overview and B*-tree Indexes and Nones
      • Index-Organized Tables
      • Bitmap Indexes, Bitmap Operations and Bitmap Join Index
      • Composite Indexes and Invisible Index
      • Guidelines for Managing Indexes and Investigating Index Usage
    • Optimizer Join Methods
      • Nested Loops Join
      • Nested Loops Join: 11g Implementation
      • Sort Merge join
      • Hash Join and Cartesian Join
      • Equijoins and Nonequijoins
      • Outer Joins
      • Semijoins
      • Antijoins
    • Optimizer: Other Operators
      • When Are Clusters Useful?
      • Sorting Operators and Buffer Sort Operator
      • Filter operations and Concatenation Operations
      • UNION [ALL], INTERSECT, MINUS
      • Result Cache Operator
    • Optimizer Statistics
      • Types of Optimizer Statistics
      • Table, Index and Column Statistics
      • Index Clustering Factor
      • Multicolumn Statistics and Expression Statistics
      • Gathering System Statistics and Statistic Preferences
      • Manual Statistics Gathering
      • Locking Statistics, Export/Import Statistics and Set Statistics
      • More About Optimizer Statistics
      • Automatic Maintenance Tasks
      • Using Historical Statistics
      • Dynamic Sampling
    • Enhanced Optimizer Statistics
      • About Optimizer System Statistics
      • Manage System Statistics
      • Pending and Published Statistics
    • Using Bind Variables
      • Cursor Sharing and Different Literal Values
      • Cursor Sharing and Bind Variables
      • Bind Variable Peeking
      • Cursor Sharing Enhancements
      • The CURSOR_SHARING Parameter
      • Forcing Cursor Sharing
      • Adaptive Cursor Sharing
      • Interacting with Adaptive Cursor Sharing
    • Histograms and Extended Statistics
      • Why Are Histograms Needed?
      • Histograms Internal Structure
      • Manually Managing Histograms
      • Expression Statistics
      • Multicolumn Statistics
    • Using SQL Tuning Advisor
      • Tuning SQL Statements Automatically
      • Application Tuning Challenges
      • SQL Tuning Advisor: Overview
      • Stale or Missing Object Statistics and SQL Statement Profiling
      • Plan Tuning Flow and SQL Profile Creation
      • SQL Tuning Loop, Access Path Analysis and SQL Structure Analysis
      • Database Control and SQL Tuning Advisor
      • Implementing Recommendations
    • The SQL Access Advisor
      • Using The SQL Access Advisor
      • SQL Access Advisor Templates
      • Performing A Quick Tune Task
      • Index Database Parameters
    • Managing Cursor Sharing
      • About Cursor Sharing
      • Bind Variables and Cursor Sharing
      • Finding Candidates For Rewrite
    • Using Automatic SQL Tuning
      • Automatic SQL Tuning
      • Automatic Tuning Process
      • Automatic SQL Tuning example
    • SQL Performance Management
      • Maintaining SQL Performance and SQL Plan Management
      • SQL Plan Baseline
      • Using SQL Performance Analyzer and SQL Plan Baseline

    Who is the instructor for this training?

    The trainer for this Oracle SQL Tuning has extensive experience in this domain, including years of experience training & mentoring professionals.

    Reviews