Did you notice that many navigation apps can suggest you in real time to deviate from the initial route because of traffic or accidents?It’s pretty cool right? You wanted to take 5th but there is an accident so your initial plan doesn’t look so good anymore once you hit the road.Oracle 12c can do the same, the optimizer can generate an execution plan (your route) keeping the door open for changes in case more data than expected is being processed (traffic / accident).This is a great feature but it requires a little shift in the way we think about performance, we need to be more open to changes just like our nagivation app. This session focuses on how this feature works, what it means for us, when it can help us and most important how to look at execution plans that can change after they started their execution.

#IOUGeniusDBReady #IOUGeniusPerformance