Go to the FreeLists Home Page Home Signup Help Login
 



Browse oracle-l: This Month's ArchiveMain Archive PageRelated postsPrevious by DateNext by Date

Re: wio above 20% - is that high?

  • From: Matthew Zito <mzito@xxxxxxxxxxx>
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 2 Dec 2004 08:59:41 -0500
It is almost certainly fine - I've seen many cases where, due to OS or 
driver oddities (especially on Solaris and Linux systems), unused CPU 
time can get accounted for as wio.

In general, if you're concerned that your storage is slow and 
negatively impacting the performance of your database, the key metric 
to look for from the OS perspective is the IO service times.  Ideally, 
IOs on your primary storage devices should not take more than 10ms to 
return - above 12-15ms, the storage will start to "feel" slow.  Of 
course, like anything else, your mileage may vary.

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: mzito@xxxxxxxxxxx
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com


On Dec 2, 2004, at 8:31 AM, susan lam wrote:

> Is the wio below considered too high? One of the folks
> here thinks that as long as there are ample CPU %idle,
> it's fine. I think that wio is fine if it remains in
> the single digit or spikes occasionally but not
> prolong over a long period of time which in my case -
> over 20mins. Also, I think because of the
> high wio, the %usr remains low.
>
> Any thoughts?
>
> thanks.
>
> susan
>
>
> 16:28:06    %usr    %sys    %wio   %idle
> 16:28:10       3       3      22      71
> 16:28:14       2       2      15      80
> 16:28:18       2       3      15      80
> 16:28:22       3       4      20      73
> 16:28:26       2       4      17      77
> 16:28:30       3       4      22      71
> 16:28:34       2       3      17      78
> 16:28:38       2       3      20      75
> 16:28:42       4      22      14      60
> 16:28:46       1      26      11      61
> 16:28:50       2      28      17      52
> 16:28:54       4      24      18      54
> 16:28:58       3      26      22      48
> 16:29:02      15      10      24      51
> 16:29:06      12       6      24      60
> 16:29:10      11       4      18      67
> 16:29:14       3       4      22      71
> 16:29:18       2       4      19      75
> 16:29:22       2       3      17      78
> 16:29:26       4       6      21      70
> 16:29:30       2       4      17      76
> 16:29:34       2       3      18      77
> 16:29:38       3       4      11      82
> 16:29:42       2       2      18      79
> 16:29:46       2       3      17      78
> 16:29:50       2       3      22      74
> 16:29:54       3       4      20      74
> 16:29:58       2       4      16      78
> 16:30:02       4       5      20      72
> 16:30:06       2       2      15      80
> 16:30:10       2       3      13      83
> 16:30:14       4       4      22      70
> 16:30:18       3       4      22      71
> 16:30:22       1       2      12      84
> 16:30:26       3       4      20      73
> 16:30:30       2       4      24      70
> 16:30:34       2       4      15      79
> 16:30:38       2       3      12      83
> 16:30:42       2       3      11      84
> 16:30:46       1       2      16      82
> 16:30:50       3       5      22      71
>
>
>
>               
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - Helps protect you from nasty viruses.
> http://promotions.yahoo.com/new_mail
> --
> http://www.freelists.org/webpage/oracle-l

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

Other related posts:

  • wio above 20% - is that high?
  • Re: wio above 20% - is that high?
  • RE: wio above 20% - is that high?
  • RE: wio above 20% - is that high?




  • [ Home | Signup | Help | Login | Archives | Lists ]

    All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
    Everything else ©2008 Avenir Technologies, LLC.