Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Statspack
After a very quick glance I would concentrate on tuning your most disk
heavy SQL statements...
Your times for your waits are much higher than that for service time (i.e. CPU) so you should aim to reduce the waits first.....
Nearly all of your wait time is made up of datafile I/O.... Therefore look into the section which lists your SQL by disk reads....
91 % of the waits are down to index lookups (sequential reads) so alot of your SQL may be running off unselective indexes.
> Top 5 Wait Events
> ~~~~~~~~~~~~~~~~~ Wait %
> Total
> Event Waits Time (cs) Wt
> Time
> --
> db file sequential read 822,208 167,102
> 91.75
> db file scattered read 28,633 12,524
> 6.88
> log file sequential read 2,379 541
> .30
> log file parallel write 35,877 486
> .27
> file open 133 421
> .23
> -------------------------------------------------------------
> Instance Activity Stats for DB: IFSL Instance: ifsl Snaps: 39 -40
>
> Statistic Total per Second per Trans
> --------------------------------- ---------------- ------------ ------------
> CPU used by this session 49,280 12.9 1.4
> CPU used when call started 49,257 12.8 1.4
Cheers
Matt Received on Thu Apr 29 2004 - 02:31:35 CDT