English

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

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.

    Related Information