100% memory usage in prstat


 
Thread Tools Search this Thread
Operating Systems Solaris 100% memory usage in prstat
# 1  
Old 11-03-2009
100% memory usage in prstat

Hi Guys,

I have observed the Oracle (DB USER) is utilizing 100% of the memory in the prstat -a output. I am bit confused is it normal and if not how to bring it down? ABout the machine it is a SunOS 5.10 Generic_125100-10 sun4v sparc SUNW,Sun-Fire-T200.

Please see below output of prstat -a
I have made bold the utilization...



Code:
bash-3.00# prstat -a
   PID USERNAME  SIZE   RSS STATE  PRI NICE      TIME  CPU PROCESS/NLWP       
 26879 sogadm    517M  416M sleep   59    0  74:17:12 5.7% java/50
 29064 sogadm    278M  176M sleep   59    0  22:58:58 1.2% java/117
 11385 sogadm     53M   40M sleep   59    0   3:19:10 0.3% FDSServer/101
  1471 root     8752K 8752K cpu1    39    0   0:00:03 0.2% prstat/1
   228 root     7192K 4088K sleep   59    0   1:53:48 0.1% nscd/28
  5956 emadba     44M   25M sleep   59  -20   1:21:04 0.1% ocssd.bin/15
 21113 sogadm    220M  121M cpu0    59    0   0:37:36 0.1% PluginContainer/214
 11387 sogadm     52M   38M sleep   59    0   0:45:20 0.1% FDSServer/77
  2383 root     1464K  768K sleep   50    0   0:43:41 0.0% init.cssd/1
 11688 emadba   1160M  907M sleep   59    0   0:38:00 0.0% oracle/1
  5691 root       70M   55M sleep   59    0   1:01:34 0.0% crsd.bin/45
 22319 sogadm    568M  544M sleep   59    0   0:23:20 0.0% PluginContainer/181
  5794 emadba     36M   18M sleep   59    0   0:37:22 0.0% oclsomon.bin/1
  8924 emadba   1160M 1107M sleep   59    0   0:29:25 0.0% oracle/1
 11682 emadba   1153M  903M sleep   59    0   0:28:41 0.0% oracle/1
     1 root     2504K  696K sleep   59    0   0:25:51 0.0% init/1
 11808 emadba   1152M  902M sleep   59    0   0:30:46 0.0% oracle/1
 11737 emadba   1162M  902M sleep  100    -   0:22:48 0.0% oracle/1
 11729 emadba   1162M  902M sleep  100    -   0:22:55 0.0% oracle/1
 11725 emadba   1162M  902M sleep  100    -   0:22:51 0.0% oracle/1
 11733 emadba   1162M  902M sleep  100    -   0:22:47 0.0% oracle/1
  8961 emadba   1162M 1102M sleep  100    -   0:23:28 0.0% oracle/1
  8974 emadba   1162M 1102M sleep  100    -   0:23:25 0.0% oracle/1
  8970 emadba   1162M 1102M sleep  100    -   0:23:23 0.0% oracle/1
  8995 emadba   1162M 1102M sleep  100    -   0:23:21 0.0% oracle/1
 29517 sogadm     55M   37M sleep   59    0   0:20:08 0.0% PluginContainer/99
 28556 sogadm    281M  126M sleep   59    0   0:21:17 0.0% java/58
 24721 sogadm     46M   24M sleep   59    0   0:20:14 0.0% PluginContainer/93
  2228 root       35M 2104K sleep  100    -   0:41:18 0.0% rpc.pmfd/79
 13099 sogadm     83M   57M sleep   59    0   0:16:22 0.0% PluginContainer/333
 NPROC USERNAME  SIZE   RSS MEMORY      TIME  CPU                             
    46 sogadm   3427M 2107M   0.2% 107:28:27 7.7%
  1208 emadba   1326G 1062G   100%  12:03:42 0.6%
    80 root      778M  220M   0.0%   5:49:12 0.5%
     1 batchadm   15M  976K   0.0%   0:04:20 0.0%
     1 noaccess  163M   66M   0.0%   0:05:58 0.0%
     3 spmadmin   61M    0K   0.0%   0:00:00 0.0%
     1 smmsp    7392K 1496K   0.0%   0:00:01 0.0%
     4 daemon     12M 2664K   0.0%   0:00:04 0.0%




Thx.

Last edited by DukeNuke2; 11-03-2009 at 08:32 AM.. Reason: please use CODE tags for code!
# 2  
Old 11-03-2009
Time to buy another terabyte of RAM Smilie
# 3  
Old 11-03-2009
Please check for any idling..
Maybe your DBA will know better which are the processes that can be killed. There could be some processes not terminated by themselves

