You will be able to:

• Understand how the Optimizer operates
• Know what tools influence the Optimizer and its decisions
• Know how to use Oracle’s built-in tools during upgrades to make tuning easier
• Identify SQL statements
• Generate explain plans with multiple options
• Know how to read the explain plan and what options are useful for what
• See what object statistics are, and what do they represent
• Know what heuristics are, and how they are used
• Learn what system statistics are, and how they are used
• See how SQL Plan Management (SPM) works
• Learn what a SQL Profile is and how it works
• Learn what a SQL Patch is, and why would you create one
• See how to trace a SQL statement and read trace information
• Gain hands-on tuning of SQL statements

Class Pricing:

• Nine hours of instruction
• $699 USD for Free members
• $559 USD for Essential and Advantage members (ask for your coupon code)
• FREE for Prime members (just ask to be registered)

Class Outline:

Session 1

• SQL - What is it good for?
• How does the Optimizer work?
  • Optimizer steps
  • Types of access (data/index)
  • Oracle's tuning tools
• Explain plan
  • How to find SQL
  • Parts of Explain plan
  • Gather stats on a plan
  • Hints
• Tracing SQL statements
  • Tracing tools
  • Basic trace
  • CBO trace
  • SQLT​​​​​​

​​Session 2

• Statistics
  • Gathering stats
  • Table stats
  • Histogram stats
  • Index stats
  • System stats
• SQL Plan Management (Baselines)
  • What is SPM?
  • Capturing plans
  • Viewing baselines
  • Evolving baselines
• Open lab

Session 3

• SQL Profiles
  • SQL Tuning Advisor
  • Creating/managing profile
  • Behind the profile
  • COE Xfer Script
  • Baselines and Profiles
• SQL Patch
  • What is a patch?
  • Manually creating a patch
  • Some patch examples
• Let's tune a statement
  • Live lab
  • Identify statement
  • Look for performance fix
  • Implement fix​​​​​​

Details: 

Class Hours: There are 9 hours of live, interactive class training divided into three 3-hour sessions.

Class Structure: OraPub believes you learn more when you freely and actively engage during the training. This is why each session is full of live demonstrations and lots of Q&A time. If you miss a session, you are free to attend that session when the class is offered again.

Watching Recorded Sessions: Each session is recorded and used to create a unique web page just for your class. The recordings can be streamed using any device, but not downloaded. You can re-watch the videos as many times as you wish. The videos and your unique class web page will be available for three years!

Class Requirements:

You will need:

• The ability to connect to the online training over the internet, hosted by Zoom. You do not need a microphone. Gary Gordhamer, the instructor, is the only one that speaks, but all students are able to type their questions, answers, and comments... it's very lively! Oracle software is not required during the live training.

• The ability to connect to the Viscosity lab using a web browser.