Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: STATSPACK Report Accuracy???

Re: STATSPACK Report Accuracy???

From: Dusan Bolek <pagesflames_at_usa.net>
Date: 5 May 2004 06:54:09 -0700
Message-ID: <1e8276d6.0405050554.448f9bb3@posting.google.com>


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

Responses from others were solid, but I will add another advice. Ask your EMC administrator for array statistics. EMCs are able to provide you with accurate and quite detailed IO stats.

--
Dusan Bolek
Received on Wed May 05 2004 - 08:54:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US