[sap-basis] Huge memory allocation
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by ora600 (mda) on Mar 5 at 6:26 AM |
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 MemKB"= 8.187.904,
"MaxUseKB" = 4.558.848,
"CurUseKB"= 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: total9116504 used8806160 free10344
and Swap: total 972848 used`1552 free 371296
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
__.____._ 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 MemKB"= 8.187.904,
"MaxUseKB" = 4.558.848,
"CurUseKB"= 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: total9116504 used8806160 free10344
and Swap: total 972848 used`1552 free 371296
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
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
