Welcome Guest ( Log In | Register )



Performance Tuning Reference poster
Oracle training in Linux 

Oracle training Weblogic Book
Easy Oracle Jumpstart
Oracle training & performance tuning books
Burleson Consulting Remote DB Administration
Reply to this topicStart new topic
> 12 Bundle Patch affecting Query Plans, January 2017 bundle patch for windows effects performance queries
post Feb 23 2017, 08:40 AM
Post #1

Advanced Member

Group: Members
Posts: 86
Joined: 17-May 14
From: London
Member No.: 49,627

Hi All,

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 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('') */ ) 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.

Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


Lo-Fi Version Time is now: 23rd October 2017 - 01:37 PM