RE: CURSOR_SHARING=SIMILAR + ODBC May Cause Problems

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Tue, 2 Aug 2005 14:13:09 -0500
Message-ID: <1F989681BA05FA4CAD9FA849ED8520579B4C1C@pscdalpexch01.perotsystems.net>

The bugs were related to certain characteristics which are optional when you use the queues. We stopped using the queues in the manner related to the bug. Sorry I don't have a reference.

From: rjamya [mailto:rjamya_at_gmail.com]
Sent: Tuesday, August 02, 2005 2:11 PM
To: Post, Ethan
Cc: Niall Litchfield; bdbafh_at_gmail.com; Oracle-L_at_freelists.org Subject: Re: CURSOR_SHARING=SIMILAR + ODBC May Cause Problems

We use AQ and cs=force .... works just fine ... never played with similar.

Raj

On 8/2/05, Post, Ethan <Ethan.Post_at_ps.net> wrote:

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!

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 02 2005 - 14:15:05 CDT