help with vmstat output


 
Thread Tools Search this Thread
Operating Systems Solaris help with vmstat output
# 1  
Old 06-14-2010
help with vmstat output

Hi all.
I need some assistance with my vmstat output.

We have several oracle db's running on our solaris machine:

SunOS rcworaprd 5.9 Generic_112233-07 sun4u sparc SUNW,Sun-Fire-480R

Recently I bumped up our main Oracle database to use 6 GB instead of 4 GB as vmstat output was showing I had over 5 GB free memory... After I completed that I noticed swap space dropped to about 60MB free but free memory didn't. I kind of assumed that the free memory would drop 2 GB but it stayed the same. I added a swap file of 1 gb and now swap free shows 900 MB.

Can anyone give me some detailed instructions on what I should be looking for in my vmstat output. I'm pretty new with Solaris admin.

Thanks

Here's a smaple of my current vmstat output:

Code:
kthr      memory            page            disk          faults      cpu
 r b w   swap  free  re  mf pi po fr de sr s0 s1 sd sd   in   sy   cs us sy id
 0 0 0 893728 5775000 3444 0 22925 0 0 0 0  0 673 0  0 1237 7285 1229 57  7 36
 0 0 0 893728 5774280 2816 917 19781 0 0 0 0 0 657 0 6 1288 9245 1459 62  6 31
 0 36 0 893704 5771968 1415 75 12283 0 0 0 0 0 696 0 0 1354 9229 2117 60  4 36
 0 0 0 894672 5768056 522 920 848 0 0 0  0  0 112 0 19  788 33483 1359 67 5 28
 0 0 0 895600 5761152 434 67 677 0 0  0  0  0 124 0  2  665 16838 1274 59 3 38
 0 2 0 892392 5751880 420 963 732 0 0 0  0  0 169 0  3  967 16859 1581 66 7 27
 0 1 0 890664 5745408 194 38 685 0 0  0  0  0 101 0  3  763 17101 1473 65 2 32
 0 0 0 892312 5741992 250 0 728 0  0  0  0  0 195 0  3 2515 24245 5847 63 5 32
 0 1 0 904616 5749352 233 500 685 8 8 0  0  0 221 0  3 2879 31744 7386 65 10 25
 0 1 0 926408 5768832 210 957 1194 8 8 0 0  0 126 0  6 2827 38939 7373 61 8 30
 0 0 0 926408 5765640 95  0 681 0  0  0  0  0 182 0  6 3595 36068 7633 81 8 10
 0 1 0 925008 5762032 146 465 677 0 0 0  0  0 186 0  1 3100 29431 6172 87 5  8
 0 0 0 926376 5760080 143 1124 597 0 0 0 0  0 77  0  4 3671 34577 7111 82 10 7
 0 1 0 926144 5756920 70 29 561 0  0  0  0  0 393 0  5 4878 32399 10210 71 13 16
 0 2 0 927664 5756624 34 12 386 0  0  0  0  0 219 0  0 1077 15281 2344 56 2 42
 0 0 0 929464 5755784 41  0 681 0  0  0  0  0 89  0  5  874 19636 1807 64 5 32
 0 0 0 929488 5752136 278 9 72  0  0  0  0  0 318 0  5 1322 12216 2393 81 2 17
 0 0 0 929216 5750232 2  35 16  0  0  0  0  0 11  0  0 1898 18062 2900 91 8  1
 1 0 0 931752 5751768 3 123  4  0  0  0  0  0  8  0 22 3776 23215 6599 87 10 3

# 2  
Old 06-21-2010
looks like your ammendment has not still been effective in oracle. I'm not an oracle expert, but here are few things which may help:

You have a lot of Page-In (pi) which is showing something really eating up your real memory in terms of capture and not being released up, even though the page schedular does it at sometime to release those pages not in use since last count.

suddenly there is a number in 'b' column as well, which means that some of the processes are put in the wait list for the resources to be free'd. This looks anonymous who's taking all this much.

In actual, if you have taken in consideration with Oracle ( like increasing the shmmax and others ) then Oracle should be using that sga area. if you share something like prstat and psrinfo with details, it might help who's taking up the pretty expensive resources .

