Re: open cursor limit?

OK.... But, if you have session_cached_cursors set high, you could reach the limit just the same, even if the app closes them, right?

-Kevin

"Mike Krolewski" <mkrolewski_at_rosetta.org> wrote in message news:90jb4h$f1g$1_at_nnrp1.deja.com...
> In article <90ja1u$dvc$1_at_nnrp1.deja.com>,
> susana73_at_hotmail.com wrote:
> > Hi,
> >
> > I have open_cursor=250 and keeping getting the maximum cursor error
> > message. I am wondering can I increase it as large as I want? What
> > kind of resource will it take on the server if I increase it? Does it
> > take up any resource even my apps is not running?
> >
> > Thanks,
> > Susan
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> You might want to look into what is causing you to consume so many
> cursors. My prior experience is that your code is not closing a cursor
> or that you are recursively requesting cursors -- both are not good
> programming. This is especially important in packages. Look for
> explicit cursor opens. Implicit cursors associated with a single select
> or loops are by definition safe.
>
> I cannot image having more than 5 cursor open at any given time for any
> given program.
>
>
> Michael Krolewski
> Rosetta Inpharmatics
> mkrolewski_at_rosetta.org
> Ususual disclaimers
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Dec 05 2000 - 12:59:54 CST