RE: Oracle Heap memory usage by listener

https://technet.microsoft.com/en-us/sysinternals/dd535533.aspx    

Matthew Parker

Chief Technologist

Dimensional DBA

425-891-7934 (cell)

D&B 047931344

CAGE 7J5S7
<mailto:Dimensional.dba_at_comcast.net> Dimensional.dba_at_comcast.net

<http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew
Parker's profile on LinkedIn

<http://www.dimensionaldba.com> www.dimensionaldba.com
   

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Balwanth Bobilli
Sent: Wednesday, February 10, 2016 7:26 PM To: oracle-l_at_freelists.org
Subject: Oracle Heap memory usage by listener  

Oracle version : 12.1.0.2.0

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(https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=42 2793106930444
<https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=42279310693 0444&id=1384337.1&_afrWindowMode=0&_adf.ctrl-state=qi0lglvuc_210> &id=1384337.1&_afrWindowMode=0&_adf.ctrl-state=qi0lglvuc_210)

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  

--
http://www.freelists.org/webpage/oracle-l