ora-1000 errors, "Maximum open cursors exceeded."

When ora-1000 errors, "Maximum open cursors exceeded." happens most Oracle DBAs think "damned java developers, close your statements!!!". Which is true in 99% of the cases. However sometimes there might be more to it than some statements left open by developers.

Natalka Roshak has an article called "Monitoring Open and Cached Cursors" that helps with some of the debugging pain. Additionally you may use the trace to get a snapshot of the offending cursors when ORA-1000 is thrown.

Enable the errorstack by using alter system or alter session:

alter system set events = '1000 trace name ERRORSTACK level 3'

alter session set events = '1000 trace name ERRORSTACK level 3'

disable by settin it back to off as in ....ERRORSTACK off'

Sphere: Related Content