Home » RDBMS Server » Performance Tuning » How to determine the system memory usage by oracle processes (Solaris 10)
How to determine the system memory usage by oracle processes [message #558295] Wed, 20 June 2012 12:25 Go to next message
getzeeshan
Messages: 65
Registered: July 2008
Member
HI Friends ,

we have 96GB Memory on the UNIX server and 85% of its usage shows oracle processes I want to determine which Oracle processes are taking most of the memory

SGA is around 36G
SGA_TARGET is 40G
PGA is around 4G

the total of around 40-45 GB of usage is understandble but what otehr oracle process are chewing up the remaining 30-40 GB on the server is not known

Please can you help me on this


load averages:  7.35,  6.46,  6.15;                    up 248+11:33:21                                                             12:25:03
2202 processes: 2196 sleeping, 1 zombie, 5 on cpu
CPU states: 83.8% idle, 10.5% user,  5.8% kernel,  0.0% iowait,  0.0% swap
Memory: 96G phys mem, 15G free mem, 128G total swap, 128G free swap

   PID USERNAME LWP PRI NICE  SIZE   RES STATE    TIME    CPU COMMAND
 21720 oracle   258   0    0   40G   40G cpu/48 215:28  2.04% oracle
 10709 oracle     1   0    2 1816K 1448K cpu/9    0:02  0.90% res_conf_email_
 25405 oracle     1  52    0   40G   40G sleep  201:47  0.56% oracle
   457 oracle    11  43    0   40G   40G sleep    1:49  0.46% oracle
 20164 oracle    46  60    0   40G   40G sleep   68.5H  0.37% oracle
 28233 oracle    11  59    0   40G   40G sleep    0:22  0.24% oracle
 23677 oracle    11  53    0   40G   40G sleep    2:19  0.18% oracle
  5236 oracle     1  59    0   40G   40G sleep    0:01  0.18% oracle
 25411 oracle    11  60    0   40G   40G sleep   88:02  0.16% oracle
 10215 oracle     1  53    0   40G   40G sleep    0:01  0.14% oracle
  3416 oracle     1  59    0   40G   40G sleep   14:27  0.14% oracle
 29086 oracle     1  59    0   40G   40G cpu/31   0:05  0.13% oracle
 16123 oracle     1  54    0   40G   40G sleep    0:14  0.13% oracle
 29323 oracle     1  51    0   40G   40G sleep    0:28  0.11% oracle
 21170 oracle     3  59    0   63M   48M sleep   59.3H  0.11% tnslsnr



Regards
Zee
Re: How to determine the system memory usage by oracle processes [message #558298 is a reply to message #558295] Wed, 20 June 2012 12:42 Go to previous messageGo to next message
BlackSwan
Messages: 22911
Registered: January 2009
Senior Member
>I want to determine which Oracle processes are taking most of the memory

When you start with the wrong question, no matter how good an answer you get, it won't matter very much.

if the system is not SWAPPING on a regular basis, then RAM is not a bottleneck
& you should concentrate tuning efforts to other areas


Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: How to determine the system memory usage by oracle processes [message #558313 is a reply to message #558298] Wed, 20 June 2012 15:01 Go to previous messageGo to next message
getzeeshan
Messages: 65
Registered: July 2008
Member
You are right .. I already did check all other forums and google

my Question here is out of total 95GB of memory on Unix server the average Memory usage is around 85GB by Oracle Processes want to know which are the processes that are chewing up such big memory chunks?

I dont know which are those oracle proceses? I want to know the specific oracle proceses and their respective memory usage?

for ex
Oracle Process Memory
XXXXX xxMB
YYYYY xxMB

hope this questions is sensible enough

--Zee
Re: How to determine the system memory usage by oracle processes [message #558315 is a reply to message #558313] Wed, 20 June 2012 15:08 Go to previous messageGo to next message
BlackSwan
Messages: 22911
Registered: January 2009
Senior Member
>hope this questions is sensible enough
While the question seems reasonable & straightforward, in actuality it can not be easily answered
& even if you obtained such details there is little you could do with them.

Given the nature of Oracle's implementation the whole SGA is mapped into every clients' process.
Therefore is you sum up the "size" of each client's process; the TOTAL exceeds RAM many times over.

I'll say it again, again.
You are asking the wrong question.
When the OS system is not swapping,
then RAM is not the bottleneck & you should stop looking for a problem that does not exist.
Re: How to determine the system memory usage by oracle processes [message #558316 is a reply to message #558315] Wed, 20 June 2012 15:12 Go to previous messageGo to next message
getzeeshan
Messages: 65
Registered: July 2008
Member
then how do we tune the OS to use the SWAP space?

--Zee
Re: How to determine the system memory usage by oracle processes [message #558317 is a reply to message #558316] Wed, 20 June 2012 15:14 Go to previous messageGo to next message
BlackSwan
Messages: 22911
Registered: January 2009
Senior Member
>then how do we tune the OS to use the SWAP space?
When RAM is sufficient, little or no SWAP space will ever be consumed; which is a Good Thing!
Re: How to determine the system memory usage by oracle processes [message #558318 is a reply to message #558317] Wed, 20 June 2012 15:26 Go to previous message
getzeeshan
Messages: 65
Registered: July 2008
Member
Thanks!
Previous Topic: Oracle (HP-UX) connection very slow from Windows client
Next Topic: Reg Awrrpt report in oracle database
Goto Forum:
  


Current Time: Sat Oct 25 11:19:30 CDT 2014

Total time taken to generate the page: 0.12847 seconds