Memory tunning

[Former Member]

Hello,

we have a Netweaver PI 7.11 SP14 SO Unix 6.1 Oracle 11.2.0.4

The actual hardware is an IBMpower7 and it has 32GB of Ram

When we run the unix command TOPAS, i see that RAM ocupped is always 93% (% Comp     93)

My question is how much memory i need to add to the hardware, and then,  if i have to make any change in some memory parameter.

Thanks

PD: Actually I did not see any problem from ST02 or st06

[Former Member]

hello all...

using Unix command "ps" I get this result:

In colum SZ (in Bold) the memory (KB) per process

ps aux | head -1 ; ps aux | sort -rn +3 | head -20

USER PID %CPU %MEM   SZ  RSS    TTY STAT    STIME  TIME COMMAND

pipadm 17956926  0.6  2.0 771836 555104      - A      May 17 2280:21 /usr/sap/PIP/D

pipadm 15204426  0.5  2.0 694560 499648      - A      May 17 2155:05 /usr/sap/PIP/D

pipadm 12910828  0.5  2.0 694524 517612      - A      May 17 2173:29 /usr/sap/PIP/D

pipadm 13959338  0.0  1.0 160328 159668      - A      May 17 192:30 dw.sapPIP_DVEB

pipadm 13893800  0.0  1.0 158048 163396      - A      May 17 176:30 dw.sapPIP_DVEB

pipadm 13697186  0.0  1.0 150984 155836      - A      May 17 138:28 dw.sapPIP_DVEB

pipadm 13631648  0.0  1.0 152780 157400      - A      May 17 177:48 dw.sapPIP_DVEB

pipadm 13435034  0.0  1.0 159416 163312      - A      May 17 189:34 dw.sapPIP_DVEB

pipadm 13369496  0.0  1.0 157792 160540      - A      May 17 194:50 dw.sapPIP_DVEB

pipadm 13303958  0.0  1.0 158352 165616      - A      May 17 196:11 dw.sapPIP_DVEB

pipadm 13238420  0.0  1.0 154228 158540      - A      May 17 194:20 dw.sapPIP_DVEB

pipadm 12779750  0.0  1.0 156932 162096      - A      May 17 185:24 dw.sapPIP_DVEB

pipadm 12517554  0.0  1.0 157420 162336      - A      May 17 191:17 dw.sapPIP_DVEB

pipadm 12320956  0.0  1.0 156876 159064      - A      May 17 193:13 dw.sapPIP_DVEB

pipadm 11862164  0.0  1.0 160840 162992      - A      May 17 176:36 dw.sapPIP_DVEB

pipadm 11730972  0.0  1.0 151668 155900      - A      May 17 187:52 dw.sapPIP_DVEB

pipadm 11468958  0.0  1.0 156576 157480      - A      May 17 175:25 dw.sapPIP_DVEB

pipadm 10813598  0.0  1.0 155212 157628      - A      May 17 185:31 dw.sapPIP_DVEB

pipadm 10420238  0.0  1.0 152692 158340      - A      May 17 177:05 dw.sapPIP_DVEB

pipadm 10354904  0.0  1.0 150684 155924      - A      May 17 175:07 dw.sapPIP_DVEB

As you see, the mayor consuming of memory are sap process... my issue is about 94% memory is used of 32 GB in total.

Also, in other hand, we have the EWA report. Not issues are reported with CPU or Memory

Thanks

[divyanshu_srivastava3]

Take thread dump of server node and see what all Java threads are causing performance issues.

for Abap, map the pid consuming more resource with the one you see in sm66 and sm50 to see what those reports or jobs consuming CPUs n memor.

if required, also monitor the usage from wily and take heap dumps to see possible memory leaks and consumers.

there is a lot that can be done.. The point here is, are you really facin any performance issues.

regards,

[Former Member]

Hello,

yes, the problem is the value of Phisical Memory is 98% used, Used by:  oracle 40% and SAP process other 50%

I see a lots off oracle process like :

/> ps -ef |grep LOCAL=NO

  orapip  6488146        1   0 17:02:20      -  0:00 oraclePIP (LOCAL=NO)

  orapip  8650986        1   0   May 17      - 54:14 oraclePIP (LOCAL=NO)

  orapip 10747932        1   0 14:14:20      -  0:06 oraclePIP (LOCAL=NO)

.....

more like these... nearly about  50

but i think that is normal....¿?

Thanks

[Former Member]

Per se high memory consumption/usage/allocation is not a problem. Yes you may have the problems in future or with high workload requirements. The EWA report is another proof of that you have no problems with memory. If you want to have more free memory available you need to perform memory consumption monitoring/tuning for oracle database and/or SAP instances. For over allocated memory regions you can decrease relevant parameters to free unused memory.

[isaias_freitas]

Based on the ST02 screenshot, SAP should not be using much more than 5GB - 6GB.

What else do you have running on this server? The database?

I believe that the first question would be what is using all the memory.

Regards,

Isaías

[Former Member]

Hello

yes oracle 11.2.0.4, is in the same server. Nothing more.

How can i see which process are consuming memory?

EWA report? other tools?

[Former Member]

Gabriel Silvestri wrote:

How can i see which process are consuming memory?

You can use any unix tool you are familiar with. For rough estimate you can use ps, for more detailed investigation svmon. But the main question is another. What is your goals? What do you want to achieve? Do you have any performance issues? Or from your point of view the only problem is 93%Comp pages used?

[divyanshu_srivastava3]

Are you facing any memory related issues, logs, dumps etc ?

If not, then have you checked EWA for your system ?

If all is fine, you can forget about this freeware 'TOPAS' for now and do a sizing of you system with current load and reports.

Regardsm

[Former Member]

Hello Divyanshu

thanks for you reply. What reports do you means?

[divyanshu_srivastava3]

Reports is a generic word for sources of information about your apps databases and operating system.

Regards,