Re: Best course to understand why a bad plan is chosen by optimizer
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 15 Sep 2019 11:19:57 -0400
Message-ID: <116ae210-21aa-d22c-b845-4cddb6790a70_at_gmail.com>
Date: Sun, 15 Sep 2019 11:19:57 -0400
Message-ID: <116ae210-21aa-d22c-b845-4cddb6790a70_at_gmail.com>
On 9/15/19 10:55 AM, Mark W. Farnham wrote:
> What we **should** have is a session and system level single
> parameter: no_adapt=TRUE|FALSE that either completely disables or
> allows following any other parameter combinations.
What we should have is the parameter proposed by Jonathan Lewis when Oracle 9i was the current version: "make_things_go_faster". Unfortunately, we still don't have that desperately needed parameter.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Sun Sep 15 2019 - 17:19:57 CEST