Optimizer patch recommendation for 11.1.0.7

Thanks to Thomas Kempkens from Oracle's ACS Support who brought this to my attention:

This will just apply to 11.1.0.6 and 11.1.0.7 customers:
It is possible to get an ORA-979 for a query containing a subquery with an aggregate and no group by.
This issue is known as bug7189491 (non-public) - there are one-offs (single patches) available on top of 11.1.0.7 for Linux (32/64bit) and Solaris.
If you'll still get an ORA-979 then you might set _optimizer_group_by_placement to false

You'll find further information in Note:8260094


Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Mike Dietrich - Oracle Mike Dietrich
Senior Principal Technologist - Database Upgrade Development Group - Oracle Corporation

Based near Munich/Germany and spending plenty of time in airplanes to run either upgrade workshops or work onsite with reference customers. Acting as interlink between customers and the Upgrade Development.

Contact me either via XING or LinkedIn

Search

Archives
« July 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
  
       
Today
Slides Download Center
OOW Slides Download
Visitors since 17-OCT-2011
White Paper and Docs
Oracle Blogs
Workshops
Viewlets and Videos
This week on my Rega/iPod/CD
Workshop Map
Upgrade Reference Papers