Regards,
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Solaris

Reason for abnormal value in vmstat output

Hi, Recently from the vmstat output in the image attached, the first line of the cpu idle column shows a value of 15. Although the subsequent values show higher than 90, is there a reason why the first value is so low? Is this a problem? Thanks. (4 Replies)
Discussion started by: anaigini45
4 Replies

2. Linux

Vmstat

I m checking idle time using vmstat, below are the results var=$(ssh wmtmgr@$hostname vmstat | tail -1 | awk '{print $15}') 89 and now im subtracting 89 with 100 & im getting expected results expr 100 - $var 11 Now How can I get the result 11 in one line code? (4 Replies)
Discussion started by: sam@sam
4 Replies

3. UNIX for Dummies Questions & Answers

Pls. help with vmstat output...

Hi, Users are reporting performance issue on my Sun Solaris 10 server. I am on the server. I don't see a issue or I might be looking at the wrong thing. Please help. I don't see anything on sar. it's all zero on that. Not sure why users are reporting high CPU and unresponsive at times. ... (1 Reply)
Discussion started by: samnyc
1 Replies

4. Solaris

Different VMSTAT output on Linux and Solaris machines

Hi, I am porting a piece of code from Solaris to Linux. Code uses VMSTAT command. On Solaris machine VMSTAT output is following: uname -a: SunOS rgsm01 5.9 Generic_118558-03 sun4u sparc SUNW,Sun-Fire-V440 vmstat: kthr memory page disk faults cpu r b w swap free re mf pi po fr de sr m1 m2... (3 Replies)
Discussion started by: Basant Mishra
3 Replies

5. AIX

fr and sr (from vmstat output) values are very high

Hi AIX Expert, the fr (page freed/page replacement) and sr (pages scanned by page-replacement algorithm) values from the vmstat output (see below please) are very high. I usually see this high value during the oracle database backup. In addition, the page scan/page steal/ page faults values... (7 Replies)
Discussion started by: Beginer0705
7 Replies

6. AIX

vmstat incomprehensible output

Hello everybody, When i run Nmon the output is really incomprehensible vmstat 5 System configuration: lcpu=16 mem=24576MB ent=4.00 kthr memory page faults cpu ----- ----------- ------------------------ ------------ -----------------------... (3 Replies)
Discussion started by: Vit0_Corleone
3 Replies

7. UNIX for Advanced & Expert Users

vmstat's cpu stats on first line of output are always the same

Hello, I'm seeing this problem with vmstat, where the first line of output always has the same CPU statistics. For example: neked@nekedmachine:~$ date && vmstat Fri Jul 24 06:57:08 EDT 2009 procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------ r b swpd ... (0 Replies)
Discussion started by: neked
0 Replies

8. Shell Programming and Scripting

Capturing and sending of vmstat output everyday

I need to capture the vmstat output of a server every 5 minutes, in a text filename with the name in the format vmoutput. yesterday's date.txt. I need to get the vmstat o/p for the whole day with 5 minutes interval and send it (preferably ftp) to my local desktop folder. eg: vmstat 300... (1 Reply)
Discussion started by: yuvanash
1 Replies

9. UNIX for Dummies Questions & Answers

vmstat output with date & timestamp

Hello all This is a sample vmstat output ... $ vmstat 2 2 kthr memory page disk faults cpu r b w swap free re mf pi po fr de sr hx hx hx hx in sy cs us sy id 1 0 0 23105784 7810488 323 767 1742 5 5 0 0 0 0 0 0 683 780 457 43 ... (9 Replies)
Discussion started by: luft
9 Replies

10. UNIX for Advanced & Expert Users

output of vmstat

i have 2 question about vmstat 1) pin (pagein) output of vmstat is always zero for our system what is the meaning of this? (pout significantly changes depending on the running processes) 2) sometimes react output of vmstat is given in K like 44K sometimes it is given without any unit... (1 Reply)
Discussion started by: gfhgfnhhn
1 Replies
Login or Register to Ask a Question