From oracle-l-bounce@freelists.org Mon Mar 21 19:22:10 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j2M1MAcZ014827 for ; Mon, 21 Mar 2005 19:22:10 -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 j2M1M8em014821 for ; Mon, 21 Mar 2005 19:22:09 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F344B882B3; Mon, 21 Mar 2005 19:20:21 -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 03085-01; Mon, 21 Mar 2005 19:20:21 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 65AF288092; Mon, 21 Mar 2005 19:20:21 -0500 (EST) Message-ID: <0c0601c52e75$c234aad0$c300840a@chordiantepc.com> From: "Brajesh.Jaiswal" To: "Wolfson Larry - lwolfs" , "Paul Drake" Cc: References: Subject: Re: No parsing Date: Tue, 22 Mar 2005 05:56:11 +0530 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-OriginalArrivalTime: 22 Mar 2005 00:17:45.0030 (UTC) FILETIME=[91FD2E60:01C52E74] X-imss-version: 2.023 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:2 M:12 S:5 R:5 X-imss-settings: Baseline:1 C:1 M:1 S:1 R:1 (0.0000 0.0000) X-archive-position: 17559 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: brajesh.kj@ness-gsg.com Precedence: normal Reply-To: brajesh.kj@ness-gsg.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.2 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: Larry, Platform is HP UX 11.11. They are able to generate trace file for some simple query. But large and complex query with many views in from clause , group by and exists statement are failing to execute. Regards Brajesh ----- Original Message ----- From: "Wolfson Larry - lwolfs" To: "Brajesh.Jaiswal" ; "Paul Drake" Cc: Sent: Tuesday, March 22, 2005 5:33 AM Subject: RE: No parsing > 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 > -- http://www.freelists.org/webpage/oracle-l