Skip to Main Content

Write Great SQL Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

November 24

14:00 - 15:00   Start Times Around the World

Description

How to Use SQL Plan Baselines and SQL Profiles
The Oracle optimizer has many tools and tricks for finding the best plan for each query. But in some cases, it may struggle to find a fast plan. Luckily Oracle Database has many tools to help the optimizer pick a good plan for each query.

This session gives an overview of plan baselines and profiles to assist the optimizer. It shows you how they work, explains the differences between them and why you would use one over the other.

Your Experts

Chris Saxon
Chris Saxon, Oracle Developer Advocate for SQL    
Chris Saxon is the quizmaster for the Database Design competitions and an Oracle Developer Advocate for SQL. His job is to help you get the best out of the Oracle Database and have fun with SQL! He's also part of the answer team on Ask TOM and creates YouTube videos at The Magic of SQL channel.
Nigel Bayliss
Nigel Bayliss, Optimizer Product Manager    
I'm the product manager for the Oracle Optimizer. I started out as an Oracle DBA and application developer in 1988, gradually migrating to the field of consulting, specializing in database design and performance management. I joined Oracle Consulting in 1996 where I concentrated on delivering performance-critical, very large database applications. Since then, I've been involved in a wide variety of different roles including development, benchmarking and pre-sales (with a particular emphasis on Oracle Exadata). I am part of the Oracle Data Warehouse Product Management team.