From oracle-l-bounce@freelists.org Thu May 19 16:09:43 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j4JL9htg015784 for ; Thu, 19 May 2005 16:09:43 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j4JL9h4Z015780 for ; Thu, 19 May 2005 16:09:43 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1B8051954A7; Thu, 19 May 2005 15:06:52 -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 13081-09; Thu, 19 May 2005 15:06:52 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 976281955E6; Thu, 19 May 2005 15:06:51 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Subject: Cost Based Optimizer Date: Thu, 19 May 2005 21:04:47 +0100 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Cost Based Optimizer Thread-Index: AcVcqUbFKxAUqJxfQJqU3UicjhYHIAAAkVdw From: "Terry Barnett" To: X-OriginalArrivalTime: 19 May 2005 20:04:48.0049 (UTC) FILETIME=[022CEA10:01C55CAE] X-LandmarkExeter-MailScanner-Information: Please contact systeam@landmarkinfo.co.uk for more info X-LandmarkExeter-MailScanner: Found to be clean X-MailScanner-From: tbarne@landmark-information.co.uk X-archive-position: 19973 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tbarne@landmark-information.co.uk Precedence: normal Reply-To: tbarne@landmark-information.co.uk X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.2 required=5.0 tests=EXCUSE_16 autolearn=no version=2.63 I am having issues with execution plans changing even though the statistics on tables are kept static. Can anyone give me any information on the dynamic factors which are taken into account by the CBO when determining an execution plan and how one could detect that a plan may be about to change. Regards, Terry =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in=20 error please notify Landmark=20 Information Group on +44(0) 1392=20 441700. For more information about the=20 Landmark Information Group visit http://www.landmark-information.co.uk This email and any attachments have been scanned for viruses and to the best of our knowledge are clean. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D -- http://www.freelists.org/webpage/oracle-l