Re: 10GR2 vs. 10GR1 Java Open Cursor Differences

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Sun, 14 Jan 2007 00:31:28 -0500
Message-ID: <c2213f680701132131y73416f14hfd451010852d7722@mail.gmail.com>

As Fritz mentioned, I posted a note here - http://www.pythian.com/blogs/356/oracle-10203-patchset-known-issues-and-bugs

I found the number bug only mentioned in the patch itself: 5705795: MANY CHILD CURSORS CREATED FOR AMAZON-LIKE WORKLOAD IN 10.2.0.3 On ML I found it as Bug 5705795 - Win/Linux: Many child cursors possible for SQL using BINDS -
https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=5705795.8

On 1/12/07, MacGregor, Ian A. <ian_at_slac.stanford.edu> wrote:
> Are you referencing Note:1020427.102? If not please post the Bug number. Oracle states it is not a bug, but an optimization. That's something which has been around for a long time certainly beofre 10gR2.
>
> Testing has shown that closing the statement without explicitly closing the results set does not result in open cursor buildup. However when the entire application is run we still have the problem. Perhaps there are times when one has to close the results set that the test is missing.
>
> Ian

-- 
Best regards,
Alex Gorbachev

The Pythian Group
Sr. Oracle DBA

http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jan 13 2007 - 23:31:28 CST