Sponsored Content
Operating Systems AIX fr and sr (from vmstat output) values are very high Post 302492300 by zxmaus on Monday 31st of January 2011 01:16:35 AM
Old 01-31-2011
Hi,

it doesn't matter how high the numbers of sr/fr are by themselves - the only important thing here is the ratio - sr:fr - it should genuinely not be higher than 4:1 - as that is about where performance issues start - if it goes to 10:1 or higher than your system is spending more time freeing up memory than doing real work. In your case it is pretty much 1:1 what is just fine.

Your output above would be more helpful if we would know how much physical memory you have - ideally avm (in 4k pages) should not exceed 75% on an oracle box for best performance since oracle is a process based DB and every process / connection needs some memory on top of the SGA that is set within oracle - if it goes above 85% or if your free list drops against 0 you are in serious trouble as well - or if you start seeing pi/po values ...

Page faults are no reason for concern after all - they only mean that your box is doing work (and using memory pages).
What I would consider reason for concern is your very very low free list. If this is NOT an asm system, than I would recommend to mount your /dumps filesystem with noatime and rbrw option, all other oracle related filesystems with noatime option as well - and to have your DBAs switch oracle to SETALL. This will give your system a lot of desperately needed memory back.

You should as well consider exporting AIXTHREAD_SCOPE=S .... either as system wide variable in /etc/environment or at least in the oracle .profile

If you want more tips please post the vmstat -Iwt output again including your resources, vmstat -s and vmstat -v outputs.

Hope that helps
kind regards
zxmaus
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

reset values for vmstat

How do you reset the values that vmstat displays? Vmstat displays a running average from the last the system was restarted on the first line, how do you reset these values without restarting the system? (Solaris 8) (3 Replies)
Discussion started by: kuczerp
3 Replies

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

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

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

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

6. Solaris

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... (1 Reply)
Discussion started by: jamie_collins
1 Replies

7. AIX

Vmstat fault section all values are 0

Hi all, Recently I facing problem with my AIX server. we experience slowness on performance. there are some application installed in this server such as : Oracle 10g database, control-m client agent, and some monitoring tools. when we're facing the problem we're noticing that vmstat value a... (7 Replies)
Discussion started by: Arief Winanto
7 Replies

8. UNIX for Dummies Questions & Answers

High Load average | vmstat hints what ?

TOP: top - 17:09:39 up 47 days, 1:34, 13 users, load average: 6.54, 10.96, 11.27 Tasks: 274 total, 3 running, 271 sleeping, 0 stopped, 0 zombie Cpu0 : 6.0%us, 44.9%sy, 0.0%ni, 48.8%id, 0.0%wa, 0.0%hi, 0.3%si, 0.0%st Cpu1 : 6.3%us, 44.4%sy, 0.0%ni, 48.0%id, 0.3%wa, ... (2 Replies)
Discussion started by: stunn3r
2 Replies

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

10. 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
All times are GMT -4. The time now is 06:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy