Re: reduce wait times

my problem is that the 90% of i/o operations and query executions is made from an application external that i cannot modify, so i try to adjust performance without modify sql statements.

thanks.

"Paul Drake" <drak0nian_at_yahoo.com> ha scritto nel messaggio news:1ac7c7b3.0402131816.195364c6_at_posting.google.com...
> "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