Re: Closing Explicit Cursors

From: <bdbafh_at_gmail.com>
Date: 6 Dec 2005 11:55:02 -0800
Message-ID: <1133898902.178726.185800@z14g2000cwz.googlegroups.com>

Perhaps you might spend some time on the AskTom site:

http://asktom.oracle.com

and peruse topics such
sharable sql
reusable sql
cursor_sharing

If you're looking for a quick fix, your dba could set the initialization parameter cursor_sharing='SIMILAR' instance-wide, or you could set this in your own session.

if you have dba access, flush the shared_pool after setting this parameter.

You will likely not need to increase the number of open_cursors, but a value of 512 might be a good idea.
What is the value of the initialization parameter "session_cached_cursors" set to?

btw - you posted no version information.

-bdbafh Received on Tue Dec 06 2005 - 13:55:02 CST