Re: max open cursors

Is this really the correct solution? So be generous and set your open_cursors parameter to 500. Then when it hits the limit, change it to 600. I would think most DBA's would get annoyed constantly changing this. Isn't there a programatical way to handle this?

I'm getting a similar error in a Reports program. I get hit on the open_cursors when I just do a select!

In article <TraX2.2750$Ny1.19187_at_newsfeed.slurp.net>,   "Pradhan" <empradhan_at_dplus.net> wrote:
> Hi
>
> Increase the open_cursors parameter value. Also according to oracle
> "Be generous with the OPEN_CURSORS parameter, especially in an Oracle
> Forms application environment. This will be show stopper for your
> application
> if it is set too low in initialization parameter file."
>
> HTH
> Pradhan
> mgyuri wrote in message <7gidpv$iuu_at_helka.iif.hu>...
> >Hi there !
> >I have problem a in forms 4.5. I created one big procedure wich has around
> >40 "for loop end loop" style cursors some "select into" statements and few
> >dynamic sql statements.
> >when i run this program i have "ORA-01000 maximum open cursors exceeded "
> >(it is 100, defined in initoracl.ora), and I do not understand how could it
> >happend, because as I know the "for loop end loop" cursor handling closes
> >the cursors automatically, so I can not miss the closing.
> >
> >what is wrong with that ? How can I check the number of open cursor during
> >the run time ?
> >
> >thanx in advance !
> >
> >
> >
> >
>
>

[Quoted] -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue May 04 1999 - 16:37:13 CEST