From oracle-l-bounce@freelists.org Tue Aug 2 13:50:13 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j72IoD9L013421 for ; Tue, 2 Aug 2005 13:50:13 -0500 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 j72Io7IP013386 for ; Tue, 2 Aug 2005 13:50:07 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2EBAF1DBC6C; Tue, 2 Aug 2005 13:49:46 -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 16741-10; Tue, 2 Aug 2005 13:49:46 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9AE501DA7C4; Tue, 2 Aug 2005 13:49:45 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C59792.9EB4CC9F" Subject: RE: CURSOR_SHARING=SIMILAR + ODBC May Cause Problems Date: Tue, 2 Aug 2005 13:47:22 -0500 Message-ID: <1F989681BA05FA4CAD9FA849ED8520579B4BED@pscdalpexch01.perotsystems.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: CURSOR_SHARING=SIMILAR + ODBC May Cause Problems Thread-Index: AcWXkihTt4Pie/VlR/SAVFWOkG4KWQAADrhA From: "Post, Ethan" To: "Niall Litchfield" , Cc: X-OriginalArrivalTime: 02 Aug 2005 18:47:23.0854 (UTC) FILETIME=[9F003EE0:01C59792] X-archive-position: 23200 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Ethan.Post@ps.net Precedence: normal Reply-To: Ethan.Post@ps.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.0 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE,NORMAL_HTTP_TO_IP autolearn=no version=2.63 ------_=_NextPart_001_01C59792.9EB4CC9F Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Our application uses Advanced Queuing and there were some bugs related to AQ and SIMILAR so I have stayed away from it, but we have ran tests and seen great performance improvments because of parse issues. I am hoping to move towards it but emails like these have me sitting on EXACT again. Darn, guess we will have to fix the code! ________________________________ From: Niall Litchfield [mailto:niall.litchfield@gmail.com]=20 Sent: Tuesday, August 02, 2005 1:44 PM To: bdbafh@gmail.com Cc: Post, Ethan; Oracle-L@freelists.org Subject: Re: CURSOR_SHARING=3DSIMILAR + ODBC May Cause Problems I've had issues with cs=3Dsimilar on all versions - haven't even = bothered with 10.1.0.4. ------_=_NextPart_001_01C59792.9EB4CC9F Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Our application uses Advanced Queuing and = there were=20 some bugs related to AQ and SIMILAR so I have stayed away from it, but = we have=20 ran tests and seen great performance improvments because of parse = issues. I am=20 hoping to move towards it but emails like these have me sitting on EXACT = again.=20 Darn, guess we will have to fix the code!

From: Niall Litchfield=20 [mailto:niall.litchfield@gmail.com]
Sent: Tuesday, August 02, = 2005=20 1:44 PM
To: bdbafh@gmail.com
Cc: Post, Ethan;=20 Oracle-L@freelists.org
Subject: Re: CURSOR_SHARING=3DSIMILAR + = ODBC May=20 Cause Problems

I've had issues with cs=3Dsimilar on all versions - haven't = even=20 bothered with 10.1.0.4.

------_=_NextPart_001_01C59792.9EB4CC9F-- -- http://www.freelists.org/webpage/oracle-l