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.
Refer to Oracle’s Metalink for additional information on the Oracle patch.