Oracle Process Memory calculation


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Oracle Process Memory calculation
# 1  
Old 03-15-2010
Java Oracle Process Memory calculation

Hello,

I am using Rehat Oracle Enterprise server.

Every time almost 150 process running on my server.
#ps -ef | grep oracle | wc -l

Now i want to calculate how much memory spend by each process or all process together.

Last edited by telnor; 03-15-2010 at 09:29 AM..
# 2  
Old 03-15-2010
Ok. You may have a bad assumption. Those processes being run as the oracle user are working on shared memory to a large extent. That means if you add up 150 processes' memory usage it well be greater than virtual memory - because those processes are accessing the same SGA -- for example.

You can get very exact information about each process using the /proc filesystem:
The proc File System

But. The shared memory caveat still applies.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Solaris

Physical memory calculation

Below is Physical Memory result : -bash-3.00$ prtconf | grep "Memory size" Memory size: 36854 Megabytes -bash-3.00$ vmstat 1 2 | tail -1 0 0 0 28220616 1318888 15 143 0 0 0 0 0 253 2 15 0 5215 14989 5917 7 0 93 and the script i have to calculate this in Percentage is : #!/bin/sh... (3 Replies)
Discussion started by: mjoshi010207
3 Replies

2. AIX

Regarding AIX Memory Utilization usage calculation

Hello, Am working on small program that used to calculate the memory usage of AIX servers. Am using svmon -G command to get the memory usage. For example, consider the following output. $ svmon -G size inuse free pin virtual mmode memory ... (9 Replies)
Discussion started by: maruthu
9 Replies

3. Solaris

[DOUBT] Memory high in idle process on Solaris 10 (Memory Utilization > 90%)

Hi Experts, Our servers running Solaris 10 with SAP Application. The memory utilization always >90%, but the process on SAP is too less even nothing. Why memory utilization on solaris always looks high? I have statement about memory on solaris, is this true: Memory in solaris is used for... (4 Replies)
Discussion started by: edydsuranta
4 Replies

4. Emergency UNIX and Linux Support

CPU and memory utilization of a process, by process name

Can someone please help me with a script that will help in identifying the CPU & memory usage by a process name, rather than a process id.This is to primarily analyze the consumption of resources, for performance tweaking. G (4 Replies)
Discussion started by: ggayathri
4 Replies

5. Solaris

shared memory in solaris 10 with oracle

Hi, I am a newbie to solaris and i have some questions on shared memory, Oracle in Solaris My Questions might seem different, however please do read and try to answer. Thanks in advance. 1) if a solaris server has say 40gb of Ram, what would be the maximum size of a shared memory segment in... (1 Reply)
Discussion started by: kris123456@gmai
1 Replies

6. UNIX for Advanced & Expert Users

Oracle how many memory allocate really

hi... i want to find oracle allocate how many memory really.. i execute this code to list memory on unix system : ps -eo pmem,args | sort -k 1 -r -n outputs ; %mem command 12.9|ora_smon_RTX 12.9|ora_s000_RTX 12.9|ora_reco_RTX 12.9|ora_qmnc_RTX... (2 Replies)
Discussion started by: utoptas
2 Replies

7. Shell Programming and Scripting

Memory Calculation

Hi, I want an script that calculate total memory consume by all Oracle Process 6689 oraprod 16 0 1163m 155m 150m S 0 2.0 0:01.95 oracle 7046 oraprod 16 0 1161m 18m 14m S 0 0.2 0:00.02 oracle 7392 oraprod 16 0 1165m 39m 33m S 0 0.5 0:00.07 oracle 7394 oraprod 16 0 1161m 22m 18m S... (1 Reply)
Discussion started by: telnor
1 Replies

8. UNIX and Linux Applications

Oracle's PGA memory Utilization

Hello all, I'm running Oracle 10g on Linux (RHEL5). The box has 66G of RAM with 2 databases running on it with 4 quadcore CPUs. I was monitoring the memory usage on the box and found something wierd. First, I executed the following query from the database to find out the PGA usage which looked... (2 Replies)
Discussion started by: luft
2 Replies

9. Red Hat

shared memory and oracle

hi all, I have 32G of memory on my box. Am I right in assuming that the shared memory comes from this 32G of RAM? if so, how can I find out how much of my 32G RAM is being used by shared memory and how much by processes. thanks (1 Reply)
Discussion started by: JamesByars
1 Replies

10. Linux

memory calculation

hi all, sorry for silly question. but i have a doubt in calculation of memory utilization calculation. using 'free' command we calculate the memory utilization as used/total. but my friend said that its wrong and we have to include cached also as (used-cached)/memory. but these... (0 Replies)
Discussion started by: rrlog
0 Replies
Login or Register to Ask a Question