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.
Subscribe to:
Post Comments (Atom)
How can I remove a URL on my website from the Google Index?
To remove a specific URL (for example, the page http://www.example.com/page4.html) of your own website from Google’s index, there are two ...
No comments:
Post a Comment