Is This Content Helpful?
We're glad to know this article was helpful.
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".
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.
To work around the Oracle error, first install the Oracle patch to address the bug below.
RDBMS: GETTING ORA-4031 EVEN AFTER FIX FOR BUG 8537544
Refer to Oracle’s Metalink for additional information on the Oracle patch.