I have recently applied the latest bundle patch onto one of our 12c environments and we have seen a small number (not checked everything as yet) causing different execution plans. The environment was on 220.127.116.11 already with the July Bundle patch applied so something optimizer related has changed. I checked the bug references and could not see anything obvious.
When providing an optimizer hint (/*+ optimizer_features_enable('18.104.22.168') */ ) the query runs in seconds rather than minutes.
I am wondering if anyone else has hit this issue?
We have the exact same environment before the patch was applied and it runs the same query fine.