Monday, April 6, 2009

ORA 27102 - out of memory

Problem:
ORA 27102 - out of memory

Resolution:
It seems you are in Unix/Linux environment. In this case the SWAP partition of your computer should be 3 times the RAM or if the RAM is 1GB the swap can be 2GB.
If you are in Windows you have to provide also TEMP environment variable and ensure enough disk space for swapping.

Check your physical memory:

In Windows:
go through TASK manager->performance

in UNIX:

$ sysdef grep mem
$sysdef grep swap

in Linux:

$ cat /proc/meminfo

No comments: