Re: Nebie - ORA-01000maximum open cursors exceeded

To query the setting you can do a "SELECT VALUE FROM V$PARAMETER WHERE NAME='open_cursors';" (You can just as easily look in the INIT.ORA file. The maximum value is OS dependent (for NT it is unlimited, I don't know what it is for HP UX). Just realize that by increasing the max value, each process will require more memory. The first thing you may want to do is talk to the developer and see if there is a way to decrease the number of required cursors. To change the value, you must change the init.ora and restart the database.

Dave

bmolish_at_btsquared.com wrote:

> 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 - 11:19:44 CDT