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

-----Original Message-----
From: Brajesh.Jaiswal [mailto:brajesh.kj@xxxxxxxxxxxx] 
Sent: Monday, March 21, 2005 5:43 PM
To: Wolfson Larry - lwolfs; Paul Drake
Cc: oracle-l@xxxxxxxxxxxxx
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" <lawrence.wolfson@xxxxxxxxxx>
To: "Brajesh.Jaiswal" <brajesh.kj@xxxxxxxxxxxx>; "Paul Drake"
<bdbafh@xxxxxxxxx>
Cc: <oracle-l@xxxxxxxxxxxxx>
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

Other related posts: