Getting "out of process memory when trying to allocate" even after applying TEC535005

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

Problem:

Getting Oracle "out of process memory when trying to allocate" errors even after applying TEC535005

Cause:

Sometimes even after applying the Oracle tuning in TEC535005 you can still get Oracle "Out of processes memory when trying to allocate" errors causing failures in eHealth and/or eHealth jobs. 

Resolution:

Decrease the Oracle parameter parallel_max_server by 1/2.

sqlplus "sys@DB_CONNECT_STRING/ehealth as sysdba"

SQL> show parameter parallel_max_servers

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
parallel_max_servers                 integer     32

SQL> alter system set parallel_max_servers = 16 scope=both;

System altered.

SQL>quit

C:>