Re: Nebie - ORA-01000maximum open cursors exceeded

From: Stewart Burnett <Stewart_at_burnettms.nospam.demon.co.uk>
Date: Mon, 12 Oct 1998 16:27:41 +0100
Message-ID: <6vt75n$29j$1@hagen.cloud9.co.uk>

You'll find a file called init<Database_Name>.ora which on NT should be in c:\orant\database\ or similar on UNIX I think its in $ORACLE_HOME/dbs. The file may contain (amongst other things)

open_cursors = 400

which determines how many cursors you can have open at one time. Increasing the value (or creating an entry) should cure the problem. You will need to stop and start the database for the change to take effect.

bmolish_at_btsquared.com wrote in message <6vt114$21r$1_at_nnrp1.dejanews.com>...
>Our DBA had left and I need to go and correct this error.
>We are using 7.34 of Oracle on an HP UX box.
>
>One of the developers is experiencing the following error.
>ORA-01000 maximum open cursors exceeded
>
>What is the command to determine how many cursors are set?
>What is the max value?
>Do I need to set this up in the initxxx.ora file?
>
>Any help would be greatly appreciated.
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Oct 12 1998 - 10:27:41 CDT