Re: oracle is causing high WIO

  • From: raja rao <raja4list@xxxxxxxxx>
  • To: ganstadba@xxxxxxxxxxx
  • Date: Mon, 24 Oct 2005 09:25:34 -0700 (PDT)

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@xxxxxxxxxxx> wrote:
startup restrict and see what it is doing.
----- Original Message ----- 
From: raja rao 
To: raja4list@xxxxxxxxx ; 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.

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

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

Other related posts: