UTLBSTAT/UTLESTAT: System wide wait events

From: Glenn Stauffer <stauffer_at_swarthmore.edu>
Date: 1997/03/14
Message-ID: <01bc30ae$9f97a6d0$2d433a82@hallucigenia>#1/1

In the process of analyzing performance on an Oracle 7.2.3 instance, I am seeing some things in the system wide wait events section of the bstat/estat report that I am concerned about. Unfortunately, I've not found any real good documentation on this report or these items. Can someone tell me what this means or point me toward some good documentation?  In general, does this look bad?

Thanks,

Glenn Stauffer

SQLDBA> 
SQLDBA> set charwidth 27;
SQLDBA> set numwidth 12;
SQLDBA> Rem System wide wait events.
SQLDBA> select 	n1.event "Event Name", 
     2>        	n1.event_count "Count",
     3> 	n1.time_waited "Total Time",
     4> 	(n1.time_waited/n1.event_count) "Average Time"
     5>    from stats$event n1
     6>    where n1.event_count > 0
     7>    order by n1.time_waited desc;
Event Name                  Count        Total Time   Average Time
--------------------------- ------------ ------------ ------------
SQL*Net message from client        25209      5205448 206.49164981
rdbms ipc message                   4149      2877828 693.61966739
Slave DBWR Timer                    5970      2874885 481.55527638
virtual circuit status               120       360027     3000.225
dispatcher timer                      60       360018       6000.3
smon timer                            12       360004 30000.333333
pipe get                             719       359658 500.21974965
pmon timer                          1211       359342 296.73162675
latch free                          9786        39649 4.0516043327
db file sequential read             8392         6563 .78205433746
db file scattered read              2664         1033 .38776276276
log file sync                        334          635 1.9011976048
DBWR I/O to Slave                   1369          233 .17019722425
log file parallel write              522          195 .37356321839
rdbms ipc reply                       95          174 1.8315789474
db file parallel write               301          157 .52159468439
SQL*Net break/reset to clie           98          125 1.2755102041
enqueue                                2           45         22.5
SQL*Net message to client          25231           30 .00118901352
control file parallel write           26           15 .57692307692
log file space/switch                  1           12           12
SQL*Net more data from clie            3            5 1.6666666667
write complete waits                   2            1           .5
db file single write                  14            1 .07142857143
log file sequential read               1            0            0
SQL*Net more data to client            2            0            0
control file sequential rea           24            0            0
log file single write                  2            0            0

28 rows selected. Received on Fri Mar 14 1997 - 00:00:00 CST