Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
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
hy.qube
post Feb 23 2017, 08:40 AM
Post #1


Advanced Member
***

Group: Members
Posts: 84
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 12.1.0.2 already with the July Bundle patch applied so something optimizer related has changed. I checked the bug references and could not see anything obvious.

Anyway,

When providing an optimizer hint (/*+ optimizer_features_enable('11.2.0.4') */ ) 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.

Hakan
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: 16th August 2017 - 08:19 AM