Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    ORA-01000: maximum open cursors exceeded

    • 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
    • Was this article helpful?