Re: open cursor limit?

From: David Fitzjarrell <oratune_at_aol.com>
Date: Tue, 05 Dec 2000 17:55:16 GMT
Message-ID: <90ja5v$e2a$1@nnrp1.deja.com>

In our last gripping episode 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.
>

I have set it as high as 1100 without any resource problems.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Tue Dec 05 2000 - 11:55:16 CST