I got ” ORA-04030: out of process memory ” error in Oracle.
ORA-04030: out of process memory
Details of error are as follows.
ORA-04030: out of process memory when trying to allocate 82456 bytes (pga heap,control file i/o buffer) ORA-04030: out of process memory when trying to allocate 4064 bytes (PLS CGA hp,pdzdM80_Allocate_Block) ORA-04030: out of process memory when trying to allocate 248 bytes (kxs-heap-w,ctx:keswxCurPrepare)
out of process memory
This ORA-04030 errors are related with the insufficient RAM on a dedicated (non shared server) environment, a too small PGA, and by not setting kernel parameters large enough to allow enough RAM.
The ulimits of data stack and nofiles were not set to unlimited. Setting the ulimits of all the components to unlimted will resolve the ORA-04030 errors. The Server has plenty of physical memory and the SGA is set to the minimum values.
To solve this error, you should increase pga_aggregate_target and decrease sort_area_size and/or hash_area_size.
Or Change your server and Move to multi-threaded server.
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )