I has 2000 and I don't have too much problems, this only affects the hard
parse stage, but you can get better execution plans, I think the best you
can do is test in your situation, maybe you don't get nothing and are better
as you were before, or maybe you can get an important imporvement.
For e xample if you are not binding this could decrease the performance in
your system, it depends on severla factor.
----- Original Message -----
From: <ryan.gaffuri_at_cox.net>
To: <oracle-l_at_freelists.org>
Sent: Wednesday, March 03, 2004 7:34 PM
Subject: optimizer_max_permutations
> I've been talking to Oracle Support about some performance problems and
they told me to set optimizer_max_permutations=2000
>
> Has anyone tested how this effects the CBO? This is on 9.2.0.4 on Solaris.
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Mar 03 2004 - 17:43:16 CST
