It's an Oracle ASM enviornment. It has 15.5GB of RAM where SGA is taking 9GB out of that. The Oracle DBA suggests to set lock_sga=TRUE, and there is additional settings from AIX side but I'm not sure what it is to make lock_sga=TRUE.
You're so right. The free list is very very low..and that caused a lot of performance problem.
Also In Oracle, the SGA_TARGET parameter manages memory inside the database. Do you know what is the parameter on AIX that automatic manage memory for the I/O buffer cache and application cache?
I'm a beginner to AIX. Thanks for your insight!
Sam -
Code:
System configuration: lcpu=8 mem=15424MB
kthr memory page faults cpu time
----------- --------------------- ------------------------------------ ----------- ------- ----------- --------
r b p avm fre fi fo pi po fr sr in sy cs us sy id wa hr mi se
1 1 0 3394322 67820 33 77 0 0 103 197 347 16926 3702 7 2 89 3 00:36:52
---------- Post updated at 01:48 AM ---------- Previous update was at 01:44 AM ----------
By the way, the system is now a little quite. It's extremely busy with very little "free list" when the RMAN database backup running.
---------- Post updated at 01:49 AM ---------- Previous update was at 01:48 AM ----------
Code:
vmstat -s
2371477560 total address trans. faults
32145399 page ins
72931135 page outs
1897 paging space page ins
2707 paging space page outs
0 total reclaims
905517288 zero filled pages faults
62779256 executable filled pages faults
186955953 pages examined by clock
110 revolutions of the clock hand
97559480 pages freed by the clock
23360510 backtracks
0 free frame waits
0 extend XPT waits
2245184 pending I/O waits
105074996 start I/Os
6878603 iodones
3508959323 cpu context switches
329345963 device interrupts
55512985 software interrupts
1691341351 decrementer interrupts
46873 mpc-sent interrupts
46873 mpc-receive interrupts
181933 phantom interrupts
0 traps
16044009781 syscalls
vmstat -v
3948544 memory pages
3743595 lruable pages
66387 free pages
4 memory pools
607209 pinned pages
80.0 maxpin percentage
3.0 minperm percentage
90.0 maxperm percentage
8.2 numperm percentage
307386 file pages
0.0 compressed percentage
0 compressed pages
8.2 numclient percentage
90.0 maxclient percentage
307386 client pages
0 remote pageouts scheduled
0 pending disk I/Os blocked with no pbuf
72 paging space I/Os blocked with no psbuf
2228 filesystem I/Os blocked with no fsbuf
3602 client filesystem I/Os blocked with no fsbuf
1801 external pager filesystem I/Os blocked with no fsbuf
0 Virtualized Partition Memory Page Faults
0.00 Time resolving virtualized partition memory page faults
System configuration: lcpu=8 mem=15424MB
kthr memory page faults cpu time
----------- --------------------- ------------------------------------ ------------------ ----------- --------
r b p avm fre fi fo pi po fr sr in sy cs us sy id wa hr mi se
1 1 0 3393363 66250 33 76 0 0 102 197 347 16928 3702 7 2 89 3 00:49:16
Moderator's Comments:
Please use [code] and [/code] tags when posting code, data or logs etc. to preserve formatting and enhance readability, thanks.
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)
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)
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)
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)
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)
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)
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)
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)
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)
01-31-2011
