Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: STATSPACK Report Accuracy???
"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.
-- Niall Litchfield Oracle DBA Audit Commission UK http://www.niall.litchfield.dial.pipex.com/Received on Wed May 05 2004 - 07:44:09 CDT