Re: optimizer_max_permutations

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 13 Jan 2006 20:11:38 +0800
Message-ID: <43C798FA.21A@yahoo.com>

Melgar wrote:
>
> Can anyone give me any advice on lowering this parameter
> in Oracle 8.0.5
>
> Thanks in advance.
>
> ------------
> Zug Zug

anything less than 80000 (even 79999) changes the optimizer behaviour more that what you might think (but typically for the better)

its run of the reasons Oracle Apps run with o_m_p = 2000.

but as always, the rule is... try it, test it, try it some more, test it some more

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------

Received on Fri Jan 13 2006 - 06:11:38 CST