Re: Statspack report for you to look at

EdStevens wrote:
> Martin T. wrote:
> > Hello,
> >
> > I've run a statspack report of our not-quite-behaving test system and
> > will try to figure out what means what over the next days.
> >
> > Maybe someone would be interested in looking at it shortly and point me
> > at things that look fishy at a glance. Would be great!
> >
> > Otherwise maybe you have good pointers on resources that explain the
> > statspack report.
> >
> > thanks, br,
> > Martin
> >
> >
> > ****************************************
> >
> <snip>
>
> Take a look at www.oraperf.com. Very good tool for summarizing and
> analyzing statspack reports.

Hmm ... I can see from the report that there seems to be a lot of physical IO.
The buffer cache size seems to be set to 25MB (DB_CACHE_SIZE). We have set the pga_aggregate_target to 256MB a while back because that was sized way too low.

Anyone thinks playing with the buffer cache size might pay off, given the figure of 55% of the time spent on "db file scattered read" ... ?

thanks,
Martin Received on Sat Jan 20 2007 - 07:59:05 CST