Huge memory allocation

[Former Member]

Heloo guys,

I have the following system: Linux SLES 10 (x86_64) / Oracle 10.2.0.4.0 - RAC / SAP ECC 6.0 Kernel Patch 221

Memory in the system reported by the utility "top" is 39116504k.

Considering that the memory used by Oracle is determined by the formula 1 * SGA + sum (PGA) i have executed the following select: "select (sga+pga)/1024/1024 as "sga_pga" from (select sum(value) sga from v$sga),(select sum(PGA_ALLOC_MEM) pga from v$process)" and the result was : 15642.2719268799

About the memory occupied by SAP I looked at the parameter em/initial_size_MB = 8000. Where in transaction st02 to "SAP Memory" - "Extended Memory" I have

"In Mem[KB]"= 8.187.904,

"MaxUse[KB]" = 4.558.848,

"CurUse[KB]"= 2.768.896

So let's say that for SAP and Oracle i have 8000 MB + 15643 MB = 23643 MB

But utility top and utility free reports the same thing=>

Mem: total=39116504 used=38806160 free=310344

and Swap: total=20972848 used=601552 free=20371296

I looked on top in a sort after Memory Usage:

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND

20021 oraprd 16 0 14.9g 12g 12g D 8 34.4 206:37.97 oracle

19896 oraprd 16 0 14.6g 12g 12g S 14 33.7 226:08.87 oracle

19894 oraprd 16 0 14.4g 12g 12g D 3 33.4 265:10.75 oracle

......

And the list of processes that uses over 30% of memory is much longer.

Honestly, 30% from memory used (about 11.4 Gb / session) seems to me very much!

Consequently I took a look in transaction st04 "Session Monitor"and we have identified (by PID)

first session of the top , as a session with inactive status. We also identified the number of Workprocess and noticed that it does not run anything in transaction sm50. I checked in sm21 and st22, for an error that give me an idea, but nothing.

I also noticed that if I go to sm50 and give "Cancel with core" in the process, the process restarts and memory-level operating system is released.

So, I guess, I have a memory issue, ... but not sure.

Can help me someone to understand what is happening there and why this happens?

Can i ? and how to put a limit for memory allocation for process, then that process to restart automatically to release the memory?

Thanks a lot,

Best regards

[Former Member]

Hello,

I found the parameter sap rdisp / wp_auto_restart = 0. If I change parameter rdisp / wp_auto_restart to 2h to say, do you think would be able to solve this problem?

Regards