Re: Cursors

From: Robert Freeman <>
Date: Wed, 23 Dec 2009 11:10:30 -0800 (PST)
Message-ID: <>


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

Here is a link to the new features page for this document:

Same page for 11gR1:

I don't see anything that sounds like what they describe...


 Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it!
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
Check out my new blog series on installing Oracle Database 11gR2 on Windows using VMWare!

From: "Goulet, Richard" <>
Sent: Wed, December 23, 2009 11:31:05 AM
Subject: Cursors

        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 
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.

Received on Wed Dec 23 2009 - 13:10:30 CST

Original text of this message