BUG

Encountering Oracle error ora-4030 when creating a spatial index in Oracle

Last Published: April 25, 2020

Description

When creating a spatial index on an st_geometry attribute for a table containing millions of rows, the following Oracle error may be returned:

"ORA-04030: out of process memory when trying to allocate NN bytes".

Cause

The implementation of the spatial index method 'ODCIIndexCrate' uses two Oracle PL/SQL structures: the BULK COLLECT option while array fetching from a cursor, and the FORALL INSERT clause to array an insert into a table. Both of these PL/SQL programming structures have known Oracle memory leaks that can lead to the Oracle error: ORA-04030.

Workaround

To work around the Oracle error, first install the Oracle patch to address the bug below.

Bug:8934457
RDBMS: GETTING ORA-4031 EVEN AFTER FIX FOR BUG 8537544

Note:
Refer to Oracle’s Metalink for additional information on the Oracle patch.


Even after applying the Oracle patch, there are still cases that are based on the size of the table (number of rows), where the Oracle error is encountered when creating the spatial index. If the error is returned under these conditions, please contact ESRI Support Services for further assistance.

    Article ID: 000010816

    Software:
    • Legacy Products

    Receive notifications and find solutions for new or common issues

    Get summarized answers and video solutions from our new AI chatbot.

    Download the Esri Support App

    Related Information

    Discover more on this topic

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options