Re: open cursor limit?

The documentation says:

"Assuming that a session does not open the number of cursors specified by OPEN_CURSORS, there is no added overhead to setting this value higher than actually needed"

So the only thing you need to worry about by setting this too high is running out of memory (PGA) when too many people are connecting and running complicated applications (complicated in the sense of number of open cursors). Feel free to set it very high unless you get memory shortage error. Obviously if applications don't address the problem of leaving cursors open you need to take care of that first.

Yong Huang
yong321_at_yahoo.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. Received on Tue Dec 05 2000 - 13:50:18 CST