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@xxxxxxxxxxxxxxxxx> 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 -- //www.freelists.org/webpage/oracle-l
