Oracle Heap memory usage by listener

From: Balwanth Bobilli <>
Date: Thu, 11 Feb 2016 03:26:14 +0000
Message-ID: <>

Oracle version :
Microsoft Windows server 2012
RAM: 1TB (680GB free memory while getting this error)

One of our customer wants to run 80 SIDS and 80 listeners (each listener for each database).. After all listeners are running, we are seeing TNS-12531: TNS: cannot allocate memory. From Doc ID 1384337.1( We got to know that changing third argument of \HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\SubSystems\: will help us, Increasing this third value and check whether TNS error disappears. There is no optimum value, it depends from one system to another.

However we are planning to increase it, I see that there is no optimum value for setting and maximum value is 8192.

Current value is

C:\Windows\system32\csrss.exe ObjectDirectory=\Windows SharedSection=1024,20480,2048 Windows=On SubSystemType=Windows ServerDll=basesrv,1 ServerDll=winsrv:UserServerDllInitialization,3 ServerDll=sxssrv,4 ProfileControl=Off MaxRequestThreads=16

We are planning to change it to 4096 Before proceeding further we want to know

  1. how SharedSection is used for non-interactive processes running as Local System? If we keep it 4096 will that impact the performance?
  2. Any tools to monitor heap memory usage (sysads here tried installing dheapmon and livekd, which is unable to do so on windows sever 2012)
  3. Is there any other solution to work around on this? Note: No traffic from application, just few connections. Shared server configuration
Received on Thu Feb 11 2016 - 04:26:14 CET

Original text of this message