Re: STATSPACK Report Accuracy???

From: Richard Foote <richard.foote_at_tbigpond.nospam.com>
Date: Wed, 05 May 2004 14:10:17 GMT
Message-ID: <dB6mc.21734$TT.3828@news-server.bigpond.net.au>

"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.
>

Hi Charles,

If you can measure with some accuracy average I/O times with a standard analogue watch (without the second hand) then I strongly suspect that something, somewhere is amiss.

Cheers ;)

Richard Received on Wed May 05 2004 - 09:10:17 CDT