Maximum open cursors exceeded

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

1 answer

1 vote

Hello Christopher,

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Product Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Maximum open cursors exceeded

1 answer

Suggest an answer

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events