Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: No parsing

Re: No parsing

From: Brajesh.Jaiswal <brajesh.kj_at_ness-gsg.com>
Date: Tue, 22 Mar 2005 05:56:11 +0530
Message-ID: <0c0601c52e75$c234aad0$c300840a@chordiantepc.com>


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" <lawrence.wolfson_at_acxiom.com> To: "Brajesh.Jaiswal" <brajesh.kj_at_ness-gsg.com>; "Paul Drake" <bdbafh_at_gmail.com>
Cc: <oracle-l_at_freelists.org>
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
Received on Mon Mar 21 2005 - 19:22:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US