The Ultimate SQL Tuning Formula

The Complete, Proven, Step by Step System to Find, Troubleshoot and Fix Performance Problems in Your Oracle Database

Created by: Diana Robete
Senior Oracle DBA, Oracle Ace and Founder of DBAParadise

What Will I Learn?

• Students will be able to troubleshoot performance problems
• Students will have a good understanding of the Oracle optimizer, why it does what it does, and how it works.
• Students will be able to find the bad SQL statement
• Students will be able to implement a fix for bad SQL statements
• Students will be able to implement good performance tuning practices at work
• Students will know the exact steps to take to find and fix the performance problem. Students will know the exact step by step methodology to follow when fixing performance problems.
• Students will be the hero at work, the one that saved the day, when nobody knew what to do to fix the performance problem.

Requirements

• A basic understanding of the Oracle database is required

Target audience

• Beginner Oracle DBAs, right out of school
• Beginner and Intermediate Oracle DBAs eager to improve their performance tuning skills
• DBAs who are afraid of Oracle performance problems
• DBAs who don't know where to start when troubleshooting performance problems
• DBAs who have no understanding or knowledge about performance and tuning concepts