ORA-04030: out of process memory when trying to allocate bytes (,)

 ORA-04030: out of process memory when trying to allocate  bytes (,)

In logs, We you see below error

>Instance terminated by CKPT, pid = 6172 with below errors in alert log . Other errors are found in log files are also listed below

1) ORA-04030: out of process memory when trying to allocate 4096 bytes (PLS non-lib hp,pdzdM80_Allocate_Block)
2) ORA-04030: out of process memory when trying to allocate 8148 bytes (kxs-heap-w,qesaQBInit:buffer)
3) ORA-04030: out of process memory when trying to allocate 16408 bytes (session heap,kxsFrame16kPage)
4) ORA-27300: OS system dependent operation:CreateThread failed with status: 8
5) ORA-27301: OS failure message: Not enough storage is available to process this command.
6) ORA-04030: out of process memory when trying to allocate  bytes (,)

Cause :- This may occurs if system is not having the enough memory to handle new jobs. In our case, system lacked the necessary resources to create another process. In Event logs, You can also see that system was unable to begin another thread.

Action :- Please check the virtual memory(Swap Memory) of the OS and set virtual memory to recommended memory or near to the value. You need outage to change this value as you have to  restart the DB server after changing this value.

No comments:

Post a Comment

Really Thanks