Re: V$SYSTEM_WAIT_CLASS

dean wrote:
> 10g
>
> select * from V$SYSTEM_WAIT_CLASS order by TIME_WAITED desc;
>
> WAIT_CLASS_ID WAIT_CLASS# WAIT_CLASS TOTAL_WAITS TIME_WAITED
> ------------- ----------- -------------- ----------- -----------
> 2723168908 6 Idle 15742538 990583927
> 1740759767 8 User I/O 1501104 541245
> 2000153315 7 Network 35587647 227757
> 4108307767 9 System I/O 690084 194154
> 3386400367 5 Commit 70951 23803
> 3875070507 4 Concurrency 11212 13790
> 4217450380 1 Application 12112 5730
> 1893977003 0 Other 7106 5411
> 3290255840 2 Configuration 171 1979
>
> This is the first time I have looked at this view, and I'm trying to
> understand it - does this indicate performance issues with the disk i/
> o?
>
> Thanks!
>
> Dean

Is anyone complaining about any aspect of performance? If not then save this away. Run another one every week and watch for significant changes over time. If someone complains about something then see what has changed.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org