SkillBuilders Welcome  |  Log in
All Oracle Classes

Oracle 12c SQL Tuning - Core Skills for Beginners
1 Day Onsite or 7 Hour Online Training

Writing SQL that performs well means understanding what Oracle is doing to the SQL: how it is executing the code, and why it is executing it that way. Then make changes needed to let Oracle run the code in a more efficient manner. This course will show you how to capture and read the execution plans, and how to detect and fix the common problems that prevent code from running well.

In just one day, we will empower you: your SQL will never be the same again.

This class is a combination of lecture, live demonstrations and brief hands-on workshops.  Each student will receive, in addition to Oracle SQL Performance Tuning and Optimization (Meade), Oracle Certified Master John Watson's scripts and slides used during class.

If you prefer a more in-depth, broader coverage of SQL Tuning, consider our 3-Day SQL Tuning Class

John Watson
Average Student Rating:


  • The SQL execution cycle
  • Cost based optimization
  • Detecting badly performing SQLs

Capture and Read Plans


Optimizer Decisions

  • Join order, join method, access method
  • Why does the CBO sometimes get it wrong?
  • The importance of statistics
  • Detect and fix incorrect or inadequate statistics

The Methodology

  • Common programmer errors
  • Identify "suspicious" SQL constructs
  • Use hints to test alternative execution plans
  • Learn a proven technique for addressing problem SQLs
SkillBuilders Sample Video