Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Open_cursor
You can set the value of OPEN_CURSORS at the init<SID>.ora file.
It is located at $ORACLE_HOME/dbs.
Zeeshan Basharat 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
> **********************
Received on Mon Oct 09 2000 - 17:02:25 CDT