ORA-01000: maximum open cursors exceeded

Last Published: April 25, 2020

Error Message

After using ArcMap to pan, zoom, and redraw for some time on a layer that has been defined using Oracle Spatial, ArcMap may return the following error:

"ORA-01000: maximum open cursors exceeded".


The Oracle initialization parameter OPEN_CURSORS determines the maximum number of cursors per user, and this has been exceeded.

There is a known issue where, if the Oracle Spatial layer has an SRID defined, ArcSDE does not release the cursor on a query to determine the SRID of the layer.

Solution or Workaround

If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and restart Oracle.

This has been resolved in ArcSDE 8.3.

    Article ID:000005807

    • Legacy Products

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic