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 "[email protected]_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:>