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@xxxxxxxxxx <mailto:l.flatz@xxxxxxxxxx>> 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
--
//www.freelists.org/webpage/oracle-l