Re: Determining what is causing high wio%

Neil Greene wrote:
>
> Neil Greene wrote:
> >
> > I have an E5000s (6 cpu/1.0 Gb ram) running Oracle Financials 10.6.1
> > (about 7-8 development databases) Oracle RDBMS 7.1.6.2, Solstice Backup
> > 4.2.2 (Networker), and Patrol agent.
> >
> > This particular machine has 3 IO cards attached to it. Cards 1 and 3
> > are each connected to 1 RSM214 storage array, each on channel b. IO
> > card #5 is connected to 2 additional storage arrays for fail over on
> > channels a and b.
> >
> > I have noted a high percentage of wio on the system anywhere from
> > 70-80%. I first thought it was the DLT tape device connected through
> > Solstice Backup, so I turned Networker off to see if this solved my
> > problem. Still, high wio%. I next turned off Patrol, still high wio%.
> > Next, I am going to shut down all of the financials databases and their
> > associated processes.
> >
> > What is a good solution to determine what is causing high wio%?
>
> Well....I determined the cause of the high percentage of wio% was coming
> from the databases running on the system. After starting one instance,
> the system averaged around 26% wio, after starting the second instance,
> 46-50% wio, and the % increased as additional databases were started.
>
> Has anyone else noticed this same problem or cpu usage??

Here I go answering my own questions again. You would think this was an Oracle tar. Anyway, looking at my cpu and system statistics from vmstat....I see what I expect to see. CPU utilization is around 20-30 user, 10-15 sys and 40-50 idle. That is how the system "feels" like it is running and what I would expect. And yet, iostat, mpstat and sar report different numbers with high wio%.

Has anyone else experienced these problems on Solaris 2.5.1 (no patches on this particular system) and other programs?

-- 
Neil Greene
Senior System Engineer / Oracle DBA		"Tyra, you left your toobrush
MCI Systemhouse, Inc. 				at my house last night."
email: ngreene_at_laoc.SHL.com