Loading…
Monday March 24, 2025 11:30am - 12:15pm MDT
Whether you're new to SQL tuning or celebrating your 10th year, this session offers valuable insights for all skill levels. We’ll begin with a quick introduction to SQL and the Oracle Optimizer, followed by specific examples and tips on various SQL tuning options and methods. The goal is to provide practical takeaways without delving too deeply into any one area. Example code and demonstrations will be included.

Learning objectives include:
- What is SQL tuning?
- Which tools should I use?
- Why Explain Plan may be misleading
- The importance of statistics and histograms
- How to use Tuning Advisor and AWR Top N SQL
- Why SQL Profiles fail
- How to create a SQL Baseline from the cursor cache
- How to create a SQL Patch
- Optimizer tuning techniques
- Why isn’t my index being used? (Index clustering)
Speakers
avatar for Gary Gordhamer

Gary Gordhamer

Managing Principal Consultant, Viscosity North America
Gary Gordhamer has spent much of his career focusing on enterprise application landscapes and business process digitization. His technical experience spans more than 30 years with Oracle E-Business Suite, middleware, databases, and related technologies. His professional background... Read More →
Monday March 24, 2025 11:30am - 12:15pm MDT
Room 105

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Share Modal

Share this link via

Or copy link