Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. ORA-01000: maximum open cursors exceeded

    ORA-01000: maximum open cursors exceeded

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    You see this message in your pc_server (or www_server) log:

    ORA-01000: maximum open cursors exceeded

    Note: in one case, this sequence of messages was seen:
    Oracle error: io_sequence_next
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01000: maximum
    Oracle error: io_z05_write
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01000: maximum
    Oracle error: io_z110_write
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01000: maximum

    Resolution:
    The ORA-01000 means "maximum open cursors exceeded". The open_cursors value is set in the Oracle initialization file (usually found at $ORACLE_CONF/initalephx.ora or such). It needs to be increased. You need to restart Oracle in order for the change to take effect..
    What should it be increased to? Each cursor occupies some small amount of memory (x). But if you specify 1000 and it is only using 100, the memory taken up will be only 100 * x.... We don't see any real downside to specifying a larger value. We suggest that small sites specify 300 and large sites, 1000. We will be distributing the file with this larger value in new installations.


    • Article last edited: 12/10/2014
    View article in the Exlibris Knowledge Center
    1. Back to top
      • ORA-00959: tablespace 'TS2X' does not exist
      • ORA-01007 (fetch z403)
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved