Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: IO wait
interestingly... the "b" column of *my* AIX also shows "2" continiously
!!!!!
kthr memory page faults cpu
----- ----------- ------------------------ ------------ -----------r b avm fre re pi po fr sr cy in sy cs us sy id wa 0 2 200034 3088 0 0 0 0 0 0 555 2139 1592 1 3 95 1 0 2 200279 2822 0 2 0 0 0 0 561 2048 313 2 2 95 2 1 2 200654 2397 0 1 0 0 0 0 568 7397 8371 16 14 68 3 1 2 200718 2077 0 3 0 0 0 0 675 3235 1394 8 5 82 5 0 2 200034 2778 0 0 0 0 0 0 541 1428 271 0 1 98 0 0 2 200034 2777 0 0 0 0 0 0 566 1540 311 1 2 97 1 0 2 200034 2777 0 0 0 0 0 0 531 3556 251 10 6 84 0 2 2 200034 2770 0 0 0 0 0 0 550 2942 2847 4 4 90 1
all systems are running fine without any IO (or other performance ) problems... !!
regards
Rahul
> ----------
> From: John Kanagaraj[SMTP:john.kanagaraj_at_hds.com]
>
> Some remarks: (not an answer!) The first line of vmstat/iostat output is
> an
> average since restart. The 'wa' is 32 and you have 4 processes blocked on
> average. Was there a problem (or a large load) since your last restart
> that
> was since solved? If not, this may just be the average load... On the
> other
> hand, you aren't currently paging in/out nor have an abnormal amount of
> context switches (cs) or system calls (sy), so why should two processes be
> "blocked for resources I/O, paging, and so forth" (as per man page).
> Worth
> investigating! Unfortunately, *NIX does not provide the equivalent of V$
> views so we really cannot dig into the details.
>
>
> > -----Original Message-----
> > From: Post, Ethan [mailto:Ethan.Post_at_ps.net]
> > kthr memory page faults cpu
> > ----- ----------- ------------------------ ------------ -----------
> > r b avm fre re pi po fr sr cy in sy cs us sy id wa
> > 0 4 754461 3196 0 15 12 299 242 0 596 448 294 53 17 99 32
> > 0 2 754461 3195 0 0 0 0 0 0 503 1672 123 0 0 99 0
> > 0 2 754461 3195 0 0 0 0 0 0 509 787 125 0 0 99 0
> > 0 2 754461 3171 0 0 0 0 0 0 540 830 148 0 1 98 1
> > 0 2 754461 3167 0 0 0 0 0 0 503 783 120 0 0 99 0
> >
> > John,
> >
> > I think I recall some references in the past that would state
> > that what you
> > see above is a problem (the 2 blocked processes in the "b"
> > column). However
> > we are not suffering any type of obvious problems that I am
> > aware of. Is
> > there a way to determine what these processes are?
> >
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: rahul_at_ratelindo.co.id 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-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Jul 24 2002 - 23:28:24 CDT