Re: Think time for the optimizer

From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Wed, 6 May 2020 18:32:30 +0100
Message-ID: <CAGtsp8muiXevTyLtV6Z36JdpEE5Xc5KdsS-DuiLkDodgXcj1Zg_at_mail.gmail.com>

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> 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 Wed May 06 2020 - 19:32:30 CEST

This message: [ Message body ]
Next message: Arjen Visser: "Re: DR Solution without Standby query"
Previous message: Jonathan Lewis: "Re: Is Parallelism happening at INSERT level?"
In reply to Lothar Flatz: "Think time for the optimizer"
Next in thread: Lothar Flatz: "Re: Think time for the optimizer"
Reply: Lothar Flatz: "Re: Think time for the optimizer"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message