SQL Gone Wild! – Taming and Tuning the Optimizer (Connect 2019)

The root cause of most database performance issues is bad or sub-optimal SQL execution plans. This session not only covers optimizer internals and new optimizer features introduced in versions 12c, 18c and 19c but also outlines a practical approach to SQL optimization, identification, and elimination of SQL performance issues by ensuring SQL Plan stability as well as influencing the Oracle optimizer via the use of appropriate hints.