oracle is causing high WIO

  • From: raja rao <raja4list@xxxxxxxxx>
  • To: raja4list@xxxxxxxxx, Michael McMullen <ganstadba@xxxxxxxxxxx>, oracle list <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 24 Oct 2005 09:10:27 -0700 (PDT)

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 <raja4list@xxxxxxxxx> wrote:
Yes, 
 
When the db was down, there was no change in WIO.
 
Means, the databse connections are not casing this high WIO.


Michael McMullen <ganstadba@xxxxxxxxxxx> wrote:
OK, but when you had the outage and the database was down did you verify
that wio went down, therefore ruling out the o/s?
I had a similar problem once, huge i/o, I shutdown the database no i/o
problem. On succesful startup and open, huge i/o. I was using startup
restrict. The i/o was oracle doing a parallel transaction recovery even
after the database was open. Lucky it was a box where I could rebuild users
becuase my solution was to drop the user.
----- Original Message ----- 
From: raja rao
To: Michael McMullen ; oracle list
Sent: Monday, October 24, 2005 10:41 AM
Subject: Re: high io on solaris box


Its a production database. The outage window completed. I can no longer take
it down.

any other way to find the high WIO processes ?


Michael McMullen wrote:
When you had the database shut down did you still the the high i/o? What did
ps -ef show you?

Mike



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

Other related posts: