From oracle-l-bounce@freelists.org Mon Mar 21 19:07:30 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j2M17UNc013580 for ; Mon, 21 Mar 2005 19:07:30 -0600 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 j2M17Uem013576 for ; Mon, 21 Mar 2005 19:07:30 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CD35987D68; Mon, 21 Mar 2005 19:05:43 -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 01348-10; Mon, 21 Mar 2005 19:05:43 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4F08F87BB6; Mon, 21 Mar 2005 19:05:43 -0500 (EST) Message-ID: From: Wolfson Larry - lwolfs To: "Brajesh.Jaiswal" , Paul Drake Cc: oracle-l@freelists.org Subject: RE: No parsing Date: Mon, 21 Mar 2005 18:03:50 -0600 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 17558 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: lawrence.wolfson@acxiom.com Precedence: normal Reply-To: lawrence.wolfson@acxiom.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.1 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: Brajesh, And to answer Paul's question the platform is? Is it possible someone altered your udump destination? Can you run either the 10053 or 10046 trace on another statement using an ALTER SESSION command? Like "select count(*) from (the smallest table)". Larry -----Original Message----- From: Brajesh.Jaiswal [mailto:brajesh.kj@ness-gsg.com] Sent: Monday, March 21, 2005 5:43 PM To: Wolfson Larry - lwolfs; Paul Drake Cc: oracle-l@freelists.org Subject: No parsing Larry, No trace with 10053 CBO also and no change with init.ora (their DBA told he has not changed any parameter in the init.ora) It appears to be platform specific bug. Have asked tha client to provide the value for cursor_sharing and compatible parameter from init.ora. Regards Brajesh ----- Original Message ----- From: "Wolfson Larry - lwolfs" To: "Brajesh.Jaiswal" ; "Paul Drake" Cc: Sent: Tuesday, March 22, 2005 4:38 AM Subject: RE: No parsing > Brajesh, > It doesn't always have to be a major change to cause a problem. > Are there differences? > > What about the 10053 CBO trace? That should show you what CBO is > thinking? > > Can you answer Paul's question about the OS? > > Larry ********************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- http://www.freelists.org/webpage/oracle-l