Home » RDBMS Server » Enterprise Manager » open cursors (oracle 9i)
open cursors [message #435942] Sat, 19 December 2009 05:20 Go to next message
daisykakkar
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
BlackSwan
Messages: 22911
Registered: January 2009
Senior Member
ERROR? What Error? I don't see any error

http://www.orafaq.com/node/758
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:685336504294

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
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
ramoradba
Messages: 2453
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.  


Quote:
while compiling any complex problem.


http://forums.oracle.com/forums/thread.jspa?threadID=574858&tstart=0

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: Sat Oct 25 08:32:08 CDT 2014

Total time taken to generate the page: 0.04430 seconds