Re: Max open cursors

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 11 Mar 2003 21:56:52 -0000
Message-ID: <3e6e61ad_1@mk-nntp-1.news.uk.worldonline.com>

"David COSTE" <dco_at_compaq.com> wrote in message news:eh0ba.126$cs7.105_at_news.cpqcorp.net...
> Hello,
>
> I'm currently experiencing a problem with the "max open cursors" error.
> I looked into my PL/SQL code and the cursors are always closed just after
> being used.
> This is not the first time I see this problem and in both cases the
package
> DBMS_SQL was intensively used.
> Has anyone already met this problem ?
> Is there a solution (except increasing the max open cursors parameter whch
> is already set to 600) ?
> Any info would be appreciated..
>
> Thanks in advance.
> David
>
>
> PS : for info, this problem is occuring on Oracle 9.2.0 for HPUX (64 bits)
> and I already met this kind of problem with Oracle 8.0.5 under windows NT
>

David,

Double check here: are you absolutely sure you are using dbms_sql.close_cursor when you are done?

If not, revisit code.
If so, just bump up max to 1000 or so - or even double it to 1200. IIRC, they're only memory pointers; not voracious consumers of resources.

Clumsy, I know...

Regards,
Paul Received on Tue Mar 11 2003 - 15:56:52 CST