Pages

Thursday, August 28, 2008

ORA-01000: Maximum open cursors exceeded

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

CauseOracle 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.