Thursday, August 28, 2008

ORA-01000: Maximum open cursors exceeded

Symptom:
The Oracle error:
ORA-01000: Maximum open cursors exceeded


Cause
Oracle indicates that this error is usually encountered in application programs, but could occur at the database level. I have only encountered it in application programs. The error indicates that Oracle has reached the set limit for open cursors allowed for the session.

Possible Remedies:
Identify if there is a bug in the application program meaning that some cursors do not get closed properly.
Increase the OPEN_CURSORS parameter in the Oracle initialisation file.

No comments:

Post a Comment