Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 31542 invoked from network); 12 Feb 2007 12:51:16 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 12 Feb 2007 12:51:09 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 68FF55EFFD1; Mon, 12 Feb 2007 13:12:29 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22123-01; Mon, 12 Feb 2007 13:12:29 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D8D1B5EFFE6; Mon, 12 Feb 2007 13:12:26 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 12 Feb 2007 12:37:35 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 42DFA5EE861 for ; Mon, 12 Feb 2007 12:37:35 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13728-10-2 for ; Mon, 12 Feb 2007 12:37:35 -0500 (EST) Received: from wbmler1.mail.xerox.com (wbmler1.mail.xerox.com [13.13.138.216]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D485F5EEDDE for ; Mon, 12 Feb 2007 12:36:23 -0500 (EST) Received: from wbmlir1.mail.xerox.com (wbmlir1.mail.xerox.com [13.131.8.221]) by wbmler1.mail.xerox.com (8.13.8/8.13.6) with ESMTP id l1CHbW7I003320 for ; Mon, 12 Feb 2007 12:37:32 -0500 Received: from wbmlir1.mail.xerox.com (localhost [127.0.0.1]) by wbmlir1.mail.xerox.com (8.13.8/8.13.6) with ESMTP id l1CHbO9F015442 for ; Mon, 12 Feb 2007 12:37:24 -0500 Received: from usa0300gw02.na.xerox.net (usa0300gw02.na.xerox.net [13.129.0.42]) by wbmlir1.mail.xerox.com (8.13.8/8.13.6) with ESMTP id l1CHbJYn015291 for ; Mon, 12 Feb 2007 12:37:24 -0500 Received: from usa0300ms03.na.xerox.net ([13.135.34.12]) by usa0300gw02.na.xerox.net with Microsoft SMTPSVC(6.0.3790.1830); Mon, 12 Feb 2007 12:37:24 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: maxperm parameter in 10053 trace file Date: Mon, 12 Feb 2007 12:37:23 -0500 Message-ID: <77A4D80DB2ADD74EB5D7F1D31626F0C004F81BBD@usa0300ms03.na.xerox.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: maxperm parameter in 10053 trace file From: "Hameed, Amir" To: X-OriginalArrivalTime: 12 Feb 2007 17:37:24.0412 (UTC) FILETIME=[74DA7FC0:01C74ECC] X-archive-position: 45491 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Amir.Hameed@xerox.com Precedence: normal Reply-to: Amir.Hameed@xerox.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net While reading the 10053 trace file, I noticed that even though the parameter "_optimizer_max_permutations" is set to 2000, the "maxperm" parameter shows a value of 80000, which, I believe, was the default value in Oracle8i. Can anyone shed some light on why it is showing up as 80000 in the 10053 trace file. Thanks Amir -- http://www.freelists.org/webpage/oracle-l