RE: optimizer_max_permutations

From: <Jared.Still_at_radisys.com>
Date: Thu, 4 Mar 2004 14:02:09 -0800
Message-ID: <OFF8BF145A.363AF000-ON88256E4D.0079015F-88256E4D.0078F628@radisys.com>

... and the default for optimizer_features_enable is 9.2

Thomas Jeff <jeff.thomas_at_thomson.net>
Sent by: oracle-l-bounce_at_freelists.org
03/04/2004 10:26 AM
Please respond to oracle-l

        To:     "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>
        cc: 
        Subject:        RE: optimizer_max_permutations

Actually, the default is 2000 in 9.2.0.4 only if optimizer_features_enable is set to 9.2.
Set optimizer_features_enable back to 8.1.7 and permutations will default to 80000.
-----Original Message-----

From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com] Sent: Wednesday, March 03, 2004 7:04 PM
To: oracle-l_at_freelists.org
Subject: Re: optimizer_max_permutations

As the default value on 9.2.0.4 is already 2000, I don't think you will see much difference.

Jared

<ryan.gaffuri_at_cox.net>
Sent by: oracle-l-bounce_at_freelists.org
03/03/2004 03:34 PM
Please respond to oracle-l

        
        To:        oracle-l_at_freelists.org 
        cc:         
        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

Received on Thu Mar 04 2004 - 17:33:24 CST