Error " 030~ORA-04030: out of process memory when trying to allocate 16776728 bytes (QERHJ hash-joi,QERHJ Hash Table Entries)~" Increasing ulimits for the job owner did not help.

Document ID : KB000053696
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

Job fails with error " 030~ORA-04030: out of process memory when trying to allocate 16776728 bytes (QERHJ hash-joi,QERHJ Hash Table Entries)~" Increasing ulimits for the job owner did not help. Running the job under AutoSys fails while running the job directly under Unix works fine.

Solution

This is working as designed. The job is launched by auto_remote which is started by inetd. inetd is owned by root and consequently the root user's ulimit setting and environment variables are taken. There are several possible solutions: Either increase ulimits for root or add the ulimit setting in /etc/auto.profile: ulimit -m 121634816 The second solution helps to set the ulimits dynamically.