Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: oracle is causing high WIO

RE: oracle is causing high WIO

From: raja rao <raja4list_at_yahoo.com>
Date: Mon, 24 Oct 2005 19:06:14 -0700 (PDT)
Message-ID: <20051025020614.47382.qmail@web31407.mail.mud.yahoo.com>


Hi Kanagaraj,  

At last we identified the root cause is the px slaves. When we removed them from the init and bounced the instance, everything became normal.  

Thanks for the help. However, I will collect all the stuff that is provided by our forum members.  

Thanks to everyone who helped me for this.  

Thanks,
Raj

John Kanagaraj <john.kanagaraj_at_hds.com> wrote: Raja,  

Were there any recent changes (on both Oracle and UNIX side)? High WIO could also be caused by heavy swapping (not just paging). Use sar -q to see the swap queue and sar -d to determine which disk (or LUN) is causing this issue... Did you have any memory errors that required a reboot and the Sa just pulled out some memory cards? Could be a lot of things, not necessarily Oracle.  

John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)  

Co-Author: Oracle Database 10g Insider Solutions http://www.samspublishing.com/title/0672327910  


From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of raja rao Sent: Monday, October 24, 2005 9:26 AM
To: ganstadba_at_hotmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: oracle is causing high WIO

even after the startup restrict also the below is the WIO:  

$ sar -u 2 5
SunOS oracle 5.9 Generic_117171-02 sun4u 10/24/2005

12:09:30    %usr    %sys    %wio   %idle
12:09:32      11       6      64      19
12:09:34      12       7      66      16
12:09:36       4       1      90       6
12:09:38       0       0      94       5
12:09:40       0       0      90      10
$                 

 Yahoo! FareChase - Search multiple travel sites in one click.
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 24 2005 - 21:08:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US