Last edited by incredible; 11-03-2009 at 10:14 AM..
# 4  
Old 11-03-2009
Thx incredible for the suggestion, but i didn't got your point what I have check?

What you mean by idling?
# 5  
Old 11-03-2009
Quote:
Originally Posted by Asteroid
Thx incredible for the suggestion, but i didn't got your point what I have check?

What you mean by idling?
it just means the processor is doing nothing..as you run other apps you will see it dropping down from 100%....I would get worried if it were running at 0% as then you would have problems. It just means it is 100% idle.

---------- Post updated at 10:27 PM ---------- Previous update was at 10:25 PM ----------

And also would like to check the amount of physical memory in your system plus the assigned swap space.. Is your swap equivalent or more than your physical RAM?
# 6  
Old 11-03-2009
Swap
Code:
bash-3.00# swap -s
total: 9051592k bytes allocated + 2947960k reserved = 11999552k used, 2640008k available

Physical

Code:
bash-3.00# prtdiag -v | grep Memory
Memory size: 8184 Megabytes

# 7  
Old 11-03-2009
Don't focus on this bogus statistic. You simply can't have 1+ TB (1024 GB) used when 8 GB is installed. Have a look at the prstat manual page (last sentence) for a clue.

On the other hand, you have allocated 9 GB of memory so there is a RAM shortage in your box.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Solaris

Capture PRSTAT based on CPU usage percentage

Hi, Recently i have write a simple script to capture CPU high usage based on prstat but i found out that it did capture correctly. I need to capture the rows that contains CPU usage more than 3%. Below line which i thought will capture CPU usage based CPU column in prstat(9th parameter) which is... (3 Replies)
Discussion started by: tharmendran
3 Replies

2. UNIX for Dummies Questions & Answers

Memory usage per user,percent usage,sytem time in ksh

Let's say i have 20 users logged on Server. How can I know how much memory percent used each of them is using with system time in each user? (2 Replies)
Discussion started by: roy1912
2 Replies

3. UNIX for Dummies Questions & Answers

Command to display the space usage (memory usage) of a specific directory.

Hi all, Can you please tell me the command, with which one can know the amount of space a specific directory has used. df -k . ---> Displays, the amount of space allocated, and used for a directory. du -k <dir name> - gives me the memory used of all the files inside <dir> But i... (2 Replies)
Discussion started by: abhisheksunkari
2 Replies

4. Solaris

prstat RSS memory

Hi everyone, was hoping someone might be able to help me understand what I am seeing on one of our solaris systems. prstat -s size -a is showing user oradba as being top virtual memory consumption. 639 oradba 3012G 2951G 100% 59:44:01 25% why is it saying 3012G size and 2951G RSS... (6 Replies)
Discussion started by: k4boy
6 Replies

5. Solaris

Free memory in top and prstat command

Hi Export, i execute 'top' command to show the free memory in Solaris host, but the read is much lower than the RSS value shown in prstat command. Which one can reflect the real status and it is possible the difference caused by any patch of OS? Top command (only 883 memory is free)... (3 Replies)
Discussion started by: eiga
3 Replies

6. AIX

How to monitor the IBM AIX server for I/O usage,memory usage,CPU usage,network..?

How to monitor the IBM AIX server for I/O usage, memory usage, CPU usage, network usage, storage usage? (3 Replies)
Discussion started by: laknar
3 Replies

7. Solaris

current CPU usage, memory usage, disk I/O oid(snmp)

Hi, I want to monitor the current cpu usage, monitor usage , disk I/o and network utlization for solaris using SNMP. I want the oids for above tasks. can you please tell me that Thank you (2 Replies)
Discussion started by: S_venkatesh
2 Replies

8. 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

9. UNIX for Dummies Questions & Answers

Usage of prstat -j option.

Hi, I need to capture output of prstat command for certain pid's .I found it as prstat -j filename. I created a filename projlist gave the pid number on the projlist file and run the cmd like this >prstat -j projlist prstat: illegal argument -- projlist can anybody suggest how to... (1 Reply)
Discussion started by: vipin771
1 Replies

10. Solaris

Top and Prstat display different results for memory

I have a question about the accuracy of prstat. I did a 'prstat -t' and it shows 99% of my memory is occupied by oracle. NPROC USERNAME SIZE RSS MEMORY TIME CPU 194 oracle 343G 340G 99% 86:17.24 56% However, 'top' shows I still have 7762meg of memory free. Memory: 16G real, 7762M... (4 Replies)
Discussion started by: zen03
4 Replies
Login or Register to Ask a Question