Oracle DB Error ORA-01000 maximum open cursors exceeded

Oracle DB Error ORA-01000 maximum open cursors exceeded

The following in the cause of this error:

A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user.

Action you can take to resolve this issue: Modify the program to use fewer cursors. If this error occurs often, shut down Oracle DB Error ORAcle, increase the value of OPEN_CURSORS, and then restart Oracle DB Error ORAcle.


Tags: Database, Education, Software




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution