On Sun, Apr 24, 2011 at 8:38 PM, Greg Rahn <greg@xxxxxxxxxxxxxxxxxx> wrote: > The problem with this vendor's recommendation is "problem scope". The > scope of the problem here is query, but the scope of the suggested > solution is global - that's a mismatch. Tuning "a" query should not > involve making global changes. What this vendor is not considering > (nor measuring) is the global impact of changing these optimizer > parameters on all the other statements that run on this database. > Modifying these parameters until the "good" plan is chosen is > certainly possible, but who is keeping track of how many other > regressions there might be? So, scope of the problem must match with > scope of the solution. > > It appear that some of you have not had to deal much with SAP folks. OICA and OIC *will* be set to SAP recommendations. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com