Sat Jun 11 17:33:26 2005
Errors in file /dbhomeams/ams/admin/amsora/bdump/amsora_ckpt_10317.trc:
ORA-04030: out of process memory when trying to allocate 33352 bytes (pga heap,ksm stack)
Sat Jun 11 17:33:26 2005
Errors in file /dbhomeams/ams/admin/amsora/bdump/amsora_ckpt_10317.trc:
ORA-04030: out of process memory when trying to allocate 33352 bytes (pga heap,ksm stack)
Sat Jun 11 17:33:26 2005
CKPT: terminating instance due to error 4030
Instance terminated by CKPT, pid = 10317
What does an ORA-4030 mean?
---------------------------
This error indicates that the oracle server process is unable to allocate more memory from the operating system.This memory consists of the PGA (Program Global Area) and its contents depend upon the server configuration.For dedicated server processes it contains the stack and the UGA (User Global Area) which holds user session data, cursor information and the sort area. In a multithreaded configuration (shared server), the UGA is allocated in the SGA (System Global Area) and will not be responsible for ORA-4030 errors. The ORA-4030 thus indicates the process needs more memory (stack UGA or PGA) to perform its job.
What causes this error?
-----------------------
Since you run into this error, you can't allocate memory from the operating system. This could be caused by your process itself, like your process is just requesting too much memory, or some other reasons cause the operating system memory to be depleted, like a too big SGA or too many processes to be accomadated for the systems virtual memory (physical memory + swap space). Many operating systems impose limits on the amout of memory a single process can acquire to protect itself.
