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

Article Id: 35713

Status: Published

Updated On: 14-02-2018 08:20

Legacy Id: TEC1989758

Products:

EHEALTH - MISC , CA eHealth Performance Management - Data Polling , CA eHealth Performance Management - Usage and Administration , DEVELOPER PROG , REMOTE POLLER

Issue/Introduction:

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:>

Environment:

Release: LHDEVC99000-6.3-eHealth-Live Health Upgrade Elements
Component: