Re: open cursor limit?

Mike Krolewski <mkrolewski_at_rosetta.org> wrote:

>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.

Perhaps you need more imagination..We are running a multi-tier OLTP application, that , when 200 or so users are connected, has as many as 10000 open cursors at times...While I am sure the app could be refined, its pretty optimized... Received on Tue Dec 05 2000 - 12:39:03 CST