| open cursors [message #435942] |
Sat, 19 December 2009 05:20  |
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 #435948 is a reply to message #435942] |
Sat, 19 December 2009 10:41  |
 |
ramoradba
Messages: 2457
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 
[Updated on: Sat, 19 December 2009 10:58] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
