Home » RDBMS Server » Server Administration » ORA-01000: maximum open cursors exceeded error (10g)
ORA-01000: maximum open cursors exceeded error [message #390064] Wed, 04 March 2009 16:03 Go to next message
dksampat
Messages: 12
Registered: December 2006
Junior Member
Dear All,

We have a strange issue for a common error. We are running a PLSQL Package and we are hitting "ORA-01000: maximum open cursors exceeded error". When I checked the gv$open-cursor, I found that 90% of the open cursors has a sql termed "SELECT NULL FROM DUAL;"

Kindly please let us know how to move forward on this issue? Is this a cursor leak in the package or is there anything that needs to be set in the DB side?

Regards,
DK
Re: ORA-01000: maximum open cursors exceeded error [message #390068 is a reply to message #390064] Wed, 04 March 2009 16:37 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

I have seen similar from Java coders who would be challenged to be spell checkers at an M&M factory.

This is NOT an Oracle RDBMS problem, but an application problem.
Re: ORA-01000: maximum open cursors exceeded error [message #390096 is a reply to message #390064] Wed, 04 March 2009 23:17 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Most likely a dumb conversion from a Sybase... application to an Oracle one converting "begin transaction" to "select null from dual".
Review the code and remove all these statements.

Regards
Michel
Previous Topic: Space release after deleted database ffiles
Next Topic: Adding datafile in ASM
Goto Forum:
  


Current Time: Sun Dec 04 12:52:30 CST 2016

Total time taken to generate the page: 0.07184 seconds