| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: vmstat
Hi Dave,
We are using AIX and we start to be concerned about memory issues when SR
parameter is high. This represents the number of memory pages scanned by
the page-replacement algorithm. Usually ,when this value is high , PI
(pages paged in from paging space) and PO (pages paged out to paging space)
are high also.
In your example , the system is totally idle and you have some pages being paged out to paging space (PO = 8). Maybe , with full workload , this system will not be able to perform.
I suggest , if possible , you take several vmstat snapshots with different workloads and check the values.
Here is a sample of vmstat taken from my production server , if you wish to
compare:
kthr memory page faults cpu
----- ----------- ------------------------ ------------ -----------r b avm fre re pi po fr sr cy in sy cs us sy id wa 0 0 180150 7492 0 0 0 52 118 0 31 23 52 21 11 54 14 2 1 180150 7471 0 0 0 0 0 0 467 1426 168 54 2 44 0 2 1 180150 7456 0 0 0 0 0 0 474 1153 180 49 1 49 0 2 1 180150 7465 0 0 0 0 0 0 504 3385 312 53 2 44 1 2 1 180150 7456 0 0 0 0 0 0 466 1068 164 49 2 49 0 2 1 180150 7468 0 0 0 0 0 0 488 1304 180 49 1 49 1
HIH,
Antonio Belloni
Oracle DBA
David Turner <turner_at_elvis.mu.org>@fatcity.com on 08/11/2000 15:40:30
Please respond to ORACLE-L_at_fatcity.com
Sent by: root_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: vmstat
I am seeing a lot of de on one of my machines and I thought this was a sign that we would be running into memory issues soon, but was told by a sys admin that this was normal.
Any help on this is appreciated. I have looked at the man page and de is
expected shortfall so I would think this is a sign that we need more
memory.
I understand that much of memory can be used for file caching which throws
off
the stats, but that doesn't help me see where we are . Any pointers to
other info
is appreciated too.
Dave Turner
procs memory page disk faults cpu
r b w swap free re mf pi po fr de sr s0 s1 s6 sd in sy cs us sy
id
0 0 0 5800 5832 1 18 0 31 33 38312 0 0 0 0 5 172 701 412 2 1
97
0 0 0 3717664 64328 1 1 0 8 8 31040 0 0 0 0 1 208 520 322 1 0
99
0 0 0 3717664 64328 1 0 0 8 8 25144 0 0 0 0 1 231 690 387 1 1
98
0 0 0 3717664 64328 0 0 0 8 8 20376 0 0 0 0 1 307 1228 536 1 0
99
0 0 0 3717664 64328 1 0 0 8 8 16512 0 0 0 0 2 139 183 161 0 0
100
0 0 0 3717664 64328 1 0 0 8 8 13384 0 0 0 0 1 193 477 284 0 0
99
0 0 0 3717664 64328 0 0 0 0 0 10848 0 0 0 0 0 172 359 240 0 0
100
0 0 0 3717664 64328 1 0 0 8 8 8792 0 0 0 0 1 143 196 189 0 1
99
0 0 0 3717664 64328 1 0 0 8 8 7128 0 0 0 0 3 183 563 271 0 0
100
0 0 0 3717512 64280 0 187 0 4 4 19928 0 0 0 0 2 264 1046 425 1 1
98
0 0 0 3717664 64320 1 0 0 20 20 16144 0 0 0 0 3 171 339 242 0 1
99
0 0 0 3717664 64344 1 0 0 8 8 13088 0 0 0 0 1 204 460 306 0 0
100
0 0 0 3717664 64344 0 0 0 0 0 10608 0 9 0 0 0 190 152 142 0 1
99
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: turner_at_elvis.mu.org Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Wed Nov 08 2000 - 14:35:36 CST
(or the name of mailing list you want to be removed from). You may
 |
 |