Re: Think time for the optimizer

From: Lothar Flatz <l.flatz_at_bluewin.ch>
Date: Thu, 7 May 2020 09:31:36 +0200
Message-ID: <2b6ced54-0310-1f4e-b2b4-b5be2e866cc5_at_bluewin.ch>



Thanks,

i will test it.

Regards

Lothar

Am 06.05.2020 um 19:32 schrieb Jonathan Lewis:
>
> If a hidden parameter is allowed there is:
>
> _optimizer_cost_based_transformation which defaults to linear, but
> allows iterative and exhaustive.
>
> Regards
> Jonathan Lewis
>
>
>
> On Wed, May 6, 2020 at 4:07 PM Lothar Flatz <l.flatz_at_bluewin.ch
> <mailto:l.flatz_at_bluewin.ch>> wrote:
>
> Hi,
>
> would there be any way to give the optimizer more think time?
> I am looking for some parameter on System Level.
> Optimizer_max_permutations is hidden now.
> And it is not exactly what I am looking for.
>
> regards
>
> Lothar
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 07 2020 - 09:31:36 CEST

Original text of this message