RE: No parsing

From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com>
Date: Mon, 21 Mar 2005 18:03:50 -0600
Message-ID: <B39B7B7D8C8CEA419D0ED45FD7FA4C5331C867@CWYMSX06.Corp.Acxiom.net>

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_at_ness-gsg.com] Sent: Monday, March 21, 2005 5:43 PM
To: Wolfson Larry - lwolfs; Paul Drake
Cc: oracle-l_at_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" <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 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

Received on Mon Mar 21 2005 - 19:07:30 CST