| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: UTLBSTAT/UTLESTAT: System wide wait events
Glenn,
Some wait events are documented in the Oracle Server Tuning Guide, but there's no single place where you can find documentation on all of them. It's hard to comment on your results without seeing the rest of the report and knowing a bit about your system, but I can say that the first 8 events ("SQL*Net message" to "pmon timer") represent waits which occur while processes are idle. The fact that "latch free" is greater than "db file" waits suggests that you may have a latch contention problem. Another section of the report should list miss rates on the various latches.
-- Guy Harrison ---------------------------------------------------------------------------- ---------- gharriso@werple.net.au | http://werple.net.au/~gharriso | 613 419377964 ---------------------------------------------------------------------------- ---------- Glenn Stauffer <stauffer_at_swarthmore.edu> wrote in article <01bc30ae$9f97a6d0$2d433a82_at_hallucigenia>...Received on Sat Mar 22 1997 - 00:00:00 CST
> 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.
>
>
 |
 |