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: Tue, 25 Oct 2005 08:13:26 -0700 (PDT)
Message-ID: <20051025151326.55978.qmail@web31401.mail.mud.yahoo.com>


no issue at hardware level. sysadmin checked it.  

The HIGH WIO issue again started at the same interval (yesterday also it happened at the sametime)(  

I suspended all the jobs. still the WIO is high.  

Not sure whichprocess is causing this high WIO.

DEEDSD_at_Nationwide.com wrote:
Pardon the all-caps business that shows my email id - it's a Lotus Notes thing and I haven't gotten around to figuring out how to fix it.

You may want to get your sysadmins involved. Are the controllers insanely high as well (iostat -xnC 1 | grep c)? Has anything changed on the box recently?

We had a server that had something funny happen on either the settings for HBAs or the mount options of the disks after a frame migration. I don't recall what the final resolution was. No activity on the database whatsoever, but the I/O wait was incredibly high and the average service time stunk. Also, try a mkfile on one of the filesystems with Oracle down and see if that makes the associated disk go crazy.

raja rao
T
To: ganstadba_at_hotmail.com
Sent by: cc: oracle-l_at_freelists.org
oracle-l-bounce_at_freelis
ts.org bcc:
Subject: Re: oracle is causing
high WIO

10/24/2005 12:25 PM
Please respond to
raja4list

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

$

CAN SOMEONE hlep me. we are stuck here on the production db.

Michael McMullen wrote:
startup restrict and see what it is doing.
----- Original Message -----

From: raja rao
To: raja4list_at_yahoo.com ; Michael McMullen ; oracle list Sent: Monday, October 24, 2005 12:10 PM
Subject: oracle is causing high WIO

It seems the problem is with oracle.

Now when I shutdown the WIO is 0% AND when i start oracle, it is showing WIO as 80-90%

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

11:54:39 %usr %sys %wio %idle
11:54:41 4 4 85 6
11:54:43 1 2 83 14
11:54:45 1 2 81 16
11:54:47 2 2 82 13

$

how to find out why oracle is causing this high WIO ?

can someone help me

raja rao wrote:
Yes,

When the db was down, there was no change in WIO.

Means, the databse connections are not casing this high WIO.

--

http://www.freelists.org/webpage/oracle-l

Yahoo! FareChase - Search multiple travel sites in one click.

--

http://www.freelists.org/webpage/oracle-l                 



 Yahoo! FareChase - Search multiple travel sites in one click.
--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 25 2005 - 10:15:36 CDT

Original text of this message

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