Re: optimizer parameters

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 25 Apr 2011 08:09:53 -0700
Message-ID: <BANLkTi=Dmed1Zbcsch_Hq+rKfAb=z=x7Gw_at_mail.gmail.com>

On Sun, Apr 24, 2011 at 8:38 PM, Greg Rahn <greg_at_structureddata.org> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 25 2011 - 10:09:53 CDT