Maximum open cursors exceeded

Question

We're seeing an oracle error in a  data center deployment with a small user base. Has anyone run into this? Is there any recommendation for the # of cursors per concurrent user that we can use as a guide so as to not just blindly increase the max limit?

ORA01000: maximum open cursors exceeded

Kumaran · Answer

Can this be related to the JDBC driver ? https://community.oracle.com/thread/3682300

Kumaran · Answer

We have tried increasing the number of cursors and we are still facing the issue. Is this a bug in JIRA with Oracle ?

Pepe · Answer

thanks, that's the current plan. I was hoping to gain some insight into how many to expect (ideally per concurrent user) or some design criteria to predict an optimal amount. I have recommended that we monitor their usage and increase to the smallest max we can get away with.