I am getting the error: ORA-04030 out of process memory when trying to allocate 12750 bytes (hash-join,subh,kllcqas,kllsltba)
when running a PLSQL script. any ideas? its on a fairly well specced machine - with 1GB ram allocated to the database instance, plus the machine has ample swap file (which i tried increasing and still got same error). Its oracle 9i r2.
the scritp is a fairly standard sort of thing - process a bunch of records from a table (theres about 500000+ records in the table) one by one.