Presented at INSYNC 21
Session ID: 100160
Have you had that one SQL statement that you just couldn’t figure out what the Oracle optimizer was thinking? In this session, we will take a deep dive into doing a trace and talk about some of the sledgehammer methods to influence the optimizer. You may not find the solution to that one nagging SQL but we will cover how the optimizer frustrated you so. Using these tools along with Oracle’s SQL Plan Management or Profiles you may be able to achieve your goals.
Many developers do not understand how to dig into SQL beyond the basic explain plan. Here we will cover the somewhat gory details of going deep inside how the optimizer is making decisions.