The repository crash every now and then. In the Oracle trace file the following error occurs:
ORA-04030: out of process memory when trying to allocate bytes
The database run out of memory.
Add more memory to the machine and modify the boot.ini.
The machine has 2 GB memory and you add 2 additional GB. Now add /3gb flag in the boot.ini file, this will give the database 1 extra GB memory
Now monitor the Oracle process and check how much memory is used by Oracle.
If the problem still exists, increase the following Oracle parameters:
pga_aggregate_target = 200M
NOTE: Eventually you have to increase to a higher value then in the example above. Check the Oracle Documentation properly before you do the changes.