Re: optimizer_max_permutations
- From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 3 Mar 2004 19:41:46 -0400
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@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
