Re: optimizer_max_permutations
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 4 Mar 2004 01:45:50 +0200
Note that even if you set optimizer_max_permutation to a small value, then
big multitable joins may still use more permutations than set by o_m_p
parameter.
This behaviour is dependent on number of tables in join and
_optimizer_search_limit parameter. Ixora has more information on it.
Tanel.
----- Original Message -----
From: <ryan.gaffuri@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, March 04, 2004 1:34 AM
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:
