Re: wait events

Buy
Steve Adams, Oracle8i internal services for waits, latches and memory, ISBN 1-56592-598-X, $19.95
It will learn to interpret you those results.

Regards,

Sybrand Bakker, Oracle DBA

<fly13_at_my-deja.com> wrote in message news:8s4296$2t5$1_at_nnrp1.deja.com...
> hi girls and boys,
> I use the statspack of oracle to tune my database, and i can see in the
> table concerning waiting events :
>
> Avg
> Total Wait wait
> Waits
> Event Waits Timeouts Time (cs)
> (ms) /txn
> ---------------------------- ------------ ---------- ----------- ----- -
> -----
> control file sequential read 33 0 6
> 2 33.0
> control file parallel write 50 0 4
> 1 50.0
> refresh controlfile command 5 0 2
> 4 5.0
> direct path read 832 0 1 0
> 832.0
> direct path write 644 0 0 0
> 644.0
> log file parallel write 9 0 0
> 0 9.0
> SQL*Net break/reset to clien 4 0 0
> 0 4.0
> file open 4 0 0
> 0 4.0
> LGWR wait for redo copy 1 0 0
> 0 1.0
> log file sync 1 0 0
> 0 1.0
> SQL*Net message from client 84 0 3,042
> 362 84.0
> SQL*Net message to client 84 0 0
> 0 84.0
> -------------------------------------------------------------
>
> Background Wait Events for DB: DBTEST Instance: dbtest Snaps:
> 1 -
>
>
>
> Avg
> Total Wait wait
> Waits
> Event Waits Timeouts Time (cs)
> (ms) /txn
> ---------------------------- ------------ ---------- ----------- ----- -
> -----
> control file parallel write 50 0 4
> 1 50.0
> control file sequential read 15 0 2
> 1 15.0
> log file parallel write 8 0 0
> 0 8.0
> LGWR wait for redo copy 1 0 0
> 0 1.0
> rdbms ipc message 171 150 8,514 498
> 171.0
> pmon timer 50 50 2,764
> 553 50.0
> -------------------------------------------------------------
>
> SQL ordered by Gets for DB: DBTEST Instance: dbtest Snaps: 1 -
> 2
>
> So i would like to know if anybody can tell what i could to do to
> decrease waiting times.
>
> Thanks
>
> See you
>
> Fly13
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 13 2000 - 00:39:57 CDT