Re: Max No Of Cursors

From: <buckeye714_at_my-deja.com>
Date: Fri, 05 Jan 2001 18:04:28 GMT
Message-ID: <9352b6$t99$1@nnrp1.deja.com>

Use the initialization parameter open_cursors=<value>

Please remember that this is the maximum number of open cursors per session, not for the database as a whole. It does not cause overhead to set this value high, you only get the overhead when sessions start using the cursors.

HTH,
Patrick

In article <978712078.1954.0.nnrp-13.c2d92da9_at_news.demon.co.uk>, "Darren Lambert" <darrenlambert_at_hotmail.com> wrote:
> Hi
>
> How do I increase the maximum number of open cusrsors in Oracle 8.0.5?
>
> Thanks
>
> Darren
>
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 05 2001 - 12:04:28 CST