Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: STATSPACK Report Accuracy???
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