-
Title
Repository crash with error: "ORA-04030: out of process memory when trying to allocate bytes" -
Description
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 -
Cause
The database run out of memory.
-
Resolution
Add more memory to the machine and modify the boot.ini.
For example:
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
workarea_size_policy
sga_max_size
pga_aggregate_target
For example:
pga_aggregate_target = 200M
workarea_size_policy=auto
sga_max_size=200M
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.