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