Login or Register to Ask a Question and Join Our Community


Solaris

Oracle memory usage on Solaris box

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems Solaris Oracle memory usage on Solaris box
# 22  
Old 10-01-2010
Could it be that there are Solaris zones on the machine? Or even an unfinished zone creation (no final reboot)?
# 23  
Old 10-01-2010
No its just one physical server, we are not using any LDOMS or other virtualization techniques
# 24  
Old 10-13-2010
Do you have any update on this issue?
# 25  
Old 12-01-2010
Hi radulov,

Sorry for the late reply. Thanks for your help. Was very much useful and I learnt quite a lot of Solaris commands.

The issue was not fixed but when the instance was restarted the java processes were cleared which did free up some memory, so users were not complaining but still there was a difference in actual memory used by Oracle database and the oracle memory usage that Solaris reported.
I was busy with some other work so thought I'll have a look at this one when I get spare time. Today I was looking at this server once again and I don't see any additional java processes running which is good.

This is the current memory usage:

SGA - 5G
Code:
POOL         SUM(BYTES)
------------ ----------
large pool     50331648
java pool     167772160
streams pool  201326592
shared pool  1795912720
             2113929168

PGA Usage - 8G
Code:
 select sum(value) from v$sesstat ss, v$statname sn where sn.statistic# = ss.statistic#  AND sn.name = 'session pga memory'
/   2

SUM(VALUE)
----------
8097824112

Clusterware Memory Usage - 850M
Code:
ps -eorss,args | nawk 'END { print s/1024, "MB" } /cluster/$1 }'
853.023 MB

Oracle listener memory usage - 69M
Code:
ps -eorss,args | nawk 'END { print s/1024, "MB" } /db_1/ { }'
69.0156 MB

Agent memory usage - 165M
Code:
ps -eorss,args | nawk 'END { print s/1024, "MB" } /agent10g $1 }'
164.414 MB

Free Memory - 1G appr
Code:
vmstat 5 5
 kthr      memory            page            disk          faults      cpu
 r b w   swap  free  re  mf pi po fr de sr m0 m1 m3 m4   in   sy   cs us sy id
 0 0 0 6919392 5236208 600 1949 1929291843905 575 567 0 4 2 0 0 0 7137 30982 6894 4 2 94
 0 0 0 4796696 1082888 368 1557 40607348150 27 27 0 0 0 0 0 0 8370 26135 8119 6 2 92
 0 1 0 4806656 1090088 342 1073 40 41 41 0 0 0 1  2  0 7976 18484 7493 6  2 92

swap usage
Code:
swap -s
total: 27390952k bytes allocated + 7552552k reserved = 34943504k used, 4792424k available

When I run prstat -a -s rss to see oracle user memory usage
Code:
 NPROC USERNAME  SWAP   RSS MEMORY      TIME  CPU
  4018 oracle     33G   25G    78% 354:40:07 6.9%
    68 root      296M  286M   0.9%  87:05:26 0.1%
     1 daemon   2632K 6376K   0.0%   6:35:27 0.0%
     1 smmsp    1352K 4968K   0.0%   0:00:22 0.0%

I know you said that this o/p might be wrong but still I am confused as the free memory is very slow and there is huge amount of swapping happening.

Using Oracle provided script(
How to Check the Host Memory Usage on Solaris via NMUPM Utility [ID 741004.1])
Code:
./nmupm_mem.sh
/reuters/oracle/product/10.2/db_1/bin/nmupm osLoad
Calulates average memory (interval 300 (s)) usage on Solaris using nmupm

Memory 33423360.000000 [kB] Freemem 1499683.86 [kB] %Free 4.00
Memory 33423360.000000 [kB] Freemem 1514275.89 [kB] %Free 4.00
Memory 33423360.000000 [kB] Freemem 1867766.98 [kB] %Free 5.00
Memory 33423360.000000 [kB] Freemem 1505032.69 [kB] %Free 4.00

sar -r
freemem freeswap
164676 10233251
pagesize
8192
So around 1.3G free memory reported.

So it seems like around 10G of memory has vanished. I am not able to trace this memory.

