troubleshooting Question

Max Open Cursors in Oracle SQL developer.

Avatar of janoxley
janoxleyFlag for United Kingdom of Great Britain and Northern Ireland asked on
Oracle Database
9 Comments1 Solution2735 ViewsLast Modified:
     I've been using Oracle SQL developer for about 5 months, i'm new to oracle so there is probably a thousand things i'm doing wrong however one thing that is a constant pain is getting the "Maximum Open Cursors Exceeded" error message.

   I get this error when i've been in a session for a while and have been opening tables, switching between views etc (basically just using the thing)

  I have to then end the application and reopen it which, when you're in the middle of something is a huge pain.

  So, my question.

  What IS all this max open cursors stuff?
  Why does it happen?
  How can i stop  it happening?

  As i said, i'm new to all this oracle stuff and am trying to be extra diplomatic with the DBAs so as not to annoy them too much so i don't really want to be constantly asking them questions (hence coming here!)

Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros