RE: Oracle Heap memory usage by listener

  • From: "Dimensional DBA" <dimensional.dba@xxxxxxxxxxx>
  • To: <Balwanth.Bobilli@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 10 Feb 2016 19:36:35 -0800

You might try VMMap.

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@xxxxxxxxxxx> Dimensional.dba@xxxxxxxxxxx

 <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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Balwanth Bobilli
Sent: Wednesday, February 10, 2016 7:26 PM
To: oracle-l@xxxxxxxxxxxxx
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

 

Other related posts: