"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:4098e199$0$20516$ed9e5944_at_reading.news.pipex.net...
> "Charles Davis" <cdavis10717_at_comcast.net> wrote in message
> news:4cadnR3Xs8IqSgrdRVn-ug_at_comcast.com...
> > When running STATSPACK reports I see some Datafile I/O Avg Read Times of
> > 10's of thousands of ms. Such as 85,000 Avg Read Times in
millisenconds.
> > Wow!!
> >
> > Is STATSPACK accurate? can it be i have Oracle waiting 85 seconds on
> > average to read a block from a file?
> >
> > With each 24 hour snap I see similar and higher numbers, but always on
> > different files.
> >
> > Am beginning to think a problem with the storage array...
> >
> > All disk files are on EMC disks using PowerPath an SRDF.
> >
> > Appreciate anyone's opinion or feedback.
>
> I agree with the others that 24 hours is far too long, even for a
baseline.
> One gotcha might be if you were running spreport from a 8i client install
> against a 9i db. I'd expect the report not to work, but if it did work the
> fact that the granularity of the waits changed from cs to us might explain
> your results.
OK scratch that - I do have an 817 version of spreport available and it
fails against 9.2 to the above suggestion is probably incorrect.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
http://www.niall.litchfield.dial.pipex.com/
Received on Wed May 05 2004 - 07:48:06 CDT
