Rahul,

It's an optimization to keep them open, for possible reuse
(oracle does not do this by accident).

In anycase, in older versions of oracle, there
was an hidden param called _close_cached_open_cursors (I think)
and if set to true in your session, open cursors
would be closed after you commit (even implicit selects).

I don't know if this still holds true in 9i,
but was true in 8i and 8, never tested on 7.

You can easily test by checking open cursors current from
v$mystat in your session run some sql then commit then
check open cursors again.

If it doesn't change, then the cursors closing behavior
isn't effected by this hidden param (or maybe it's for
Explicit cursors now).
Might also be worth checking v$sysstat not only vb$mystat.

Good luck,
Anthony

-----Original Message-----
From: Rahul Mehta
[mailto:oracledba-ezmlmshield-x6149836.[Email address protected]
Sent: Thursday, June 02, 2005 8:08 AM
To: LazyDBA Discussion
Subject: Closing Cursors

Can implicit cursors opened by SELECT,INSERT etc on Oracle 9.2.0.1 be
closed without closing the connection to database .These cursors remain
open even after the Stored procedure from which the SELECT,INSERT,UPDATE
and othe DML statements are executed.

Does this require tuning the database.

Please reply at the earliest.

Its Urgent.

Regards

RAHUL


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page