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: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Mon, 24 Oct 2005 14:42:23 -0700
Message-ID: <BEE6A332AA61424EAE305CF89D6F75C81E6C65@USSCCEVS101.corp.hds.com>


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
$
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 24 2005 - 16:44:27 CDT

Original text of this message

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