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: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Wed, 05 May 2004 07:04:47 +0200
Message-ID: <fdtg9017mn4evtqolav5543dav3ubko3pt@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 - 00:04:47 CDT

Original text of this message

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