V$SYSTEM_WAIT

From: dean <deanbrown3d_at_yahoo.com>
Date: Mon, 13 Aug 2007 05:10:29 -0000
Message-ID: <1186981829.298690.273420@q75g2000hsh.googlegroups.com>

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 Received on Mon Aug 13 2007 - 00:10:29 CDT