Re: max open cursors

From: <>
Date: Tue, 04 May 1999 14:37:13 GMT
Message-ID: <7gn0mp$97v$>

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$>,   "Pradhan" <> 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."
> Pradhan
> mgyuri wrote in message <7gidpv$>...
> >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 ==---------- Search, Read, Discuss, or Start Your Own Received on Tue May 04 1999 - 16:37:13 CEST

Original text of this message