Re: reduce wait times

"gp" <gieppetto_at_tiscali.it> wrote in message news:<c0i34i$plh$1_at_fata.cs.interbusiness.it>...
> statsrep :

> Top 5 Wait Events
> ~~~~~~~~~~~~~~~~~ Wait %
> Total
> Event Waits Time (cs) Wt
> Time
> -------------------------------------------- ------------ ------------ -----
> --
> db file sequential read 278,792 144,794
> 22.61
> db file parallel write 5,523 133,218
> 20.81
> direct path read 151,858 93,521
> 14.61
> db file scattered read 147,833 72,720
> 11.36
> log file parallel write 27,277 62,366
> 9.74

there you have it.
why are you wondering about SQL*Net when you have such a large amount of IO to your temporary tablespace?

sequential read
direct path read
scattered read

the parallel write waits will be reduced after you reduce the amount of physical IO produced by the above 3 events.

code into your app to take statspack snapshots at significant points. Investigate statements that produce large physical IOs (or logical IOs for that matter) and sort operations.

Pd Received on Fri Feb 13 2004 - 20:16:54 CST