Maximum open cursors exceeded

[Pepe]

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

[Rodrigo Rosa]

Hello Christopher,

Referring to this thread, try increasing the number of cursors on the database and see if you still face the problem.

[Pepe]

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.

[Kumaran]

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

[Kumaran]

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