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 09:25:34 -0700 (PDT)
Message-ID: <20051024162535.66390.qmail@web31408.mail.mud.yahoo.com>


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 <ganstadba_at_hotmail.com> 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
Received on Mon Oct 24 2005 - 11:27:51 CDT

Original text of this message

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