- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: Richard.Goulet@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 23 Dec 2009 11:10:30 -0800 (PST)
From: Oracle® Database JDBC Developer's Guide, 11g Release 2 (11.2) Part Number E10589-03 Sounds like closing cursors is still a best practice. I'd ask your developers to put up or shut-up. :) Memory Leaks and Running Out of Cursors If you receive messages that you are running out of cursors or that you are running out of memory, make sure that all your Statement and ResultSet objects are explicitly closed. Oracle JDBC drivers do not have finalizer methods. They perform cleanup routines by using the close method of the ResultSet and Statement classes. If you do not explicitly close your result set and statement objects, significant memory leaks can occur. You could also run out of cursors in the database. Closing a statement releases the corresponding cursor in the database. Similarly, you must explicitly close Connection objects to avoid leaking and running out of cursors on the server-side. When you close the connection, the JDBC driver closes any open statement objects associated with it, thus releasing the cursor on the server-side. Here is a link to the new features page for this document: http://download.oracle.com/docs/cd/E11882_01/java.112/e10589/whatsnew.htm#BGBBIBAE Same page for 11gR1: http://download.oracle.com/docs/cd/B28359_01/java.111/b31224/whatsnew.htm#sthref6 I don't see anything that sounds like what they describe... RF Robert G. Freeman Oracle ACE Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it! Author: Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Oracle Database 10g New Features (Oracle Press) Other various titles Blog: http://robertgfreeman.blogspot.com Check out my new blog series on installing Oracle Database 11gR2 on Windows using VMWare! ________________________________ From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx> To: oracle-l@xxxxxxxxxxxxx Sent: Wed, December 23, 2009 11:31:05 AM Subject: Cursors Cursors All, First off, Merry Christmas, Happy Hanukah, Happy Kwanza, etc… to one and All. I'm trying to track down a perception that some of our developers have that there is no longer, post Oracle 10g R1, a need for their applications to close cursors. I've searched the Oracle docs, Metalink, and Google to no avail. Anyone else hear about this "feature"? Dick Goulet Senior Oracle DBA/NA Team Lead PAREXEL International 900 Chelmsford St, Suite 310 Lowell, MA 01821 978.614.2857 Richard.Goulet@xxxxxxxxxxx The information transmitted in this communication is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please destroy any copies, contact the sender and delete the material from any computer.
- From: Goulet, Richard