Any suggestions?
# 26  
Old 12-03-2010
I observe similar situations in out environment (Oracle/Solaris).
Often (especially with multiple concurrent connections) the memory
drill-down using standard Unix utilities doesn't seem to match
the physical memory of the servers.
# 27  
Old 12-08-2010
I have raised this with Oracle now .. Will update you when I get some information.
# 28  
Old 12-08-2010
Thanks!
I believe it's somehow related to the high connection count.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Solaris

How to find out the memory usage in Solaris?

Hi All, In one of the solaris box aslert got triggered as ... (Used_Real_Mem_Pct=93.0 Used_Swap_Space_Pct=75.0 )] when i see the usage by vmstat and sar i am not able to relate the alert with the free memory and swap memory please help to understand the vmstat output as below.. kthr ... (4 Replies)
Discussion started by: Riverstone
4 Replies

2. Solaris

Solaris memory usage

One of my Solaris Unix server has total RAM 128G . top & vmstat command shows free memory is 86G and usage is 42G. ps -eo pid,rss,commshows memory usage by process. when i sum all the memory usage by the process, it shows 1.9TB as shown below. $ ps -eo pid,pmem,vsz,rss,comm | sort -rnk2 |... (5 Replies)
Discussion started by: baladelaware73
5 Replies

3. Solaris

Solaris Memory usage by oracle, java

Hello Gurus, In Office, I have unix Solaris Server. Oracle and Java is installed on Solaris Server. Oracle when starts then oracle loads SGA, PGA memory and graps solaris server memory. In the same manner java and other applications grabs memory for them. I want memory distribution of... (4 Replies)
Discussion started by: get_chandrakant
4 Replies

4. Solaris

Memory usage in a Solaris Container

Hi All, We have a server with Solaris 10 installed. The total memory of the server is 64GB. In order to check the memory info of the server I use "top" utility that gives me total and free memory in real-time. I have also installed a Sun container (non-global zone) on top of parent operating... (4 Replies)
Discussion started by: Slayer
4 Replies

5. Solaris

Memory usage in Solaris - memory not freed?

Hi, I'm running a multi-process software system on a Solaris 8 machine. When I monitor the memory usage, I see that the free memory is dropping rapidly, but I can't detect a process that uses this memory. I'm using "top" to get the free memory and the memory usage of processes. Thanks. (3 Replies)
Discussion started by: gewurtz
3 Replies

6. HP-UX

how can I find cpu usage memory usage swap usage and logical volume usage

how can I find cpu usage memory usage swap usage and I want to know CPU usage above X% and contiue Y times and memory usage above X % and contiue Y times my final destination is monitor process logical volume usage above X % and number of Logical voluage above can I not to... (3 Replies)
Discussion started by: alert0919
3 Replies

7. UNIX for Dummies Questions & Answers

memory usage : kernel, oracle, other users

Hello, I'm looking for a command or script that could permit me to know what is memory usage group by HP-UX kernel, oracle processes and other users (specific software). A command like 'top' but for all processes and not only for 12 max could be very useful Thanks in advance (4 Replies)
Discussion started by: thierryUX
4 Replies

8. UNIX for Dummies Questions & Answers

Comman/Tool to check memory leak in solaris box

Hello Guys, Please let me know about commands or tools that are available to check memory leak in solaris box. Thanks in Advance (1 Reply)
Discussion started by: rajeshlbryan
1 Replies

9. Solaris

oracle process and LWP on solaris 8 box

Hi all, Without oracle tunning I understand that oracle processes always run on a single CPU at a time (the prstat output always show 1 CPU number) even on multi-processor hardware. Is it correct? Regards, (1 Reply)
Discussion started by: solea
1 Replies

10. Filesystems, Disks and Memory

Memory usage in the box

Hello: Environment is: Oracle 817 on IBM RS/6000 AIX 433 I have 4GB RAM on the box and Page/Swap is about the same. Presently I am using close to 1GB of RAM towards 5 instances of ORACLE production environments. How can I know, how much of memory/RAM is used for : Oracle Processes , I... (2 Replies)
Discussion started by: ST2000
2 Replies
Login or Register to Ask a Question