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