Re: Problems with cursors

From: Dave Klinger <dklinger_at_bechtel.com>
Date: Thu, 10 Dec 1998 18:24:52 GMT
Message-ID: <367011F4.6B34F3C8@bechtel.com>

This is a parameter which can be set in the INIT.ORA file. There is a parameter OPEN_CURSORS which by default is set to 50. You can increase this number (need to restart the instance for the new value to be recognized). Or if this is an in-house application, the developer might want to look back at the code and see if it can be written to better utilize (releasing un-needed) cursors.

Dave

raj_raman_at_yahoo.com wrote:

> Receiving an error message - "Exceeded number of open cursors". Is this a
> problem with the parameter setting ? How do I fix it ?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Dec 10 1998 - 12:24:52 CST