From oracle-l-bounce@freelists.org Thu Mar 4 14:33:53 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i24KXrs31193 for ; Thu, 4 Mar 2004 14:33:53 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i24KXVo31131 for ; Thu, 4 Mar 2004 14:33:32 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B29F0397863; Thu, 4 Mar 2004 13:53:16 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 04 Mar 2004 13:51:54 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from dmzraw2.extranet.tce.com (dmzraw2.extranet.tce.com [157.254.234.138]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 20ABB396642 for ; Thu, 4 Mar 2004 13:22:26 -0500 (EST) Received: from smtprelay2.indy.tce.com ([157.254.96.95]) by dmzraw2.extranet.tce.com (8.12.5/8.12.5) with ESMTP id i24IQPg7016507 for ; Thu, 4 Mar 2004 18:26:25 GMT Received: from indymsxcs04.indy.tce.com (localhost [127.0.0.1]) by smtprelay2.indy.tce.com (8.12.9/8.12.8) with ESMTP id i24IQN7n009633 for ; Thu, 4 Mar 2004 18:26:24 GMT Received: by indymsxcs04.indy.tce.com with Internet Mail Service (5.5.2653.19) id ; Thu, 4 Mar 2004 13:26:12 -0500 Message-ID: <358728A276824E419580403633AABFD001B7B836@INDYSMAIL03.am.thmulti.com> From: Thomas Jeff To: "'oracle-l@freelists.org'" Subject: RE: optimizer_max_permutations Date: Thu, 4 Mar 2004 13:26:14 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C40216.2D59AD54" X-archive-position: 369 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jeff.thomas@thomson.net Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C40216.2D59AD54 Content-Type: text/plain 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@radisys.com [mailto:Jared.Still@radisys.com] Sent: Wednesday, March 03, 2004 7:04 PM To: oracle-l@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 Sent by: oracle-l-bounce@freelists.org 03/03/2004 03:34 PM Please respond to oracle-l To: oracle-l@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@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 ----------------------------------------------------------------- ------_=_NextPart_001_01C40216.2D59AD54 Content-Type: text/html Content-Transfer-Encoding: quoted-printable Message
Actually, the default is 2000 in 9.2.0.4 only if=20 optimizer_features_enable is set to 9.2. 
Set optimizer_features_enable back to 8.1.7 and = permutations will=20 default to 80000.
-----Original Message-----
From:=20 Jared.Still@radisys.com [mailto:Jared.Still@radisys.com] =
Sent:=20 Wednesday, March 03, 2004 7:04 PM
To:=20 oracle-l@freelists.org
Subject: Re:=20 optimizer_max_permutations


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

Jared=20




<ryan.gaffuri@cox.net>
Sent by: = oracle-l-bounce@freelists.org=20

 03/03/2004 03:34 = PM=20
 Please respond to oracle-l

        =
        To: =    =20    oracle-l@freelists.org
        cc:      =20  
  =    =20   Subject:      =20 =  optimizer_max_permutations



= I've been talking to Oracle Support = about some=20 performance problems and they told me to set=20 optimizer_max_permutations=3D2000

Has anyone tested how this = effects the=20 CBO? This is on 9.2.0.4 on Solaris.=20 =

----------------------------------------------------------------=
Please=20 see the official ORACLE-L FAQ:=20 = http://www.orafaq.com
-----------------------------------------------= -----------------
To=20 unsubscribe send email to: =  oracle-l-request@freelists.org
put=20 'unsubscribe' in the subject line.
--
Archives are at=20 http://www.freelists.org/archives/oracle-l/
FAQ is at=20 = http://www.freelists.org/help/fom-serve/cache/1.html
----------------= -------------------------------------------------


------_=_NextPart_001_01C40216.2D59AD54-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------