Home » RDBMS Server » Enterprise Manager » open cursors (oracle 9i)
open cursors [message #435942] Sat, 19 December 2009 05:20 Go to next message
Messages: 2
Registered: March 2009
Location: NOIDA
Junior Member
We upgraded the databse from oracle 8i to 9i . changed init.ora,made open_cursors =3000.
but still we are getting problem of maximum open cursors while compiling any complex problem.

pls suggest what more setting we need to do.
Re: open cursors [message #435945 is a reply to message #435942] Sat, 19 December 2009 08:35 Go to previous messageGo to next message
Messages: 24277
Registered: January 2009
Senior Member
ERROR? What Error? I don't see any error


You need to help us by following the Posting Guidelines as stated below.
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

[Updated on: Sat, 19 December 2009 08:54]

Report message to a moderator

Re: open cursors [message #435948 is a reply to message #435942] Sat, 19 December 2009 10:41 Go to previous message
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
May be this.....

ORA-01000: maximum open cursors exceeded 
Cause: A host language program attempted to open too many cursors.
The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user. 
Action: Modify the program to use fewer cursors.
 If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and then restart Oracle.  

while compiling any complex problem.


More importantly did you restart the DB ?(bounce the database) after changing this parameter (open_cursors )

sriram Smile

[Updated on: Sat, 19 December 2009 10:58]

Report message to a moderator

Previous Topic: Oracle Options
Next Topic: problem in EM...
Goto Forum:

Current Time: Tue Dec 01 12:42:23 CST 2015

Total time taken to generate the page: 0.20489 seconds