ORA-04030: out of process memory when trying to allocate 4032 bytes (qmxdGetChildNo,qmemNextBuf:alloc)

Getting ORA 04030 when we insert XML files into the database.

Error:

Errors in trace file

/u01/app/oracle/diag/rdbms/SIDPROD/SIDPROD2/trace/SIDPROD2_ora_4085.trc  (incident=528493):
ORA-04030: out of process memory when trying to allocate 4032 bytes (qmxdGetChildNo,qmemNextBuf:alloc)
Incident details in: /u01/app/oracle/diag/rdbms/SIDPROD/SIDPROD2/incident/incdir_528493/SIDPROD2_ora_4085_i528493.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Mon Aug 31 10:05:27 2015

Solution:

Try insertXML after flusing the shared pool.

SQL> alter system flush SHARED_POOL;

System altered.

SQL>

For permanent solution you can refer Note:1667557.1