Re: Open_cursor

From: <oratune_at_aol.com>
Date: Wed, 27 Sep 2000 01:06:27 GMT
Message-ID: <8qrh6g$qj3$1@nnrp1.deja.com>

In article <39d1bb06_at_news.cyber.net.pk>, "Zeeshan Basharat" <shani2000_at_usa.net> wrote:
> From where I can increase the value of OPEN_CURSORS.
>
> My program shows this message when I use it frequently.
>
> ORA-01000 maximum open cursors exceeded.
>
> Please help me.
> Thanks in advance
>
> Bye,
> Zeeshan Basharat.
> ICQ:50080409
> **********************
>
>

That is an init<SID>.ora parameter:

open_cursors = xxxxxxx

where xxxxxxx is the number of open cursors.

--
David Fitzjarrell
Oracle Certified DBA


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

Received on Tue Sep 26 2000 - 20:06:27 CDT