From oracle-l-bounce@freelists.org Wed Mar 3 17:47:47 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i23Nli018769 for ; Wed, 3 Mar 2004 17:47:44 -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 i23Nlho18764 for ; Wed, 3 Mar 2004 17:47:44 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 744A8394912; Wed, 3 Mar 2004 18:43:40 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2004 18:42:33 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from MXR-4.estpak.ee (ld3.estpak.ee [194.126.101.102]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F20CF395370 for ; Wed, 3 Mar 2004 18:42:05 -0500 (EST) Received: from localhost (reha4 [127.0.0.1]) by MXR-4.estpak.ee (Postfix) with ESMTP id 7531140ADB for ; Thu, 4 Mar 2004 01:45:51 +0200 (EET) Received: from MXR-4.estpak.ee ([127.0.0.1]) by localhost (reha4 [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22110-08 for ; Thu, 4 Mar 2004 01:45:51 +0200 (EET) Received: from porgand (217-159-135-247-dsl.kvm.estpak.ee [217.159.135.247]) by MXR-4.estpak.ee (Postfix) with SMTP id 1C73D40A7C for ; Thu, 4 Mar 2004 01:45:51 +0200 (EET) Message-ID: <0df301c40179$a8d0e6f0$a2a623d5@porgand> From: =?iso-8859-1?Q?Tanel_P=F5der?= To: References: <20040303233455.GDCE11398.lakemtao02.cox.net@smtp.east.cox.net> Subject: Re: optimizer_max_permutations Date: Thu, 4 Mar 2004 01:45:50 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at neti.ee X-archive-position: 267 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tanel.poder.003@mail.ee Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l 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: To: 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@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@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 -----------------------------------------------------------------