Re: How to handle this kind of exception
You are opening too much cursors: this is the problem.
Originally posted by harry_hurry
I wrote a jdbc file and call some cursors many times. At some special time, it will give an exception like this:
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
What does this mean? Do I need to close the cursor when I finished calling it? But How do I do close in the jdbc?
You have two solutions, or better a solution (1) and a workaround (2):
1) close the cursors you are not using (YOU CANNOT USE SO MUCH CURSORS) so that the cursors of your sessions are enough;
2) prepare the instance to treate the load you are putting on it,
open_cursors = 500
session_cached_cursors = 50
If it doesn't work try (1000, 100) and then (1500,150) and finally you MUST try solution (1) you have ignored so far :-))
9i OCP DBA, Performance Engineer