| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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 <raja4list_at_yahoo.com> 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_at_hotmail.com> 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
 |
 |