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: ketan Parekh <ketanparekh_at_sbcglobal.net>
Date: Wed, 05 May 2004 06:30:55 GMT
Message-ID: <zS%lc.60347$BO4.45610@newssvr25.news.prodigy.com>


Agreed - try to have 30 min snaps - narrow down your snaps when you are seeing more IO..

"Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:fdtg9017mn4evtqolav5543dav3ubko3pt_at_4ax.com...
> On Tue, 4 May 2004 13:49:45 -0400, "Charles Davis"
> <cdavis10717_at_comcast.net> wrote:
>
> >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.
>
> No reason why STATSPACK isn't accurate. But then again a 24 hour
> interval may not provide meaningful results anymore, if you have 24
> hours betweeen your snapshots.
>
>
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Wed May 05 2004 - 01:30:55 CDT

Original text of this message

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