Is this on Oracle 10.2.0.4? Looking at the Oracle support site there's a memory leak using some of the XML functions that can be fixed by upgrading to 10.2.0.5, 11.2, or by using 10.2.0.4 Patch 2 in Windows 32-bit.
-----Original Message----- From: Neil Chaudhuri [mailto:nchaudh...@potomacfusion.com] Sent: Tuesday, March 23, 2010 3:21 PM To: 'solr-user@lucene.apache.org' Subject: Out of Memory I am using the DataImportHandler to index literally millions of documents in an Oracle database. Not surprisingly, I got the following after a few hours: java.sql.SQLException: ORA-04030: out of process memory when trying to allocate 4032 bytes (kolaGetRfcHeap,kghsseg: kolaslCreateCtx) Has anyone come across this? What are the ways around this, if any? Thanks.