Tuesday 6 September 2016

ORA-04030: out of process memory when trying to allocate 4088 bytes while ADOP in 12.2.3

ORA-04030: out of process memory when trying to allocate 4088 bytes while ADOP in 12.2.3


Solution:

·        Restart of the adworker fixed the issue
·        Recommendation if persist:

Try one of the following workarounds :

 Change the page count to 200k at the OS level:
 $ more /proc/sys/vm/max_map_count
 $ sysctl -w vm.max_map_count=200000

 -or-

 Adjust the realfree heap pagesize within the database by
 setting the following parameters in the init/spfile and restart the database.
 _use_realfree_heap=TRUE
 _realfree_heap_pagesize_hint = 262144

Then try restarting the worker