Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr25.news.prodigy.com.POSTED!a558b0ff!not-for-mail Reply-To: "ketan Parekh" From: "ketan Parekh" Newsgroups: comp.databases.oracle.server References: <4cadnR3Xs8IqSgrdRVn-ug@comcast.com> Subject: Re: STATSPACK Report Accuracy??? Lines: 25 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Message-ID: NNTP-Posting-Host: 67.124.249.82 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr25.news.prodigy.com 1083738655 ST000 67.124.249.82 (Wed, 05 May 2004 02:30:55 EDT) NNTP-Posting-Date: Wed, 05 May 2004 02:30:55 EDT Organization: SBC http://yahoo.sbc.com X-UserInfo1: FKPO@MC@OXTYB\LY@BOFO_@@^J^FBL@MAHU^_BAMEH]TCDYG^WH[AACY@TZZXQ[KS^ESKCJLOF_J_NGAWNTG^_XGTNTAHULK[X[NRTC@G\P^PLT_OCBRHUO@@TBQZDZMHD[YZ@NLXQXIWMOSXT_KOLK^^CXFF\WHMI^C@EGA_[FXAQ@E^TGNMUXGYNS[QQVL Date: Wed, 05 May 2004 06:30:55 GMT Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:260803 Agreed - try to have 30 min snaps - narrow down your snaps when you are seeing more IO.. "Sybrand Bakker" wrote in message news:fdtg9017mn4evtqolav5543dav3ubko3pt@4ax.com... > On Tue, 4 May 2004 13:49:45 -0400, "Charles Davis" > 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